I created macro and get 'Invalid column name' with my syntax. What do I do wrong. Thank you: @Store17 gives me an error. I have similar expression above in the same script, but it works fine.
@STORE16 = SQL('SELECT T0.[U_AT_PROD_CAT] FROM OITM T0 WHERE T0.[ItemCode] = $[$38.1.0]');
@STORE17 = SQL('SELECT CASE WHEN @STORE16 = 'W-CAN-100' OR @STORE16 = 'W-CAN-105' OR @STORE16 = 'W-CAN-120' OR @STORE16 = 'W-CAN-4.5' OR @STORE16 = 'W-CAN-81' THEN 1 ELSE 0 END');
Please sign in to leave a comment.