Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 Transact-SQL (2000)
 array split possible?

Author  Topic 

vicpal25
Starting Member

21 Posts

Posted - 2007-05-14 : 19:42:49
I am trying to create an array in t-sql and split the value by the comma and have some type of pointer that I can refer to:

SET @ProcArrayValues = '_v, .viw, csp, ibsp, cfn, ibfn, ctr'

khtan
In (Som, Ni, Yak)

17689 Posts

Posted - 2007-05-14 : 21:41:01
take your pick
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=25830&SearchTerms=CSVTable
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=76033


KH

Go to Top of Page

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2007-05-15 : 04:57:21
or
http://vyaskn.tripod.com/passing_arrays_to_stored_procedures.htm


Madhivanan

Failing to plan is Planning to fail
Go to Top of Page

Kristen
Test

22859 Posts

Posted - 2007-05-16 : 02:59:32
See also: http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=55210&SearchTerms=CSV,Splitting%20delimited%20lists,Best%20split%20functions
Go to Top of Page
   

- Advertisement -