Mustard (if I got the reference right)

Clue

How very true. Thanks, Brandie. You brought a smile to my day that otherwise seems very long.

I figured that was a...

Nice question. Of all the things we get when we upgrade to 2012 or 2014, LEAD and LAG are the ones I'm looking forward to the most. Yes,...

Help

Odd

John Mitchell-245523 (4/14/2015)

---

To make it more flexible, you might consider doing it like this:

SELECT 'databaseA', columnlist FROM databaseA.dbo.table UNION ALL

SELECT 'databaseB', columnlist FROM databaseB.dbo.table UNION ALL

SELECT 'databaseC', columnlist FROM databaseC.dbo.table...

Well done, Grant. I'd say you've earned a victory beer, so enjoy it.

Your approach of deleting the grandchildren, then children then parent is the same one I use. If you have foreign keys defined, then the DELETE statements will benefit from...

Firewood

Personally, I wouldn't be sitting around working in a Starbucks. Then again, I'm also the semi-paranoid type who won't use public wireless networks for work at all because they...

Nice question. As one who doesn't like to use XML in table definitions, I've never encountered this. So I learned something new. Thanks.

djj (4/14/2015)

---

Eirikur Eiriksson (4/13/2015)

---

Revenant (4/13/2015)

---

Eirikur Eiriksson (4/13/2015)

---

TomThomson (4/13/2015)

---

Jeff Moden (4/13/2015)

---

Eirikur Eiriksson (4/13/2015)

---

djj (4/13/2015)

---

Revenant (4/13/2015)

---

Ed Wagner (4/13/2015)

---

whereisSQL? (4/13/2015)

---

Ed Wagner (4/13/2015)

---

eccentricDBA (4/13/2015)

---

Ed Wagner (4/13/2015)

---

crookj (4/13/2015)

---

djj (4/13/2015)

---

Eirikur Eiriksson (4/13/2015)

---

Ed Wagner (4/13/2015)

---

djj (4/13/2015)

---

Ed Wagner...

Taste