Hey Gurus

Can you  give me a clue to how to do the produce the following Output
from below table.

insert into Q2 (Emp_name,Category,StartDate,EndDate)
Select 'John', 'A10', '19961001','20000807'
Union
Select'John', 'G20', '20000803','20000815'
Union
Select 'John', 'A20', '20000807','20000822'
Union
Select'John', 'G30', '20000817','20000825'
Union
Select'John', 'A30', '20000822','99991231'

I want the result to Look like Where I want to break the report by category


Emp_Name Category1 Category2 StartDate EndDAte
John A10   20000801 20000803
John A10 G20 20000803 20000807
John A20 G20 20000807 20000815
John A20   20000815 20000817
John A20 G30 20000817 20000822
John A30 G30 20000822 20000825
John A30   20000825 20000831

Optimal storage of a lot of text records
T Sql Help
Top N worst groups SQL problem
SQL Server 2000 Automatic Setup Script.
Which primary key