I am trying to do a select with openrowset from a stored procedure with a parameter but it is not working.
SELECT * FROM OPENROWSET( 'SQLNCLI', 'Server=SERVERNAME;Trusted_Connection=yes;', 'EXEC PROCEDURENAME @Set = 'Data')
If I run EXEC PROCEDURENAME @Set ='Data' it works OK.
Without parameters I have similar code that also runs well.
Regards Elio Fernandes