Hi
In a script I'll be using in Query Analyser I want to simulate an array as SQL Server doesn't support them as such.
What I'd like is something like:
@MyArray = "a,b,c,d"
<do_some_processing_of>@MyArray = "a"
<do_some_more_processing to find the 2nd entry>@MyArray = "b"
etc
Hope that makes sense!
Any thoughts?
I can't use a temporary table to hold the array data for various reasons.
Ta
-Colin
In a script I'll be using in Query Analyser I want to simulate an array as SQL Server doesn't support them as such.
What I'd like is something like:
@MyArray = "a,b,c,d"
<do_some_processing_of>@MyArray = "a"
<do_some_more_processing to find the 2nd entry>@MyArray = "b"
etc
Hope that makes sense!
Any thoughts?
I can't use a temporary table to hold the array data for various reasons.
Ta
-Colin