This topic is locked

Mass Update

3/1/2009 7:43:16 PM
ASPRunnerPro General questions
W
wisdom2009 author

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

Sergey Kornilov admin 3/2/2009

To execute a stored procedure use something like this:

dbConnection.Execute "exec sp_name"

W
wisdom2009 author 3/2/2009

Thank you so much, it works perfectly.
Thanks again