>>>>>my statement: The go statement clears all temp variables... Your statement: That's not true.
>>>>>
>>>>>
>>>>>
>>>>>Rest my case..
>>>>
>>>>Temp variables is somewhat ambigious statement. If you would just say 'variables', then there will be no discussion. Besides, I was not sure how your post was in any relevance to what we were discussing.
>>>>
>>>>In any case, in my post I explicitly was talking about temp tables to avoid confusions.
>>>
>>>
>>>
>>>Ambiguous to you maybe.... anyway... i'm not arguing with you ..bye
>>
>>So, what is a temp variable in SQL? AFAIK there are temp tables and table variables, then you have local variables, but even though I admit am new to SQL server I have never heard of temp variables?
>
>There is no such term in SQL Server as 'temp variables'. All variables in T-SQL are local to the batch that created it.

Well I'm glad you corrected me.... Are you so anally retentive that you didn't know what I meant? Forget it don't answer, I already know the answer.