Mammoth

When I need to copy a database, I always use the backup/restore approach. Either take a full backup or use the most recent full backup you have, whichever is...

SQLRNNR (6/3/2015)

---

There are a bunch of them by him. He has been...

Independence

If you aren't familiar with Jeff's DelimitedSplit8K function, the article is at http://www.sqlservercentral.com/articles/Tally+Table/72993/. It's well worth taking the time to read it. Be warned, though, that it might...

Motorcycle

Eirikur Eiriksson (6/3/2015)

---

Luis Cazares (6/3/2015)

---

Eirikur Eiriksson (6/3/2015)

---

SQLRNNR (6/3/2015)

---

Ed Wagner (6/3/2015)

---

SQLRNNR (6/3/2015)

---

Actually,...

Eliminate

Eirikur Eiriksson (6/3/2015)

---

Luis Cazares (6/3/2015)

---

Eirikur Eiriksson (6/3/2015)

---

SQLRNNR (6/3/2015)

---

Lynn Pettis (6/2/2015)

---

SMH...

Why would the person who wrote the procedure ask on a public forum why his procedure is returning a value of...

SQLRNNR (6/3/2015)

---

Actually, these days it should be PETA (PETPC is a...

BL0B_EATER (6/3/2015)

---

GilaMonster (6/3/2015)

---

I'll pick up some black candles and...

Fire

To provide an actual, tested query, we'll also need to know the table names. This is pretty simple, so I'd also like to see what you've tried so far.

I found this to be very interesting because it got me thinking of the age-old argument of formatting the data in the database versus on the client-side. There are...

Straightforward and simple. Thanks.