You really should do a search before posting a question. See if this article helps ... Temporary Tables vs. Table Variables and Their Effect on SQL Server Performance[^]

She hasn't turned down a pint in a very long time. :-D The report of my death was an exaggeration - Mark Twain Simply Elegant Designs JimmyRopes Designs Think inside the box! ProActive Secure Systems I'm on-line therefore I am. JimmyRopes

Yeah, Camels milk sounds pretty grim ============================== Nothing to say.

Thanks dear....You are probably right but there is something more.......Look at my Example proper and told that is possible or not in MySql