How to obtain start and end values in a sequence grouped by another column value

• gvsriramakrishna

  Old Hand

  Points: 357

  More actions

  January 4, 2009 at 3:59 pm

  #383674

  Hi All,

  I have a requirement to obtain the start value and end value of a sequence based on a particular column.

  Ex:

  Serial Number - Reseller Name

  ===============================

  1001 RA01

  1002 RA01

  1003 RA01

  1004 RA01

  1005 RA02 --> This value changes in middle of sequence.

  1006 RA02

  1007 RA02

  1008 RA02

  1009 RA01 --> Again this value changes

  1010 RA01

  1011 RA01

  The requirement is to obtain the output for the reseller RA01 as:

  Start Val - End Val - Reseller Name

  ===========================

  1001 1004 RA01

  1009 1011 RA01

• george sibbald

  SSC Guru

  Points: 104210

  More actions

  January 4, 2009 at 4:10 pm

  #920918

  cross post, pls answer via

  http://www.sqlservercentral.com/Forums/Topic629528-391-1.aspx

  OP pls confirm version you are using is 2008.

  ---------------------------------------------------------------------

• gvsriramakrishna

  Old Hand

  Points: 357

  More actions

  January 4, 2009 at 4:17 pm

  #920920

  Current Version I'm running is :

  Microsoft SQL Server 2008 (RTM) - 10.0.1600.22 (Intel X86) Jul 9 2008 14:43:34 Copyright (c) 1988-2008 Microsoft Corporation Enterprise Edition on Windows NT 5.1 (Build 2600: Service Pack 2)