> >>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.
This is exactly what I am trying to do. When you hear me screaming with joy, it means I have succeeded <g>.
"The creative process is nothing but a series of crises." Isaac Bashevis Singer "My experience is that as soon as people are old enough to know better, they don't know anything at all." Oscar Wilde "If a nation values anything more than freedom, it will lose its freedom; and the irony of it is that if it is comfort or money that it values more, it will lose that too." W.Somerset Maugham