Well, with no code, this is generic, but basically, put in a column that will add headers.

For example, if you pivoted across MON/TUE/WED/THU/FRI, and now want TOTAL, you'd put

[MON]+[TUE]+[WED]+[THU]+[FRI]...

Sean: I've done ISS/SQL combined boxes before for dedicated apps/vendor apps before. It's not the optimal solution but it's doable if your userload isn't high. It's a special...

as-534320 (9/24/2010)

---

The transaction is started by a method in a c# .net apllication, and then several methods that uses several stored procedures in database are called, using the same trasaction....

There's a catch-22 to being a DBA/SQL Server person and trying to instill 'customer service'. I agree, when the priority issue comes up and you've got the flying circle...

Gentlemen, a thank you for doing this entire thread publically. I'm relatively sure my brain is attempting an escape as I try to keep up with your experience and...

I got used to NY drivers. I drove a rig in the tri-state for a bit, and grew up there. They're not so bad, they're predictable. They're...

Jeff Moden (9/21/2010)

---

Alvin Ramard (9/21/2010)

---

GilaMonster (9/21/2010)

---

I told that one at a dinner at the PASS Summit a few...

Yep, and alone, too. 🙂

Eric Russell 13013 (9/21/2010)

---

Hey, all the developer needs to do is make sure his SQL basically...

Remove the GO in the middle of the procedure after DROP TABLE dbo.TempML;

Sounds like someone else read an article and freaked. The question is, is this a hill worth fighting for? I'm dealing with that a bit myself at the...

Well, either 2 or 200... either enough facepalming noone can reach the keyboard... or...

GilaMonster (9/21/2010)

---

Huh?

CheckDB snapshot is created when checkDB starts and dropped as...

David O (9/21/2010)

---

The spid 94 query takes almost 4.5 minutes to run on it by itself and pulls back about 800K records. The vendor doesn't seem to see...

Alvin Ramard (9/21/2010)

---

Steve Jones - Editor (9/21/2010)

---

Alvin Ramard (9/21/2010)

---

Steve Jones - Editor (9/21/2010)

---

Dees margarita ees...