>I understand now. I created Mike's SP in a database and then I called it from the Query Analyzer. It dosen't work....
>

>use AcmeTraining
>declare @lcCust1 varchar(600)
>set @lcCust1 = '<customers> <id value="227"/> <id value="228"/> </customers>'
>execute usp_CustomersSelect @lcCust1
>

>
>returns error: Invalid object name 'customers'.

This works for me

CREATE PROCEDURE usp_CustomersSelect
 @customerIDs text
AS
 DECLARE @hDoc int

 EXECUTE sp_xml_preparedocument @hDoc OUTPUT, @customerIDs

 SELECT * 
 FROM 
OPENXML(@hDoc, 'customers/id') WITH (value int) x

 EXECUTE sp_xml_removedocument @hDoc 
GO
declare @lcCust1 varchar(600) 
set @lcCust1 = '<customers> <id value="227"/> <id value="228"/> </customers>'
execute usp_CustomersSelect @lcCust1