An error has occurred during report processing. (rsProcessingAborted)
Query execution failed for dataset 'dsResultParam'. (rsErrorExecutingCommand)
Incorrect syntax near ')'.
i heard that the above mentioned error is caused due to migration from SQL 2005 to 2008. Kindly guide how to resolve it
this is the query used
BEGIN DECLARE @TEMP TABLE ( col1 VARCHAR(10), col2 VARCHAR(10)) INSERT INTO @TEMP SELECT distinct col1,col2 FROM DB.table_name UPDATE @TEMP SET col1='NULL' WHERE col1 IS NULL UPDATE @TEMP SET col2 ='NULL' WHERE col2 is NULL SELECT DISTINCT * FROM @TEMP WHERE col1 IN (@P_param_name) END