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