Post reply

Need help with a query

  • July 14, 2005 at 2:20 pm

    #574581

    Declare @A table (id int not null identity(1, 1), name varchar(50) not null primary key clustered)

    Insert into @A (name) values ('atr')

    Insert into @A (name) values ('d')

    Insert into @A (name) values ('cr')

    Insert into @A (name) values ('al')

    Insert into @A (name) values ('ct')

    Insert into @A (name) values ('cz')

    Select * from @A

    Select id from @A A inner join (Select left(name, 1) as Letter, max(name) as Name from @A group by left(name, 1)) dtNames on A.Name = dtNames.Name

    id name

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

    4 al

    1 atr

    3 cr

    5 ct

    6 cz

    2 d

    id

    -----------

    1

    6

    2

  • July 14, 2005 at 2:33 pm

    #574585

    Thank you!!!!!

     

  • July 14, 2005 at 2:36 pm

    #574586

    NP... don't waste another day next time .

Viewing 3 posts - 1 through 4 (of 4 total)

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