Arrays in T-SQL? 1

[Waynest]

Hi

I think I am correct in saying that you can't declare an array of variables in T-SQL?

So how do you avoid massive duplication of code where you have to perform a loop 100+ times storing the results from each iteration?

There must be a workaround???

Thanks

 

[Glyndwr]

Waynest,

there aren't arrays as such but there are workarounds

declare @myArray table (id int , myValue char(10))

declare @cnt  int
set @cnt = 0

while @cnt < 10
	begin
		set @cnt = @cnt + 1
		insert into @myArray 
		values(@cnt, cast(@cnt as char(10)))
	end

select * from @myArray

Glyndwr

 

[Waynest]

aaah, thankyou

 

[JayKusch]

As as side note, Microsoft has recanted the use of table variables over temp tables that will be used with larger record sets. I will post the link as soon as I am able to relocate it. In saying this, your solution may need to be re-evaluated.

Thanks

J. Kusch