>This stored procedure is intended to return a list of publishers matching two criterion. First, is the publisher "active or inactive"? Second, to which subgroup does the publisher belong? Multiple subgroups may be selected. As a result we might want to find all active publishers belonging to group(s) "A" and "B". The procedure runs without error, but returns only publishers from the first group selected.
>
>Any suggestions for modification would be greatly appreciated.
>
>
CREATE Procedure usp_VORPublishers
> /* Param List */
>
> @cActive char(1) = "A",
> @cCategory char(10)= "A,B"
>
>AS
>
> SELECT
> vor_publisher_abc_list.Ctrl_Pubn,
> partname.pubname,
> vor_publisher_abc_list.stat_cd,
> vor_publisher_abc_list.list_cd
> FROM
> vor_publisher_abc_list
> LEFT OUTER JOIN
> partname
> ON vor_publisher_abc_list.Ctrl_Pubn = partname.ctrl_pubn
> WHERE
> vor_publisher_abc_list.Stat_cd = @cActive
> AND
> vor_publisher_abc_list.List_cd IN (@cCategory)
> ORDER BY partname.pubname
>>
>Regards,
>
>Jason
Okay, I get the
I'M STUPID AWARD FOR TODAY I figured it out.
Thanks,
J.
Jason Tryon
Senior Systems Analyst / Technical Lead
eBusiness / iPage