Comments by Niju1 (Top 4 by date)

for where you get id? if from a table create another procedure to to call this procedure in a loop

Before trying this query .. i world like to know what is the need
if it is for reporting most of reporting tools gives cross tab report which will produce similar data , even if you use inner join for the query.. there is no need that the output should be in the same format or order

please explain i want catName assign value this query (select invnum from categories where id=1), or what is the expected result