Boot - as in what is done after over indulging.

Chris Quinn-821458 (12/22/2009)

---

CirquedeSQLeil (12/21/2009)

---

Chris Quinn-821458 (12/21/2009)

---

Much closer to home,...

Echoing what the others have said - the physical order is not that important. You have indexes to help with sorting.

To guarantee a single record will be the very...

Thanks Jedak for the followup on the "Who is Frosty" question.

Jeff Moden (12/21/2009)

---

BWAA-HAA!!! Frosty needs to get a set-based decoder ring! 😛

DECLARE @ToAllGoodPeople TABLE

(

...

Nice question Bitbucket.

Merry Christmas and Happy New Year to all

Nice pic Gail.

Check this thread http://www.sqlservercentral.com/Forums/Topic294216-314-1.aspx#bm299093. It might be what you are looking for.

Lynn Pettis (12/21/2009)

---

Jason is right, you don't have a WHERE clause to join the two tables in the second FROM clause (the UPDATE statements FROM clause). Are you sure...

Jeffrey Williams-493691 (12/21/2009)

---

Well - you're probably missing the ability to access the linked image. The...

There may be other methods - and it would certainly be worth testing. It seems to me that a char or varchar would work in this scenario.

Thanks for the...

Yes this would be feasible.

Jeffrey Williams-493691 (12/21/2009)

---

Lynn Pettis (12/21/2009)

---

SQL Iron Chef (12/21/2009)

---

Actually I didn't! I was just...

Thanks Steve. It only seems to happen every once in a while that the code doesn't copy so well from the QOD.

You're welcome. Thanks for the feedback.