Home Forums SQL Server 2008 T-SQL (SS2K8) Using 2 TVPs in a stored proc to insert into 2 related tables RE: Using 2 TVPs in a stored proc to insert into 2 related tables

  • July 23, 2009 at 12:41 pm

    #1029199

    I think you can do what you need to do by using the OUTPUT clause from your first insert. That will allow you to capture the new ID and the associated ScopeRequestID so you can figure out what matched to the Request Properties.

    Does it need to be that complicated though?