Posted by shane.taylor81 on 03/26/07 22:44

Consider the following table

Customer
custId char(10)
accountExpiryDate datetime
accountStatus bit

Now, I want to update the accountStatus to False as soon as the
current date becomes accountExpiryDate.

I think it can be done using "SQL Agent" but my webhost doesnt provide
me access to that. I have access only to the Query Analyzer.

Thanks
Shane

• Next in forum: Re: Update Status Field after Expiry Date
• Prev in forum: Bulk insert error -- "Unknown version of format file"
• Thread view: Update Status Field after Expiry Date

[Reply to this message]