The following article explains a way of doing this. Read it carefully and ask any questions that you have.

http://www.sqlservercentral.com/articles/T-SQL/68467/

For better answers, read the article linked in my signature.

No, you need to use dynamic sql to have a dynamic number of columns.

Robert.Sterbal (7/17/2014)

---

Looks like a great technique, although more than half the sites I support are SQL Server 2K

I'll have to figure out how to do this in excel (with the...

I once had a similar requirement and the best option was to generate the columns in the reporting tool. That was on VFP and I'm not sure if it's possible...

Sean Lange (7/16/2014)

---

Evil Kraig F (7/16/2014)

---

Sean Lange (7/16/2014)

---

Lynn Pettis (7/16/2014)

---

patrickmcginnis59 10839 (7/16/2014)

---

Jack Corbett (7/16/2014)

---

Eirikur Eiriksson (7/16/2014)

---

No implied either, my respect on handling the situation! So far, JC is...

Another option is to use bcp to create the csv file or SSIS for any of the file options and possibly sending it via email.

SSRS seems overkill for this task,...

It's good to know that my blind-coding abilities...

I made a few changes to give you an idea. They might be wrong, but hopefully you can modify them accordingly.

WITH PStatus AS(

SELECT t.acct_no

...

I'm not sure on why you included the "create" word. It shouldn't be part of the table hint, that might be the error and should occur as well on 2000.

You...

Stefan Krzywicki (7/16/2014)

---

Luis Cazares (7/16/2014)

---

Jack Corbett (7/16/2014)

---

Stefan Krzywicki (7/16/2014)

---

I posted a question here (http://www.sqlservercentral.com/Forums/Topic1593226-391-1.aspx) on Memory Grants and Varchar(max) and I'd love to hear any opinions the people...

Jack Corbett (7/16/2014)

---

Stefan Krzywicki (7/16/2014)

---

I posted a question here (http://www.sqlservercentral.com/Forums/Topic1593226-391-1.aspx) on Memory Grants and Varchar(max) and I'd love to hear any opinions the people in this thread might...

vecerda (7/16/2014)

---

I get this error:

Msg 4104, Level 16, State 1, Line 20

The multi-part identifier "b.recID" could not be bound.

not sure what I am doing wrong as the alias is clearly...

You're right, I didn't see the DDL before I posted.

However, this puzzles me:

[Store_Opens_Baseline] [nvarchar](255) NULL,

This is an idea on what you could do. You might want to create a computed column to remove the case from the join clause.

DECLARE @FileId int

SET @FileId=345;

WITH Brands AS(

...

Additional to that, you should really change your text columns into varchar(max) or even a normal varchar. The text datatype has been deprecated and will be removed in a future...