Any ideas??

Thank you Perry, that has done the trick!

Hi All,

I'm...

Ok, thanks all for the responses, looks like I had it right the first time! Oh well, I'll stick with dynamic SQL.

Thanks

Thanks Willem, I'll try that.

Hi Matt,

Can you give me an example please?

Thanks

As simple as that! Thanks for your help!

Hi Gail,

Yes I appreciate what you are saying, I will try and add more info to the post later when I've got a bit more time. 🙂

Thanks

David

Ok, here is a definition of the destination table:

DECLARE @Temp TABLE

(

version_id int,

customer_id char(8),

product_id char(20),

month_id char(2),

fiscal_year char(2),

units numeric(18, 4),

value numeric(18, 4)

)

The data that will be inserted into this table comes from...

Thank you for the quick response 🙂

The tables are in a third party db so I don't have the option to re-design them.

Cheers Mark 🙂

Have you got a SQL2K version of that please? This particular server is still on the old version so it doesn't like the CTE.

Thanks

David

I've had a bit of a play and have simplified what I am asking for help on, first the sample code and data:

use tempdb

go

--Create table to hold this years sales

CREATE...

Yes, it is a bit unclear I must admit! Ok, I'll try and explain, so in the first instance I needed to work out what the average selling price and...

Hi Jack,

The output only needs to be Item, Total Value, Total Qty, Avg Value and Avg Qty, the last two only having values if they were sold during the Period/Year...