mercredi 21 septembre 2016

SQL Server: How to write query to bring data in particular format?

I have below sample data: Here Events are repeated twice.

Sample data

Now I want to write query to display data in the below format. Output data

I am trying to use RANK function. I am running out of ideas.... Anyone, Please help me with query. Thanks

Aucun commentaire:

Enregistrer un commentaire