Good question.

I'm just trying to find a way to get it done.

It seems that I have two options, create an Inline View or CTE to get it done in T-SQL...

I squeeze in some of the columns and abbreviated the column names to make this readable but this is what the result looks like from the output of the Temp...

I can understand why you want...

Lynn Pettis (11/2/2011)

---

First, I'll look at the date manipulations a bit later. Looks like the date manipulation code in my blog on ssc is just what you need with...

Thanks Kramaswamy! 😎

kramaswamy (11/3/2011)

---

As far as I know, if you try to make column headings dynamic, you're going to get inconsistent metadata. The only way to effectively pull it off is to...

As a workaround could I remove a generic static heading and insert the dynamic column headings (Previous Year, Previous Month, Previous Weeks) based on the current Date using a Script...

OK, I agree on the Date range.

In the past I would concatenate the Date with the Time '23:59:59.123' and use the Between Operator because of the large number of records.

I...

Drew,

I do not want to miss any records.

I have already calculated the First Dates of the Current, Previous and Next Months but I thought that the BETWEEN OPERATOR would...

Lynn Pettis (11/2/2011)

---

I think I'm still a little lost. Given date 'x' what are you expecting regarding start date and end date for 2 months? Same for the...

Sample Output.

Ran before End of Month (Oct).

Column has a 1 in each record that the lead generated into a sale.

Account Affinity20102011 YTD OCT 2011 MTDSEP 2011 AUG 2011 WK...

Lynn Pettis (11/2/2011)

---

I find it easier if you show me what you are looking for, I figure things out better when I have a picture of what is needed. ...

I thought that after I posted the question.

Makes sense.

Thanks for your help!

The boss does not want to go with the Excel MAcros.

Back to using SSIS.

The following generates the column headers for the first two aggregates:

SELECT DATEPART(YEAR,DATEADD(year,-1,GETDATE())) AS Year,

CAST(DATEPART(YEAR,DATEADD(year,0,GETDATE())) AS VARCHAR(35)) +...

kramaswamy (11/1/2011)

---

Why do you need to know the column names? If you deselect the option "Column Names in First Row" for the excel output, then you're just left with "F1",...