This thread has the answer in it:

http://www.sqlservercentral.com/Forums/Topic349843-148-1.aspx

Sorry, but there is...

I agree with Paul in that "It Depends".

Just to add a my two cents to the discussion:

Concrete tables used in a temporary way and truncated before and/or after each use...

TheSQLGuru (6/17/2011)

---

This is an American cultural reference to a sometimes strange pop singer. Search the web for any number of VERY interesting pictures of outfits...

GSquared (6/17/2011)

---

opc.three (6/17/2011)

---

That's why the IDENTITY column is added in Step 1.

You're not going to "physical order" are you? I'm pretty sure all that's needed is logical order. Once the...

*reach hand up, push rock away*

http://tinyurl.com/3z7zvuj

GSquared (6/17/2011)

---

Jeff Moden (6/17/2011)

---

Nah... considering the number of hacker attacks designed specifically to exploit OLE DB Automation, I can see your...

OK, maybe I missed it. I think your example resultset has a circular reference in it and it was throwing me off.

Can you please fix this so it says...

That's why the IDENTITY column is added in Step 1.

You're not going to "physical order" are you? I'm pretty sure all that's needed is logical order. Once the data is...

hxkresl (6/17/2011)

---

I have read BOL and can see how to place begin/try around regular select statements, but not around dynamic sql statements. Would you mind giving me a suggestion about...

Jeff Moden (6/16/2011)

---

opc.three (6/16/2011)

---

While your manager is outside the box ask him/her to consider what will happen when two people need to modify "The Proc"...one to change how Lady GaGa...

Jeff Moden (6/16/2011)

---

That absolutely works for me. 😀 It would be very cool if you told me what you use instead....

PS I didn't notice any transaction handling in your code. If you're operating on a table or set of tables more than once inside a "unit of work" you may...

Ever used TRY/CATCH ? It's awesome 😎

BEGIN TRY

EXEC('raiserror(''Bad stuff happened...'',11,1);') ;

END TRY

BEGIN CATCH

SELECT ERROR_MESSAGE() AS [error_message]

END CATCH

<my_two_cents>If you insist on full...

newbie.with.sql (6/16/2011)

---

I have a flat file that I importing into my database but the rows are not coming into the table in the same order as in the flat file....