There's more than one way to do things | |
PerlMonks |
Re: Win32::ODBC getting syntax error while executing sqlby jonadab (Parson) |
on Nov 26, 2008 at 12:18 UTC ( [id://726087]=note: print w/replies, xml ) | 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.
In Section
Seekers of Perl Wisdom
|
|