Viewing 2 posts - 1 through 2 (of 2 total)
I'd use a temp table like they mentioned earlier. Then you can add any indexes to the temp table that you want which will help speed things up too....
November 15, 2010 at 9:01 am
#1250789
I just think it's hilareous what the SQL 2008 intellisense looks like (newline characters and all) when you perform a select against this 'table':
select dbo.[VarArray[]](i int)
GO
begin tran
insert into VarArray(i) select...
October 12, 2010 at 7:59 am
#1235536