Oh...Correct.

Thank a lot teachers.:)

I did that one. I saw remarkable change in the execution time.

Earlier it took 2.5 hrs, now it is taking 50 minutes only, still i am not happy with the...

All 3 work just fine if all you want to do is to detect that there is one or more. #3 is the fastest for this purpose. #1...

oh..Ok...I thought that 1782 is the maximum page per read.

Thanks Gila for pointing some good points.

so, what is your suggestion ?

Thanks for you reply.

As i haven't studied that article i am not in the...

1782 is better. Am i correct...

I heard that we should avoid <> operator because it leads to 'Table Scan'.

I think way #1 is best when we compare with way #2. Am i correct ?

what i am saying is #3 is not suitable for our requirement. #1 and #2 is working fine.

suppose if i have like

insert into #test

select 1

union all

select 0

union all

select 1

union all

select 0

union all

select 1

union all

select 1

union all

select 0

union all

select 1

union all

select 0

union all

select 1

union...

Once I repair the error in the #2 code you provided, it gives me the following...

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

3.0

(1 row(s) affected)

...

why i have used ? for your reference,

http://www.sqlservercentral.com/Forums/Topic492922-8-1.aspx#bm492981

select sum(sign(Sample)) from #test

select sum(convert(int,Sample) from #test

select max(cast( Sample as int)) from #test

Ok.I will explain it.

Assume...

I do agree my mistake.

for #1,

Create Table #PMgr

(

sP varchar(25) NULL,

MID varchar(10) NULL,

mm int Null,

yyyy int Null,

DateStart datetime Null,

monthEndDate datetime Null,

Flag char(1)

)

Insert into #PMgr (sP,mm,yyyy,DateStart,monthEndDate,Flag)

SELECT sP,

...