My code:

UPDATE SWProjectGrid.dbo.tblServiceRequests

SET TesterID_AA = @LanID

,Tester_AA = dbo.Func_BT_BatchQueueGetName(@LanID)

,AutoAssignedDate = getdate()

,ManagerAutoAssign = 0

OUTPUT inserted.ID

,inserted.[SR Number]

,inserted.AccountName

,inserted.Area

,inserted.[Sub Area]

,inserted.Carrier

,inserted.Div

INTO @tblSRInserts

WHERE ID = (

SELECT TOP 1 t1.ID

FROM SWProjectGrid.dbo.tblServiceRequests AS t1

INNER JOIN SWProjectGrid.dbo.tbl_AutoAssign_TesterCategoryAssignments AS A...

I believe it did. Testing things out.

I was on the right track. I seem to always struggle on more than a simple UPDATE.

Thank you!!!

Like I said, maybe there's a different approach to this. Let me try to explain my idea.

I have a table that stores a document's text. It's what we call a...

The intent is to retrieve a SQL command stored in a table, i.e. SELECT REPLACE(CONVERT(char(8), CURRENT_TIMESTAMP, 10), '-', '/') or SELECT PermAnalyst FROM EligDW.dbo.tblClientList WHERE Div = @div...