Can any one tell me how to convert result set into XML.

I can use the trigger to get the data using the below query but how can i store it like below

select * from deleted

For Example:

Table name : Employee

ID, Name,salary,createdate,modifieddate

1,xxx,123,10102010,03242010

If...

Arjun,

I understand, adding group in my table but in SSRS, In this exampl if you add group based on category then you will get the output like below

...

Ok I will try to give the example

I have a data like below

Pcategory Productname unitprice

xxxx pppp ...