January 24, 2008 at 11:53 pm
hi,
Well i am using the sqlserver2000 as backend.
I have table like seatdetails and columns are
seatno,bookingdate,dateoftravel,seatstatus
the seatstatus can be 0 - rejected, 1 -pending, and 2 - accepted.
Now the issue is daily at 12:00am , i need to execute the trigger or event which should check the
dateoftravel with the date in server
if it is less then
check the status of a seat
if it is 1 (i.e status of a seat) then
the date diff of bookingdate and cureentdate
if it is equal to 3 (i.e. counter of days) then the status should be set to 0 (i.e. status of a seat) and mail sent to @mailid1 and @mailid2
regarding the changes from the sqlserver.
Thank you for helping me in advance
You can mail me the procedure suhailquadri@gmail.com
January 25, 2008 at 8:25 am
First - don't cross-post. Having the SAME question posted 4 times is wasteful, doesn't help you cause at all (especially when you post them in non-relevant subject areas). Plus - it pisses off the regulars.
Second - you're not showing any evidence of having tried anything. The usual way this works is that we HELP you, we don't DO for you. If you're really not sure, then ask us to talk you through how this is done, perhaps an avenue of attack. But still - the expectation is you should be doing the "heavy lifting", so that you can learn something out of the experience. After all - you're the one getting the paycheck for this, so you ought to do most of the work for it.
Third - having someone MAIL you the answer helps no one, since noone else gets to learn from your question.
Finally - you provided little to no useful info for us to help you (assuming you've done any actual work on the issue). you might care to take a look at this thread on how to correctly request something....
Forum Etiquette: How to post data/code on a forum to get the best help[/url]
Conversation should continue right here once you can help yourself with some more specifics.
----------------------------------------------------------------------------------
Your lack of planning does not constitute an emergency on my part...unless you're my manager...or a director and above...or a really loud-spoken end-user..All right - what was my emergency again?
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply