Sergiy,

My friend....Don't feel....Also don't insert...

I am not asking how to implement Tally table to replace IN(@var)....

As a senior, you shouldn't discourage junior or medium...

is there any other command or clause that won't work directly with local variable ?

No....our eyes has the limitation.... :Whistling:

do you agree or not ?:D

Rosh,

will you see your back head directly ? 😛

But there is always a workaround.

I hope all of us know it.

We can see through mirror. 😀

Just kidding.

Rosh,

Thats what i am also saying...There is a workaround...But there is no direct way to use the local variable in IN and ORDER BY clause.

Can we say it as...

Rosh,

As you stated the below code will work for single value.

Declare @eno varchar(10)

declare @str varchar(100)

set @eno = '1'

select * from #tmp where eno in ( @eno)

But if am going to...

Steve,

Concur... Sometime we may miss what we know very well.

And...I have implemented both your method in that project depends on the situation.

But what i am saying is there is no direct way to use the local variable in an...

Glen/RP,

I do agree with you. Both of you gave the work around for the problem.

is it possible to use like below

select * from emp order by @column. This is what...

Glen,

You are correct !

My point is, we can't use local variable in the order by clause directly.

do you agree ?

Well, Execute the below one.

drop table #tmp

go

Create table #tmp

(

eno varchar(1),

ename varchar(25)

)

go

insert into #tmp

select '1','Karthik'

union

select '2','Keyan'

union

select '3','Mani'

Declare @eno varchar(5)

select @eno = '1,2'

select * from #tmp where eno in (@eno)

Glen,

We can use like you mentioed in your post.

But the below one won't work.

drop table #tmp

go

Create table #tmp

(

eno varchar(1),

ename varchar(25)

)

go

insert into #tmp

select '1','Karthik'

union

select '2','Keyan'

union

select '3','Mani'

Declare @Column varchar(5)

select @Column...

How ?