>>>>>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.
If it's not broken, fix it until it is.
My Blog