Update Status Field after Expiry Date
- From: shane.taylor81@xxxxxxxxx
- Date: 26 Mar 2007 15:44:48 -0700
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
.
- Follow-Ups:
- Re: Update Status Field after Expiry Date
- From: Erland Sommarskog
- Re: Update Status Field after Expiry Date
- From: --CELKO--
- Re: Update Status Field after Expiry Date
- From: --CELKO--
- Re: Update Status Field after Expiry Date
- From: AlterEgo
- Re: Update Status Field after Expiry Date
- Prev by Date: Bulk insert error -- "Unknown version of format file"
- Next by Date: Re: Update Status Field after Expiry Date
- Previous by thread: Bulk insert error -- "Unknown version of format file"
- Next by thread: Re: Update Status Field after Expiry Date
- Index(es):