Smarlist SQL

[bradth]

I current have a SQL Query that I have written that contains variables (DECLARE @DATE003 datetime, etc.) When I try to place this query in the smartlist builder SQL Script, I get the error "Incorrect syntax near the keyword 'DECLARE'" ODBC error 37000. Any idea why this error displays? With the SQL script, will it not accept variables in smartlist builder? Thanks.

Brad

 

[jymm]

try re-writing the query.

So if after the declare later you have

Set @DATE003 = DATEADD(yy, DATEDIFF(yy,0,getdate()), 0) /*get the first day of the year*/

Just substitute in the 'right side' where there is a variable.

A number of products will support the SQL select, but NOT a SQL Script... not sure if this is the case here (since I did not do the smartlist builder this way) but it sounds like a safe bet