This appears to be a presentation issue and is best handled in the presentation layer. Is there a compelling reason for trying to do this in the database layer?
Drew
need to get all the A first then B then C so as the SSRS shows them correctly column0 value wise.
Can i query the data from table 1 so that its replaced with table 2 as output?
Please explain a bit on your query ? what output are you exactly trying to get using SSRS ?