But that was not the end of the story. even I did it now but the issue was that I have already records in my table and I want this...

Yeagh Thank You Scott. i did it as u suggested and it worked .Thank You

Yes Jacob,

what i am trying to do is that I m working on a library management automation system. Here a member can reserve a book for 24 hrs only when...

Than You Mike. it worked

Thanks to all for taking me over the issue.

Regards

Thank You, Steve. it was important for me to be new to the SQL server. Thanks a lot

Yes, Mike,  i have seen it but i couldn't find the facility or option where it asks me that here you can give your PROC name to call it. the...

yes, Thank you Mike. I got it

Now I tried to l00k at te google that how can I schedule the above PROC to be run every 8 hrs but i...

if i do it like this . it will give the same result

update bmt
    set current_stock=current_stock+1 
    from dbo.book_master_tbl bmt
 ...

Awesome Steve...u got it.

i have some question about fol. is it part of that update statement where you use "OUTPUT inserted.book_id into @b-2" and that declaration part where...

i came up with the following sol using cursor inside a procedure.

sample data is that i have to engage 2  x tables. one is book_master_tbl having book_id as the primary...

• This reply was modified 4 years, 3 months ago by  sameer.
• This reply was modified 4 years, 3 months ago by  sameer.

Thank You Phil for your time

why are you subtracting one day from current date and time.?

secondly to add some more requirement to my issue is that if date and time...

• This reply was modified 4 years, 3 months ago by  sameer.