1

Resolved

; missing in import-profile-data.sql

description

I'm investigating this for use in our company and I ran into a missing ; in the import-profile-data.sql script.
SQL gave an error when I ran the batch file saying
"Incorrect syntax near the keyword 'with'. If this statement is a common table expression or an xmlnamespaces clause, the previous statement must be terminated with a semicolon"
 
And that was just the case, just before the 'with cte as' there is a declare statement where the ; is missing at the end.

comments

manowar wrote May 3, 2010 at 2:24 PM

Thanks, it has been fixed now.