graham 47698 (10/19/2012)

---

Hi

I have a table which has columns containing sales values for each month for example..

Id, versionId, jul,aug,sep,oct,nov,dec,jan,feb,mar,apr,may,jun

The 'versionId' joins to the period table which has the end dates for each month

versionId, juldate,augdate,sepdate,octdate,novdate,decdate,jandate,febdate,madater,aprdate,maydate,jundate

What i need to do is return individual rows for each month with the corresponding period date..

Id
versionId
salesvalue
salesenddate

I have been looking at Multi-Statement Table-Value Functions but haven't been able to get anywhere near this result..

Any assistance greatly appreciated..