How Can dates be compared in SQL........?
eg. startdate=10-10-2010 , end date=10-11-2010
It is not clear if your end date is October 11 OR 10th of November. At any rate, use CONVERT:
http://msdn.microsoft.com/en-us/library/ms187928.aspx
http://stackoverflow.com/questions/10825/howto-compare-a-date-string-to-datetime-in-sql-server
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.