>>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
Timothy Bryan