>2. I am using temp table that is what I read in one of the messages. What I do is convert an XML text passed to sproc to a temp table. Then this temp table is used in a SQL Select, in a JOIN. And I don't know what "table variable" is? Maybe you can teach me, please.
You can convert XML into derived table and than use it in JOIN.
