Hello Friends,
I have some problem in sql server.
i created a storeprocedure with compare table [column] date witch difine varchar() and compare to getdate(). when compare it not proper work it gives only current month proper result not[previous or next month]....
update tablename
set DatalinkStatus='Visit Not Successfully' where convert(varchar(10),CallingDateAgree,103)<convert(varchar(10),getdate(),103) and status='disable'
Thanks...