Mike, a WHILE loop is not the best way to split a CSV.

Take a look at this article. It explains how a table of numbers replaces a loop.

http://www.sqlservercentral.com/articles/TSQL/62867/

That's not going to work.

He needs two pivots.

One for TotalPackages and one for TotalCost.

Obviously every case is going to be different. I was...

Give this a spin. I want to make sure we're on the right track.

I know it's not perfect yet. I wasn't sure what you wanted to do with the column...

JohnG (11/12/2008)

---

Note: SQL Server 2005 SP2.

It just so happens that I'm coding a query for an application that was a prime candidate for a CTE as it had a complicated...

I'm really busy at work today, I'll have to look at this tonight.

In the meanwhile, check out this article and see if you can't figure it out on your own.

http://sqlblogcasts.com/blogs/madhivanan/archive/2008/08/27/dynamic-pivot-in-sql-server-2005.aspx

The...

Not really, Jeff. Thanks for asking. 🙂

What I'm really looking for is performance comparison between CTE and Derived Tables.

I haven't...

Yum! I'm hoping chocolate-chip :hehe:

Eric, it sounds as if you want to have variable number of columns in the output.

If that is the case you would need to make a dynamic pivot.

Let me know...

This should get you what you need.

-- create a sample table to play with

DECLARE @SampleTable TABLE

(

UserName VARCHAR(20)

,TableName VARCHAR(20)

)

-- insert some data

INSERT INTO @SampleTable

SELECT 'JDoe', 'Table1'

UNION ALL...

If you would post some sample DDL and DATA, it would be a lot easier to tackle your problem.

Read this article for some pointers: http://www.sqlservercentral.com/articles/Best+Practices/61537/

This type of formatting is better done in your front end application.

It sounds like you need an OUTER JOIN.

For better answers, please follow the best practices outlined in the following...

The test administrator is human and evidently made a mistake.

There is no such...

You can create a dynamic pivot to do what you want.

This article contains a stored procedure which creates a dynamic pivot for you.

http://sqlblogcasts.com/blogs/madhivanan/archive/2008/08/27/dynamic-pivot-in-sql-server-2005.aspx

Or, if you post some sample DDL and...