>>>>>>>>>>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.
>>>>>>>>
>>>>>>>>With your original statement I didn't know you meant local variables as it had no relevance to the topic under discussion. Therefore of course I assumed you talked about temp tables and corrected.
>>>>>>>
>>>>>>>I'm having trouble understanding you as you're missing to many commas in your sentences to make it legible...see I can be anal too.. and I can correct too, if you want.
>>>>>
>>>>>Sure, I always eager to learn proper English. You can correct my English any time you see a chance.
>>>>
>>>>What about Martina's reply?
>>>
>>>This isn't directed at you personally. So this is really addressed to all the contributors
>>>
>>>
>>>this was a technical discussion which now seems to have gone into the usual abuse.
>>>
>>>Whats going on ?
>>
>>
>>Petty personal conflicts amongst those who have the need to post everytime someone they don't like makes a post. Its to show how smart and superior they are...
>
>
>I've got to say as the person who asked the original question it is annoying.

It is therefore your fault <g>.