Jeff,

Thank you for your response. Yes, the table can be modified at this point. I started down that road by adding numeric columns representing employee size and avg_sales...

Thank you for taking the time to put into T-SQL. I should have done this to begin with. Hopefully with this and the above post (2 prior) the...

Thank you again for your response. I'm painfully aware how difficult it can be to communicate, but I appreciate your effort!

I believe a clearly illustrated matrix/spreadsheet would explain it...

I think you are on the mark with what I am after. The "formatting" thing was supposed to be the clear example you speak of.

The "Desired Column" is the...

I apologize for the format in which this question posted. Not only did the spacing between columns not follow when I "posted" my color for the desired column looks...

Thank you for the information Steve. Unfortunately, I had seen most of these and none do exactly what I'm looking for. The article on SQL ServerCentral that uses...

Oops...hit the "Post" button too soon. So you have a sample package that might do this?

I am open to SSIS....just relatvely new to it.

Thanks,

Lonnie M

:-D, Yes, SQL Server 2012 🙂

I haven't done it in SSIS simply because I'm not that familiar with it.

Unfortunately I cannot provide ole/odbc access to the end users

Thank you,

Lonnie

The code would be along the lines of:

Select A.RVP, A.DM, A.BRANCH_CODE, A.Exclusive_BRAND, A.Cat_1, A.Cat_2, A.Cat_3,

Jan11_Sales, Feb11_Sales, Mar11_Sales,

Apr11_Sales, May11_Sales,

Jan11_COGS, Feb11_COGS, Mar11_COGS,

Apr11_COGS, May11_COGS,

Jan_11_Num_Of_SKUs, Feb_11_Num_Of_SKUs, Mar_11_Num_Of_SKUs,

Apr_11_Num_Of_SKUs, May_11_Num_Of_SKUs,

Jan11_Adj_Value,...

Thank you both for the links....I will investigate. SSRS is not a viable option for this process.

Lonnie

In my testing (with a cursor....shhhh) I did throw the predicate for the where clause in a separate table. I haven't used dynamic SQL in years so I would...

There were no error rows reported....no seperate error table. Do I assume then there are no errors???

Thanks,

Lonnie M

That is an excellent point. Unfortunately, I'm not sure I can verify every data point in detail in a file of that size. I can't even export the...

BTW I would like to thank all those who took the time to help.

Thank you,

Lonnie M