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.
.
- Follow-Ups:
- Prev by Date: Re: Problem with a join due to multiple Nulls
- Next by Date: Re: Cursor looping versus set-based queries
- Previous by thread: Re: Problem with a join due to multiple Nulls
- Next by thread: Re: Stored procedure with unknown numer of paramters, how?
- Index(es):