Hi
I was trying to use a variable in SQL, but I keep getting the same error
The following exception message was returned by the server: Incorrect syntax near the keyword 'DECLARE'. Incorrect syntax near ')'.
Even if I declare as a Int "DECLARE @MyInt Int", where there is no ')' in the code
I found this part in forum (from 2015)
DECLARE @variantId NVARCHAR(4)
SET @variantId='VO16'
And this works fine in DW8, but not in DW9
How do i use declare in DW9 SQL Firehose ?
Regards Thomas