>You can run select like this w/o EXEC

select * from tablename where ckeyfieldname = @cwhere

I need the variable - this is not exactly what I am trying to do, just an example. Is there no way have the variable scoped?


Here is exactly what I am doing...
Stored Procedure

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
GO

Call 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.