[font="Verdana"]Try this.

Create Table dbo.SeqNum

(

AccountNbrInt

,CreateDateDateTime

)

Go

Insert Into dbo.SeqNum

Select 59961, '01/05/2009' Union All

Select 59961, '01/06/2009' Union All

Select 59961, '01/07/2009' Union All

Select 32187, '01/05/2009' Union All

Select 32187, '01/06/2009' Union All

Select 22195, '01/10/2009' Union All

Select 22195, '01/12/2009' Union All

Select 22195, '01/13/2009' Union All

Select 22195, '01/15/2009' Union All

Select 69248, '01/11/2009' Union All

Select 69248, '01/12/2009'

Go

Select(

SelectCount(AccountNbr) As Seq

Fromdbo.SeqNum B

WhereA.CreateDate >= B.CreateDate

And A.AccountNbr = B.AccountNbr

)As SeqNo

, A.AccountNbr

, A.CreateDate

Fromdbo.SeqNum A

Go

Drop Table dbo.SeqNum

Go

Mahesh[/font]