I work with what I consider a large number of third party databases.  I still troubleshoot poorly performing queries.  I now have DBA acquaintances at those companies and they have...

Azure Synapse has a 1TB minimum.  If you are greenfield, then it will be much cheaper to go with an Azure Database in the meantime.

The jobs I have held that I considered "dream" jobs were not about the work, but the atmosphere.  I had to fill out one of those HR questionnaires evaluating the...

My favorite part of today's strip about compression is the "TILT!" on the screen. I wonder if the under 30 crowd gets it as a pinball reference. I...

I love open offices and low cubes. I love the comradeship of a team that can just turn around or stand up in order to brainstorm. But I...

Because there is a general revulsion for row by agonizing row,

a person could use a tally table and a values table rather than a while loop to accomplish the...

pmcpherson (7/17/2012)

SQLBill (7/17/2012)

The comment above (a snippet...

SQLBill (7/17/2012)

The comment above (a snippet of...

Nobody has mentioned that to install SQL we had to install the .Net Framework and since 2005 we have had CLRs. We have several CLR/SQL functions here that make...

CELKO - your code does not compile. Looks like some logic is missing in the case statement.

I don't get " SELECT fact FROM Factrorials WHERE @f =...

Don't you also need to make sure that @n <> @r so you don't divide by 0? And @r <> 0 either.

Thank you Chad. I just got pulled in another direction while reading your reply. It might be a while before I can answer all those questions.

Doesn't every DBA/D want control over...

Your solution is similar to mine with more joins than I believe to be efficient, but still effective.

I am also hoping someone else can provide a cleaner, simpler,...

Gianluca,

Your solution, while helpful, does not return the desired result set.

I think I see the confusion in my explanation of the problem.

The problem is to come up with all of...