CREATE procedure dbo.getdata_wayne
	@doc as ntext, @sql_string as ntext
AS
declare @idoc int
	-- Parse XML String	
	EXEC sp_xml_preparedocument @idoc OUTPUT, @doc
	-- Select data
	EXEC sp_executesql @sql_string, N'@idoc int', @idoc
	-- Remove XML document		
	EXEC sp_xml_removedocument @idoc
GO
exec getdata_wayne '<A><B>99WCAL138462</B></A>', 
'SELECT * FROM OPENXML (@idoc, ''/A/B'',2)'

exec getdata_wayne '<ROOT><ID_S KEYVALUE=''99WCAL138462''/></ROOT>', 
'SELECT * FROM OPENXML (@idoc, ''/ROOT/ID_S'',1)'