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