I'm afraid you're wrong with you requirements.

🙂

These 2 statements contradict each other:

when a staff member leaves and...

Only option which allows you to read recordsets from files with no looping is BULK INSERT (bcp).

But to use it you need to expose the file location to the SQL...

No, better like this:

EXEC [dbo].[ProcTest] @Table = '{table}; exec sp_resetpassword ... '

Just to make sure you take control over those...

Is this what are you looking for?

CREATE TABLE #MoveDetail (

ID int,

MoveDetail varchar(50)

)

INSERT INTO #MoveDetail

(ID, MoveDetail)

SELECT 1, 'Paint Location'

UNION

SELECT 2, 'Clean Location'

UNION

SELECT 3, 'Supply Setup'

UNION

SELECT 4,...

UPDATE workorder

SET targstartdate = @ts, targcompdate = @tc

from inserted

WHERE workorder.wonum = inserted.wonum

I'd advice you not to use subqueries. Ever.

There is another way in almost every case.

And that...

Is it for some kind of report?

If yes what is the exppected format of the report?

Update P

Set -- check the column names, probably they are not correct here

LastName=S.S_Last_Name,

FirstNames=S.S_First_Name, ...

Microsoft SQL Server 2000 - 8.00.2055 (SP4)

Collation SQL_Latin1_General_CP1_CI_AS

Jeff Moden (9/20/2008)

---

Man, I really appreciate you watching out for me, Sergiy. I've learned a lot from you. Thanks...

Ok... like I've done before when this controversy of Select/Into...

Temp tables work perfectly for this purpose.

REPLACE(

STR(sum(amount), 11,2),

' ', '0')

Is it what you are looking for?

Make it a view.

It will simplify everything.

Did you try simple UPDATE?

It's on server's C: drive inside temp folder.

What does it mean "unique"?