Anyone please help me out. Am having a table with field name 'status' with the values 'yes' or 'no'.
Really, i wants to change this 'yes' or 'no' status automatically using mssql server. But i don't have an idea to continue on this work.
for example, now the value is 'no' in the status field. I want to change 'no' value to 'yes' automatically till the from date(15-11-2011) to date(25-11-2011) and also should start at mid morning 12 AM, at the time of mentioning from date(15-11-2011).
By on 25-11-2011 mid night 11.59 PM or 12 AM, 'yes' value again should changes to 'no' value.