Steve Jones - Editor (12/13/2009)

---

A deadlock needs two sessions, and it needs multiple objects being accessed. AFAIK, if each person ran a single query you could not have a deadlock....

I've maintained for years that pivot tables in Excel were as close to BI-nirvana as humanity is likely to get.

This looks like a good addition to that toolset.

LOL

Got looks from coworkers.

Very, very funny!

CirquedeSQLeil (12/11/2009)

---

By the time the thread hits 10,000 y'all will be flatlined, passed out drunk from all the bear being passed around - bwahahaha 10,000 shall be mine (or anybody...

I don't think I can do that with a Numbers table...

And can't imagine how SQL...

Alvin Ramard (12/11/2009)

---

GSquared (12/11/2009)

---

On the subject of beer, one of my favorite jokes is that the human body is the world's most efficient machine at turning European beer into American...

On the subject of beer, one of my favorite jokes is that the human body is the world's most efficient machine at turning European beer into American beer. Can't...

bitbucket-25253 (12/11/2009)

---

Alvin Ramard (12/11/2009)

--------------------------------------------------------------------------------

GSquared (12/11/2009)

--------------------------------------------------------------------------------

select cast(Number as varchar(10)) + ' bottles of beer on the wall

' + cast(Number as varchar(10)) + ' bottles of beer

take one down, pass it around'

from...

Parallel processing....

Alvin Ramard (12/11/2009)

---

GSquared (12/11/2009)

---

select cast(Number as varchar(10)) + ' bottles of beer on the wall

' + cast(Number as varchar(10)) + ' bottles of beer

take one down, pass it around'

from dbo.Numbers

where...

select cast(Number as varchar(10)) + ' bottles of beer on the wall

' + cast(Number as varchar(10)) + ' bottles of beer

take one down, pass it around'

from dbo.Numbers

where Number between 1...

You're welcome.

jcrawf02 (12/11/2009)

---

Government suits are not going to suddenly become more efficient because more data is out there. They currently (going by Medicare standards) process claims blindly through an automated system,...

SQLCMD does. Check out http://www.databasejournal.com/features/mssql/article.php/3566401/Using-SQL-Server-2005-sqlcmd-Utility.htm

You asked about DDL scripts in T-SQL....

Ray K (12/11/2009)

---

I haven't taken the time to dissect your code, but I did want to write my thoughts when it came to attacking set-based vs. structured programming.

Most traditional structured...