If you set it up as a linked server, I beleive you can do a simple

INSERT INTO [fully qualified name]

FROM vw_Table --format fields and such

Is this the same phenomenon as when doing a select and filter on a linked server table? I used to have the problem of SQL Server downloading the entire...

you have any openings at $100 an hour? ha!

if the default is 0, then myFlag will never be set to 1 with your query. It is dependent on at least one barcode containing a 1 to start....

Vishal,

if no rows match, how many rows do you want returned? IF you wish only one row, I'd do it like so...

Select FormID from Tablename

Where Action in (1,2,3,4)

And Status...

"on..and t2.myflag = 1"

at what point does myFlag = 1?

I recommend the INSTEAD OF TRIGGER

CREATE TRIGGER [dbo].[trg_upd_positions] ON [dbo].[positions]

INSTEAD OF UPDATE

SELECT *

FROM INSERTED [fields]

INNER JOIN [dbo].[positions] p

ON i.fld1 = p.fld1

WHERE i.fld2 p.fld2

UPDATE [dbo].[positions]

SET fld2 = i.fld2

FROM...

Two functions....

Use them in your select and group statements. You can hard code the shifts or make a table for shift, start hour, end hour. I'd put an...

20060215 or 2/15/06 or 2-15-2006.

thanks y'all..I can take it from here

awesome! Is there any way to view the definition of the trigger?

but not Triggers

It's the same reason I indent and use extra sapces when I code. It pops out at you and says, "HEY! I'm a stored procedure!" There's no...

this still splits the day up into time sections. Here's the scenerio...

swipe at 11:58 -> myFlag = 1

12:00 -> 6 hour period elapses.

swipe at 12:01

My original post flags both...

Can you use a view instead of a stored proc for spu_Test_A?

CREATE VIEW vw_Test_01 AS SELECT col0, col1 FROM Test_01