No dear thats what not i looking for.I have to eliminate repeating binder no.Max concept not applicable for following data.CREATE TABLE [REV_BINDERS](

[OFFICE_ID] [int] NOT NULL,

[BINDER_ID] [int] NOT NULL,

[BINDER_NO] [varchar](7) NULL,

);

go

INSERT...

Now i realized what i exactly want.

CREATE TABLE [REV_BINDERS](

[OFFICE_ID] [int] NOT NULL,

[BINDER_ID] [int] NOT NULL,

[BINDER_NO] [varchar](7) NULL,

);

go

INSERT INTO [REV_BINDERS]

([OFFICE_ID],[BINDER_ID],[BINDER_NO])

select 2105110 , 1,0101 union all

select 2105110,2,0102union all

select 2105110,3,0103union all

select 2105110,4,0104union...

I m exactly looking for this but can i obtain same result using dense rank??

Hey hi dear..

I want this output using dense rank eliminating repeating binder no

OFFICE_ID BINDER_ID BINDER_NO denserank

2105110 10 ...

Using function u can get desired result without cursors.I created split function above use that.

Declare @asd nvarchar(100)

select @asd=Field1 from Test where create_dt='24/Sep/2012'

...

Might be u get hel with dis.

CREATE TABLE dbo.Test

(

idint,

create_dt DATETIME NOT...

I think using sp_executesql can help out.Sp_executesql mainly used for dynamic store procedure.

U Nailed It..

Cool Guys u rock.

Could you give some good links to learn sql basics

Hello,

I need to count repeating alphabet only

a=6 thats it.

We can also use comma separted list to a table instead of DelimitedSplit8K function.Both function would produce same results

CREATE FUNCTION [dbo].[SplitList]

(

@List nvarchar(max), ...