Re: Stored procedure with unknown numer of paramters, how?
- From: "Doug" <drmiller100@xxxxxxxxxxx>
- Date: 6 Apr 2006 10:24:29 -0700
celkos answer = GAG
GAG is an advanced sql topic that can be best summarized as the sound
the cat makes when regurgitating fur balls.
an elegant way where you have only one data element, but multiple
occurances is to pass the name of a temp table containing the data.
another way is to pass a delimited list - ugly code for sql to parse it
out, but multiple example are out there for leveraging and it is bug
free long term.