|Do you know where your variables are?|
Re: Win32::ODBC getting syntax error while executing sqlby jonadab (Parson)
|on Nov 26, 2008 at 12:18 UTC||Need Help??|
declare @RepDate datetime
Don't you need a semicolon after this declaration?
select @RepDate = max(Date) from CRRWarehouse..AERReportDate where Date >= '1 jan 2008' and [User] like '%SYS%'
Don't you need a semicolon after this SELECT statement?
Also, in general, if you're getting an error in your SQL, I would suggest executing just one SQL statement at a time so that you can easily identify which one has the error in it.
We're working on a six-year set of freely redistributable Vacation Bible School materials.