Check out WITH Rollup, it works like Pivot... the results may be more desireable.

SELECT CASESUBTYPE,LONGDESC,

[1] AS Day1,

[2] AS Day2,

[3] AS Day3,

[4] AS Day4,

[5] AS Day5,

[6] AS Day6,

[7] AS Day7

FROM...

Being that this a newbie forum, I wanted to ask you a few non-assumed questions and see if we can get you on the right track. Is this query...

You may want to look outside of the script. Is this a stored procedure executed by a SQL job? By an application? Also, when this failure occurs, does...

You may want to look outside of the script. Is this a stored procedure executed by a SQL job? By an application? Also, when this failure occurs, does...

I do not believe that Windows Installer 4.5 comes with Windows 2003 Server SP2. Try this link:

http://www.microsoft.com/download/en/details.aspx?id=8483

Download one of these versions (depending on what platform you...

Hi,

Our company made the jump from SQL Server 2005 to SQL Server 2008 R2. The move was a success for the most part, but the proper procedures needed to...