select * from tablename where ckeyfieldname = @cwhereI need the variable - this is not exactly what I am trying to do, just an example. Is there no way have the variable scoped?
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 -- Get Data EXEC (@sql_string) -- Select data -- Remove XML document EXEC sp_xml_removedocument @idoc GOCall to the sp
exec getdata_wayne '<A><B>99WCAL138462</B></A>', 'SELECT PREMIUMHEADER.CPOLICYNUM FROM OPENXML (@@idoc, "/A/B",2) WITH (I varchar(16)) AS JT , PREMIUMHEADER WHERE PREMIUMHEADER.CPOLICYNUM = JT.I'The sql_string is created dynamically in VFP. I do not have the @idoc for the OPENXML call.