Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
CASE - datediff - Conversion failed when converting the varchar value '01-20' to data type int
Many thanks fredericofonseca and gmmastros. gmmastros reply has worked a treat. Thanks again :)- PabloBB
- Post #4
- Forum: Microsoft SQL Server: Programming
-
CASE - datediff - Conversion failed when converting the varchar value '01-20' to data type int
Hi All, I'm a bit of a newbie with SQL and forum posting. I can see the problem but am having trouble getting to the solution! I'm attempting to group by using a case statement with datediff. Days cancelled before departure date then I want to group by bandings. However it keeps telling me...- PabloBB
- Thread
- Replies: 3
- Forum: Microsoft SQL Server: Programming
