First, this question is completely unrelated to the original question. You're better off starting a...

skcadavre (6/3/2011)

---

When you post sweeping comments, you should probably include a test script that proves what you're claiming. Note, I'm not saying you're wrong. As I said before, I use...

This is something that is best left to the presentation layer.

Drew

Jnrstevej (6/2/2011)

---

Hi skcadavre,

Thanks for your reply, its not a homework question i'm in the process of designing a SSRS report and i need this section in the store procedure in...

I use...

I came up with the following solution using a calendar table fragment. You can create a calendar table on the fly using a tally table. I also added...

peterzeke (5/26/2011)

---

WITH CTE AS (

SELECT ProcessID, Month, Compliant,

ROW_NUMBER() OVER(PARTITION BY ProcessID ORDER BY Month) -

ROW_NUMBER() OVER(PARTITION...

First, this thread is almost three years old.

Second, the OP has a table that is normalized and asks how to denormalize it. Your sample data starts out denormalized. ...

You do realize that this thread is over three years old.

Drew

Maybe the problem is with the GROUP BY itself. There are a couple of approaches you can try instead. Which is more efficient may depend on indices you...

SSRS will export to Excel. You can also schedule reports to run automatically, so you might want to investigate using SSRS.

Drew

Look at the following two articles on cross tabs and pivot:

http://www.sqlservercentral.com/articles/63681/

http://www.sqlservercentral.com/articles/65048/

Drew

Ninja's_RGR'us (5/17/2011)

---

That won't work correctly. You can have 2 variables declared 1 as nvarchar and 1 as varchar.

To do this you need to save the spot where you find...

Yes, the string split that you are using returns the values as ROWS and you need them as COLUMNS. You can use a PIVOT or crosstab to change your...

You can certainly obtain the desired output, but since the correlation between the variable and the column name seems rather arbitrary, the following code is completely ad hoc and might...