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 Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Recent content by jmr23
-
Newbie Ist time query
You are dealing with typing in both instances. What is the datatype of column "deal" If it is a bit then you must use 1/0 not "true" or "false" If it is an int, same story. If it is a varchar column then 'true' should work fine. As for the date comparison, here are some ideas: DECLARE @date...- jmr23
- Post #2
- Forum: Microsoft SQL Server: Programming
