>>>>Hi Naomi,
>>>>That makes sense and I will give that a test run. I want to return the entire row back.
>>>>I appreciate it.
>>>
>>>Hi, Tim,
>>>
>>>Naomi's reply is exactly what you need, I just wanted to jump in with 2 more things.
>>>
>>>First, the OUTPUT statement has an optional OUTPUT INTO capability. So if you want to redirect the results of your insert (with the newly generated GUIDs and any other derived/calculated columns) to any table (including a temp table), you can. (The table has to exist...OUTPUT INTO won't create a new table on the fly for you)
>>>
>>>Second, just curious, since you're using SQL 2012 (which has the new Sequence Object). What's the reason for using a GUID? I realize it's a loaded question, just curious if the requirements call for it.
>>>
>>>Thanks...
>>
>>Thanks Kevin,
>>
>>I changed to use the OUTPUT statement yesterday and it worked great. I did notice the OUTPUT INTO and that would work great for situations where I need to do something with the row within the procedure, but I just wanted to return the new row.
>>
>>We are using uniqueidentifiers so we can replicate across databases. I am not familiar with the new Sequence Object, but I will be after today. :-)
>>Thanks
>
>I think you'll find the NewSequentialID() is better than NewID() in terms of inserting performance.
Yes you are correct and in terms of index performance.
Thanks
Timothy Bryan