Adrian,

You are correct. But i don't have the permission to create functions. Can you provide some other alternate ways ?

Hi Adrian,

Thanks. I have modified your code.it is working perfectly.

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

CREATE TABLE #results

(

empNo INT,

accNo VARCHAR(50),

salary VARCHAR(50)

)

insert into #results values(100, '1000', '10000')

insert into #results values(100, '2000', '20000')

insert into #results values(100,...

This is...

Thanks a lot Ryan ! Really it opens my eyes broadly.

CBAC - Context Based Access Control which is related to Network protocols.

what do you mean by TBAT ? I am...

why and How...

rbarry,

Thanks for your prompt reply.

can i arrange a hot coffee for you ?

Jeff,

Ok. No problem.

As you said, He used N as a column name.Please take a look at below the code.

SELECT TOP 11000 --thanks to Jeff Moden for this technique

...

I would like to add some more things.

if i execute the below one, it is giving 3 as the output.

Declare @Nm varchar(25),@Null int

--select @Nm = 'Age'

select @Null = count(*) from...

Yes.

what will happen internally is

Declare @Nm varchar(25)

select @Nm = 'Age'

select @Null = count(*) from #t1 where @Nm is null

it means select @Null = count(*) from #t1 where Age...

rbarry,

Thanks a lot.

what do you mean by 'N Between N' ?

I tried out it in a sample query. It is showing NULL in the first Row.Remaining rows are showing...

can we use master..spt_values table to avoid RBAR logic ?

Gila,

what it means ?

Thanks Raja.

karthikeyan (4/23/2008)

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

Carl Federl

select @Nm = 'Age'

select @Null = count(*) from #t1 where (@Nm) is null

As "where (@Nm) is null" will always be false, zero rows will meet the...

karthikeyan (4/23/2008)

Carl Federl

As "where (@Nm) is null" will always be false, zero rows will meet the

restriction....