Hi

Thank you for your response.

In my scenario faculty details is dynamic for  each course code . Example purpose I have mentioned three course codes.Sorry previously I am not mentioned this...

Hello,

Thank you for your kind response

In this scenario, the goal is to generate a report according to client requirements without using any reporting tools. The query output is directly rendered...

Sorry Edited

Thank You. Its working fine

Thank you.I am looking select statement

Thank you for  your response. As per your request I added identity  column in that table. Please help me.

I need Query for this output. Frankly, i am not good in PIVOT

In my requirements input parameter is

Start date and end date.

Based on count I want to create a date column. Based on this column I need a count.

Thank You

Sorry i did mistake my Question now corrected ,In my scenario i have two tables

create table #tblCombineCourseMaster(Combinecourseid char(9),Courseid char(9))

insert into #tblCombineCourseMaster values (‘110100013',’110100009’)

insert into #tblCombineCourseMaster values (‘110100013',’110100012’)

create table #tblSectionCoursemaster(courseid char(9),subcourseid...

• This reply was modified 5 years, 7 months ago by  vs.satheesh.

Thank you for your reply. But my client using sqlserver2005.This Query not working in sqlserver2005.

Thank You for replay.My client using SQL server 2005 . This Query not working sqlserver 2005.

Dear Friend,

Please give me same sql query for sql server 2005

Regards

V.S.Satheesh