temp tables are tied to procs they are created , once it ends so does the temp tables ; also no exchange

in case of temp tables even though another...

do you have to use case ? In these query conditions you can use temp variables to do the comparisons..

I ran the same query it gives the expected result..

Select a.t, a.tl, b.addr, c.zip

from a join b on a.ID = b.ID

join c

on a.ID= c.ID

Where a.tl...

could you post the output that you are getting ?

I still consider ranking functions as the easiest one.

thanks for the explanation.

oh, I meant that with the initial post ,which says the dynamic sql didn't work when it actually does ..

Avinash

Thanks Lynn.

I was just curious, how could it not work ..

Avinash

Although working in SSIS, i have been a fan of dynamic sql; it is preferred to avoid dynamic sql's.

An SSIS File system task could help you achieve that.

http://msdn.microsoft.com/en-us/library/ms140185.aspx

Avinash