thx jmcilhinney

Can we see the query? > are u sure?????

If you can't make it more efficient in some way then most likely it would be best to create a stored procedure at least. -> maybe to figure it out to change IN clause to something else


PS: it involved lotsssss of IN Clause but i will post it just for you

hold on a sec..i need to prepare the data