Stored procedure from asp help

[Mike D]

I have a stored procedure that I am executing with this SQL
osp_instrument_swap @InstrumentFrom = 'testname', @InstrumentIDTo = 37,
@Schedules = '593, 594, 596, 598, 599, 600, 601, 602, 603, 604, 605, 606,
607, 608, 609, 610, 611, 612, 613, 616'

the @Schedules are ID fields in a table that are integers. I would like to
do an Update blah, Where ScheduleID in (@Schedules) instead of looping. How
can I do this? I have to sent the values to the sproc as text, right? Where
do I covert to the int data type and how?

Thanks for your help
Mike

[Aaron [SQL Server MVP]]

http://www.aspfaq.com/2448

--
http://www.aspfaq.com/
(Reverse address to reply.)


"Mike D" <Mi***@discussions.microsoft.com> wrote in message
news:B1**********************************@microsof t.com...

I have a stored procedure that I am executing with this SQL
osp_instrument_swap @InstrumentFrom = 'testname', @InstrumentIDTo = 37,
@Schedules = '593, 594, 596, 598, 599, 600, 601, 602, 603, 604, 605, 606,
607, 608, 609, 610, 611, 612, 613, 616'

the @Schedules are ID fields in a table that are integers. I would like to do an Update blah, Where ScheduleID in (@Schedules) instead of looping. How can I do this? I have to sent the values to the sproc as text, right? Where do I covert to the int data type and how?

Thanks for your help
Mike

[Mike D]

Am I missing something? I read that and don't see anything that applies to
my problem. Did you post the right link?

Thanks again
Mike

"Aaron [SQL Server MVP]" wrote:

http://www.aspfaq.com/2448

--
http://www.aspfaq.com/
(Reverse address to reply.)


"Mike D" <Mi***@discussions.microsoft.com> wrote in message
news:B1**********************************@microsof t.com...

I have a stored procedure that I am executing with this SQL
osp_instrument_swap @InstrumentFrom = 'testname', @InstrumentIDTo = 37,
@Schedules = '593, 594, 596, 598, 599, 600, 601, 602, 603, 604, 605, 606,
607, 608, 609, 610, 611, 612, 613, 616'

the @Schedules are ID fields in a table that are integers. I would like

to

do an Update blah, Where ScheduleID in (@Schedules) instead of looping.

How

can I do this? I have to sent the values to the sproc as text, right?

Where

do I covert to the int data type and how?

Thanks for your help
Mike

[Bob Barrows [MVP]]

Mike D wrote:

I have a stored procedure that I am executing with this SQL
osp_instrument_swap @InstrumentFrom = 'testname', @InstrumentIDTo =
37, @Schedules = '593, 594, 596, 598, 599, 600, 601, 602, 603, 604,
605, 606, 607, 608, 609, 610, 611, 612, 613, 616'

the @Schedules are ID fields in a table that are integers. I would
like to do an Update blah, Where ScheduleID in (@Schedules) instead
of looping. How can I do this? I have to sent the values to the
sproc as text, right? Where do I covert to the int data type and how?

Thanks for your help
Mike

This is relevant:
http://www.sommarskog.se/arrays-in-sql.html

Bob Barrows
--
Microsoft MVP - ASP/ASP.NET
Please reply to the newsgroup. This email account is my spam trap so I
don't check it very often. If you must reply off-line, then remove the
"NO SPAM"

[Aaron [SQL Server MVP]]

Sorry.
http://www.aspfaq.com/2248

--
http://www.aspfaq.com/
(Reverse address to reply.)


"Mike D" <Mi***@discussions.microsoft.com> wrote in message
news:54**********************************@microsof t.com...

Am I missing something? I read that and don't see anything that applies to my problem. Did you post the right link?

Thanks again
Mike

"Aaron [SQL Server MVP]" wrote:

http://www.aspfaq.com/2448

--
http://www.aspfaq.com/
(Reverse address to reply.)


"Mike D" <Mi***@discussions.microsoft.com> wrote in message
news:B1**********************************@microsof t.com...

I have a stored procedure that I am executing with this SQL
osp_instrument_swap @InstrumentFrom = 'testname', @InstrumentIDTo = 37, @Schedules = '593, 594, 596, 598, 599, 600, 601, 602, 603, 604, 605, 606, 607, 608, 609, 610, 611, 612, 613, 616'

the @Schedules are ID fields in a table that are integers. I would

like to

do an Update blah, Where ScheduleID in (@Schedules) instead of

looping. How

can I do this? I have to sent the values to the sproc as text, right?

Where

do I covert to the int data type and how?

Thanks for your help
Mike

[Mike D]

Thanks to both of you for your replies. It helps me solve the problem. Does
the new SQL Server (2005?) have any better way to handle arrays than SQL
Server 2000??

Thanks
Mike
"Bob Barrows [MVP]" wrote:

Mike D wrote:

I have a stored procedure that I am executing with this SQL
osp_instrument_swap @InstrumentFrom = 'testname', @InstrumentIDTo =
37, @Schedules = '593, 594, 596, 598, 599, 600, 601, 602, 603, 604,
605, 606, 607, 608, 609, 610, 611, 612, 613, 616'

the @Schedules are ID fields in a table that are integers. I would
like to do an Update blah, Where ScheduleID in (@Schedules) instead
of looping. How can I do this? I have to sent the values to the
sproc as text, right? Where do I covert to the int data type and how?

Thanks for your help
Mike

This is relevant:
http://www.sommarskog.se/arrays-in-sql.html

Bob Barrows
--
Microsoft MVP - ASP/ASP.NET
Please reply to the newsgroup. This email account is my spam trap so I
don't check it very often. If you must reply off-line, then remove the
"NO SPAM"

[Aaron [SQL Server MVP]]

> Thanks to both of you for your replies. It helps me solve the problem.
Does

the new SQL Server (2005?) have any better way to handle arrays than SQL
Server 2000??

If you're brave enough to try the CLR, you can code stored procedures and
other modules using .NET languages. So I imagine there is a way to do it
yourself, but nothing native... there are still no such things as "arrays"
in relational data...

There is better XML handling, so you might be able to pass data structures
in that way, as well.

--
http://www.aspfaq.com/
(Reverse address to reply.)