Very nice article - Thanks!

I'm especially glad to see the effect of an update statement on the different methods discussed. And as you so properly point out, the proper answer...

LutzM (9/14/2010)

---

Lynn Pettis (9/14/2010)

---

I'm guessing not many will jump to help bit boy if he runs into more trouble and posts a question on SSC again (if he does post...

Awesome series Paul!

Steve Jones - Editor (9/14/2010)

---

Well I sent a note to our BIT friend and got a reply back. Apparently

- he was abused

- I contributed to the abuser by pointing...

Do you really have a goat? We had 4 pygmy...

No problem, I'm glad I can help. If you have...

pharmboy4u (9/14/2010)

---

CELKO (9/14/2010)

---

Please post DDL, so that people do not have to guess what the keys, constraints, Declarative Referential Integrity, data types, etc. in your schema are. Please learn to...

assh1122 (9/14/2010)

---

Hi,

Thank you both for taking your time to answer my question. I could able to successfully change the table owner using the sp_changeobjectowner '[currentschema].[currenttable]' , 'dbo' command. Now I...

Looks like I got in ahead of Lowell by 1 or 2 ms.

Under this situation, my first thought is to use the Import wizard to import all of the tables you need from the main database, then import the others via a...

The way it's written, yes. However, if you can make the PK be on (B, C, A), then you wouldn't need to.

Edit: also, the index on B,C isn't for just...

You can only have one else condition for the case statement, after all of the WHEN conditions.

CASE

WHEN Code Between 1 and 24 THEN Hours

WHEN Code Between 26 and 29...

CirquedeSQLeil (9/14/2010)

---

Steve Jones - Editor (9/14/2010)

---

I think when I was visiting Jason's home in Vegas this summer the Orange chip at the Bellagio was 25,000. Needless to say I just...

Alvin Ramard (9/14/2010)

---

WayneS (9/14/2010)

---

Chad Crawford (9/14/2010)

---

Alvin Ramard (9/14/2010)

---

Ah darn! I ran...

Chad Crawford (9/14/2010)

---

Alvin Ramard (9/14/2010)

---

Ah darn! I ran out of fingers...