Array as input parameter

  • Thread starter Thread starter Mircea Pleteriu
  • Start date Start date
M

Mircea Pleteriu

Hi all,

I need a SQL stored procedure that has an input parameter of type array of
datetimes.
How to define such a procedure? if possible

Thanks,
 
Hi Mircea,

You can accumulate the dates in a string and pass them into a dynamically
created sp for use in an 'in' or 'between' clause. If you need an example
of what I'm referring to, let me know.

HTH,

Bernie Yaeger
 
Back
Top