T-SQL and Arrays

[RobS23]

How do i go about creating Arrays in T-SQL?

I'm converting a VB routine and there really isn't any way of avoiding including a small array in my code.

Cheers

 

[Jerrycurl]

A temp table would probably be the easiest solution.

 

[desi2002]

u can use cursors (similar to array).

 

[tlbroadbent]

A cursor is really more of a record set than an array. You can use temp tables or in SQL 2000 Table Variables. You may want to consider using delimited strings to simulate arrays. See the following links about parsing strings.

http://www.sqlteam.com/item.asp?ItemID=637

http://www.swynk.com/downloads/fafn_parse_delimited_list.txt

You may need to download the following scripts before viewing them.

http://www.swynk.com/downloads/splitquery.sql

http://www.swynk.com/downloads/MultiValueParam.sql

Terry L. Broadbent
Programming and Computing Resources

http://tlbroadbent.home.attbi.com/prog.htm

 

[RobS23]

Thanks all. I thought I'd end up using a Temp table - but I'll look into Cursors and delimited Strings too.

Cheers Again