Hey thanks Jinxsee and ChrisM@Work. Your solution works perfect. Thanks a lot.

One more question for Jinxsee, Suppose if we are using row_number() for a huge records it will minimize performance?

Please

Hi vyas,

The query provided by you gives an error. you can run your query try with below table structure & data.

create table tblStudent

(

Name varchar(100),

Month int,

Year int,

Mark int

)

insert into tblStudent(Name,Month,Year,Mark) values...

Hello,

Can you please tell me how to create CSV file......?