Team,
I hope everyone is doing great, i have a quick question. I have a store procedure that run a mass update, basic when users add data to the table they are some field that they aren't filled out, so I implemented a store procedure to do the update, is there a way to add this after record Add below is the update that I do.
Thanks
Update E
set e.nteamid = u.nteamid , e.nsubtypeid = t.SubTypeID , e.dexceptiontime = h.WorkedHours
from rpt.tblExceptions E
Inner join rpt.vwtbluserexception U
on e.sagentname = u.name
Inner Join dbo.tblSubType T
on e.ssubtype = t.SubType
inner join dbo.WorkedHours H
on e.dexceptiontime = h.Minutes