CREATE PROCEDURE sp_Test
@PropertyXML VarChar( 8000 ) = NULL
As
Create Table #Properties (PropertyID Int, EnumValueID int) 
If Not @PropertyXML Is Null
Begin  --получим в виде таблицы параметры, переданные в виде XML
 
	EXEC sp_xml_preparedocument @XMLHandler OUTPUT, @PropertyXML, @PropertyXML
	insert into #Properties (PropertyID, EnumValueID) 
		SELECT I_D, Val 
		FROM OpenXML(@XMLHandler, '/xml/rs:data/rs:insert/z:row',  0 ) 
		WITH (I_D Int, Val int) 
	EXEC sp_xml_removedocument @XMLHandler
End

Select Count(tbl_GoodsNames.I_D)
From tbl_GoodsNames
Where ((tbl_GoodsNames.I_D In 
	(Select GoodsNameID 
	From tbl_3_GoodsNAmesPropEnum 
	Inner Join #Properties 
	On tbl_3_GoodsNAmesPropEnum.PropertyID = Properties.PropertyID 
	Where #Properties.EnumValueID = tbl_3_GoodsNAmesPropEnum.EnumValueID))
Or (@PropertyXML Is NULL))