SQL Server - TO COMPARE DATES PRESENT IN A TABLE WITH CURRENT_DATE
Asked By ali shaik on 16-Jul-12 03:35 AM
IN A CURSOR I WANT TO CHECK THE EXISTING DATES IN TABLE WITH CURRENT DATE????
Rohan Dave replied to ali shaik on 16-Jul-12 03:47 AM
you can do something like below..
Declare @CurrentDate DateTime
SET @CurrentDate = Convert(Date,getdate())
now in your cursor, check your existing data from table with "@CurrentDate" ..