If this is your first visit, be sure to
check out the FAQ by clicking the
link above. You may have to register
before you can post: click the register link above to proceed. To start viewing messages,
select the forum that you want to visit from the selection below.

------------------------------------------
This is bringing back one row per invoice received after 31/12/2012. The aim is to get the following:

Code Jan data Feb data Mar data

> one unique code per line (so I'm assuming row partitioning is required)
> Where a bill has a period of 3 months with, for example, 300 units, I'd like that separated out across 3 months (100 in each)

I'm aware I'd probably need to use a pivot function and some temp tables but I'm not that advanced yet.