How to get start and end value from a sequence of numbers - Grouped by a different field.

Question

Post reply

How to get start and end value from a sequence of numbers - Grouped by a different field.

Viewing 6 posts - 16 through 20 (of 20 total)

You must be logged in to reply to this topic. Login to reply

Jeff Moden SSC Guru Points: 1004339 More actions · Answer 1

gvsriramakrishna,

Just a little feedback on your part would be much appreciated. 😉

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

Jeff Moden SSC Guru Points: 1004339 More actions · Answer 2

gvsriramakrishna,

You must really like pork chops... 😉

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

Adi Cohn-120898 SSC-Dedicated Points: 33944 More actions · Answer 3

Jeff please don’t get this question the wrong way, but just out of curiosity – Is there anyone in this world that didn’t get your flying pork chops?

On more serious note, I also expect posters to give us some indication about the solutions that were offered to them and about the solution that they selected.

Adi

--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/

For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

Jeff Moden SSC Guru Points: 1004339 More actions · Answer 4

Adi Cohn (2/14/2009)
Jeff please don’t get this question the wrong way, but just out of curiosity – Is there anyone in this world that didn’t get your flying pork chops?
On more serious note, I also expect posters to give us some indication about the solutions that were offered to them and about the solution that they selected.
Adi

Heh... not sure... what's the current population of the world? 😛

Yeah... I think it's just rude when folks don't even take the time to acknowledge that something worked or what they did. They forget that forums are a two way street and that the people offering solutions frequently learn something, as well.

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

gvsriramakrishna Old Hand Points: 307 More actions · Answer 5

Hello Guys out there,

Thanks for the overwhelming response.

I lost my login pwd for the forum... haven't logged in for long time.

thanks every one guys.

It worked out.

Jeff Moden SSC Guru Points: 1004339 More actions · Answer 6

I know it's been close to a month and you may have forgotten... do you remember what you did to get it to work out?

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)