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)
Thanks...
1 Reply
Know the answer? Post it — somebody with the same question will find it here.
Sign in to answer this question
It is the same account you read, post and publish with — and you will come straight back to this page.
Javeed M ShaikhPosted May 1, 2013, 10:03 AM
1. Do a select with the where clause and see if you are able to see any data.
2. check the data in CallingDateAgree column in the table if the data is in date format and meets the criteria.
3. if you can print some values from your table and table structure i can try to create the same at my end and try this.