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
What i need to do is return individual rows for each month with the corresponding period date..
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..