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, 5 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

Thank you for ur reply

What is sys.fn_get_folder? Is it system Function ? Which version?

Still I am not able to send a mail.Please give me s solution.

Hi My question is i want move data from production server to testing server.I want take transfer the data in source to destination in all the 50 tables.But one condition...

Thank You

HI Still i am not getting answer.One small changes I use only one table,that table i store a values like a

registerno

101

102

103

104

105

106

107

109

110

120

121

122

123

124

125

127

129

130

I want following result like following manner

101-107,109-110,120-125,127,129-130

Please help me