>We have two way to query data
>
>1) Select * from customers where customerID in (12324, 24452,56785,34567 --- lots here 45564, 34355)
>
>Or
>
>2) Create a temp table #customertemp and put all the customerid in bracket in it.
>
>Then
>
>Select * from customers where customerID in (select customerid from #cutomertemp)
>
>Which way is better?
>
>
>Jim Hou

See Re: Variable IN Thread #834228 Message #834232