Thank you tonci korsano for your reply.

Hello Everyone,

Thank you for your time, I am able to find the solution with reference to same query at http://www.sqlservercentral.com/Forums/Topic1139620-145-1.aspx

Thank you

Yatish

Hi ChrisM@Work,

Thank you Very much , your solution is working perfectly as it is required for me. Thank you for your help.

Regards,

Yatish

Hi ChrisM@Work,

I tried the solution you found, but it is not grouping one set of letters History records, as with the below data ,

CREATE TABLE #History ( ...

Hello,

I was able to work on the solution but it is not completely what I want, still there are few issues, I thought I should update with my latest changes,...

Hi ChrisM@Work,

I while testing your suggestion I found for some data it is not working. I will explain this,

when I tried you solution for the below data,

Create TABLE #History

(

HistoryID INT,

Id...

Hi Ken McKelvey,

I have tried you solution but it is not working for the data below,

Create TABLE #History

(

HistoryID INT,

Id INT,

letterId INT,

Letter VARCHAR(2),

HistoryRank INT

)

INSERT INTO #History VALUES (1101795,265805,5,'NW',11)

INSERT INTO...

Hi srikant maurya,

Thank you for your reply, but in this case it will group all letters together and not as required for me...I mean if you look at output you...

Hello LutzM,

I have tried your suggestion and it has made impact on the performance when I looked at the execution plan. Thank you for your Help.

I have also another code...

Hi ChrisM@Work,

Thank you for helping me on this query, I have checked it with different letter's combination and other fields values and it is working. Thank you for Your Help.

Regards

Yatish

Hi ChrisM@Work,

Thanks for your reply, I did the change and below is the output for the same

Historyid ID ...

HI ChrisM@Work,

Thank you for your query Solution, but when I tested the output for the data as below.

INSERT INTO #Test(Historyid,ID,LetterNo,letter) VALUES(1,1,1,'C')

INSERT INTO #Test(Historyid,ID,LetterNo,letter) VALUES(32,1,1,'C')

INSERT INTO #Test(Historyid,ID,LetterNo,letter) ...

Hello All,

I will explain the output desired for me, if we consider below data

INSERT INTO #Test(Historyid,ID,LetterNo,letter) VALUES(1,1,1,'C')

INSERT INTO #Test(Historyid,ID,LetterNo,letter) VALUES(2,1,1,'C')

INSERT INTO #Test(Historyid,ID,LetterNo,letter) VALUES(3,1,2,'B')

INSERT INTO #Test(Historyid,ID,LetterNo,letter) VALUES(4,1,3,'A')

INSERT INTO...

Hi,

Thank you for your solution, I have tried for below data for which this is not working,

INSERT INTO #Test VALUES(1,1,1,'C',null)

INSERT INTO #Test VALUES(2,1,1,'C',null)

INSERT INTO #Test VALUES(3,1,2,'B',null)

INSERT INTO #Test VALUES(4,1,4,'A+',null)

INSERT INTO...

Hello frfernan,

Thank you for your reply. I need this for real life example only, I have modified the original fields names and added only sample example. I am creating this...