Viewing 2 posts - 1 through 3 (of 3 total)
SQL converts an empty string ('') as 0 and date 0 corresponds to 1900-01-01 , date 1 = 1900-01-02 etc. The following statements demonstrate this.
SELECT CONVERT(DATETIME, '') AS [Date ''],CONVERT(INT, '')...
January 28, 2004 at 8:42 am
#491992
If you use the join method the query will execute much faster.
January 14, 2004 at 12:33 pm
#490039