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
MrSQLDBA
SSC-Addicted
Points: 417
More actions
July 23, 2009 at 10:02 am
#1029105
One more thing as well....I did think about getting the MAX(RequestQueueID) from the dbo.RequestQueue table before the insert and working out from there...but as there could be more procs running and inserting as well...this could be wrong.