Viewing 2 posts - 1 through 2 (of 2 total)
Ok, try changing date to datetime in the function(s). It seems like date as a datatype didn't exist before sql server 2008.
2005:
http://msdn.microsoft.com/en-us/library/ms187752%28v=sql.90%29.aspx
2008:
http://msdn.microsoft.com/en-us/library/ms187752%28v=sql.100%29.aspx
Best regards,
Robin
September 7, 2014 at 12:45 pm
#1743728
Hi!
Which server version of sql server are you using?
September 6, 2014 at 1:58 pm
#1743688