IF @XmlList IS NULL SELECT * FROM orders ord ELSE BEGIN DECLARE @hDoc int EXECUTE sp_xml_preparedocument @hDoc OUTPUT, @XmlList SELECT * FROM orders ord JOIN OPENXML(@hDoc, 'VFPData/crslist') WITH (customer_id char(6) ) lst ON ord.CustomerId = lst.customer_id EXECUTE sp_xml_removedocument @hDoc END>I think I am trying to make my problem too hard here.
>CREATE PROCEDURE usp_OrdersByList > @XmlList varchar(4000) = 0 >AS >DECLARE @hDoc int >EXECUTE sp_xml_preparedocument @hDoc OUTPUT, @XmlList >SELECT * FROM orders ord > JOIN OPENXML(@hDoc, 'VFPData/crslist') WITH (customer_id char(6) ) lst > ON ord.CustomerId = lst.customer_id >EXECUTE sp_xml_removedocument @hDoc >>