I have read other posts on this topic but have not been able to locate
a solution. I'm trying to pass in variables into the OpenRowset
function that is used in a MS SQL Stored procedure. Here's the code:
FROM clarify..table_site as s
on s.objid = a.iobjid2site
What is the proper sytnax for including variables/parameters into the
OPENROWSET function? I tried using 'exec
I also tried adding additional single quotes around the parameter
names. I also tried declaring variables in the sp_permissionsget_test
procedure and then reference these in the OPENROWSET function.
Any info would be greatly appreciated!