Month: January 2022

CASE statement issue

January 13, 2022 Andy 0

Question Can anyone help with this error? SQL: Error: Msg 207, Level 16, State 1, Line 13 Invalid column name ‘PurchaseType’. asked 2022-01-13 by Mark_72 Answer This error is coming from your WHERE clause, not your CASE expression. You say WHERE PurchaseType = ‘Top Performer’, … [Read More]