Discussion on:

Message 13 of 14
0 Votes
+ -
RE: Simplify SQL Server 2005 queries with a Dates table
Hi, Tim
I tried your code in mysql but receive following Error.


You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'DECLARE @Date DATETIME
SET @Date = '1/1/1900'

WHILE @Date '1/1/2100' at line 1

Thank You...For Your Time
Posted by shashankkale
25th Jun 2009