do you look for sometinh like this:

declare @area table(

AreaID int,

Area_SubAreaID int,

SubAreaID varchar(2)

)

insert into @area

(AreaID, Area_SubAreaID , SubAreaID )

select 5689 , 568901 , '01'

union all

select 5689 , 568903 , '03'

union...

I do not unsterstand the question

are you looking something like this?

declare @counter table

(

pk varchar(2)

)

insert into @counter

(pk)

values

('1'),

('2'),

('3'),

('10'),

('11'),

('2c'),

('2'),

('23'),

('24'),

('25'),

('1a'),

('1b'),

('1j'),

('2a'),

('2b')

select

pk

from

@counter

order by

convert(bigint ,

substring(pk,1,case

When PATINDEX('%[^0-9]%',pk)> 0...

The only problem that I had was solved in "Cumulative update package 1 for SQL Server 2005 Service Pack 3"

The reason of this package is that 2005 SP2 CU10...

no,...

I am sorry This is sql 2008.

i repost it in the correct group

thank you for the explanation

hi ,

You are saying that table variables always are stored in tempdb.

the reason I was asking the question was the following line from http://blogs.msdn.com/sqlserverstorageengine/archive/2008/03/30/sql-server-table-variable-vs-local-temporary-table.aspx

The table variable is NOT necessarily...

The question I had, was not the XOR swap but the following,

When I write “Select @variable1 =… ,  @variable2 =@variable1 + … ;”

please check for sql 2000

http://www.sqlservercentral.com/scripts/viewscript.asp?scriptid=1589

for sql 2005

http://www.sqlservercentral.com/scripts/viewscript.asp?scriptid=1608