Thanks for your kind responses. I have now extracted the data that I require from my tables, and almost as importantly achieved my desired visual layout with T-SQL alone!

Unfortunately I cannot use SSRS as I will be plugging the code into SAP Business One.

Thanks for your responses.

Thanks LinksUp