Sorry i am posting at wrong article.

zhtway

Hi jvanderberg,

Thanks for your inputs and idea.

Actually table1 is like collecting daily transactions, so probably it is just only 300 records in a day and may be it will grow...

Hi jvanderberg,

It seems like working. Well..I'll have to test with some data and have to make sure ev'thing is right.

thanks for your help.

zhtway

Hi,

In 2005 Management Studio, the table1 was expended and right click on trigger and then New trigger was chosen.

When the windows was opened, I clear those codes and type your...

Hi All,

for jvanderberg,

Yes, All three rows will be moved to table2.

for PaulB-TheOneAndOnly,

1) All rows (when condition meets) will be moved to table2. "Status" will be updated to...

Hi jvanderberg,

Thanks for your reply and I am sorry for the confusion.

Here is an example..

In Table1

row ID Status

1 1 True

2 ...

Hi,

Thanks for your info.

I am new to sql server and I want to know when the trigger kicks in.

You said " The whole operation will complete before the transaction ends."

OK....

Hi All,

Thanks you guys..

Now I learn alot from all of you.

rgds,

zhtway

Hi,

Finally I got it. I am little bit dump and confused to write a code as a beginner...:-D

Here is the code. and correct me if I am wrong.

DECLARE @Deli TABLE...

Hi,

Here is the code I have done and tested and seems working.

Correct me if something is wrong. I'll have some more to do

use MobilePOD

Declare @chkHoliday int

Declare @chkTomorrow int

declare @DayName varchar(20)

Declare...

Hi Nakul Vachhrajani,

Thanks for your replies.

Let me explain to you what I want to do.

Routes is the Master table for all routes.

Pickup is the table for a day where all...

Hi,

I have just tested with SQL Agent.

I don't know how to retrieve date from Holiday table.

use testDB

Insert into Pickup (StaffID, RouteID, PickupDate)

select StaffID, RouteID, (getdate()) from Routes