OK,

Here is the sample table and script and at the botton I am trying to do what I am trying to explain. If this does not help please let me...

Thanks everyone for the generous help. I am going to try to work on the example shown and figure out my output.

Thanks everyone for the help. I appreciate it. Eugene thanks for pointing the @col showing null. I forgot to include the select query containing the @col. Once I put the...

OK,

This is another question for Rob and Lowell.

The select statement currently looks like this:

select cust_num,slsman,

SUM(CASE WHEN [site] = '11199' THEN sales_ytd else 0 end) as [11199_sales_ytd],

SUM(CASE ...

Thanks Rob for the clarification.

Regards.

Thanks Lowell. This worked perfect. The site seems to be not an issue.

Regards.