asked
How to pass paramters to a remote procedure
How do you pass parmaters to a procedure being executed on a linked server... (@BEG_DT, @END_DT are the paramaters!!) INSERT INTO #TEMP EXEC ('REPORTING.dbo.PROC_NAME, @BEG_DT, @END_DT) AT [LINKED_SERVER_NAME]
I would look at `OPENROWSET` -
http://msdn.microsoft.com/en-GB/library/ms190312(v=sql.90).aspx EDIT. OK, so OPENROWSET has been disallowed by your DBA. Fair enough. Here's a useful-looking discussion: [How to pass a variable to a linked server query - MS Support site][1] What about EXEC LinkedServer.DatabaseName.SchemaName.StoredProcName @param1, @param2... If that doesn't work, then `OPENQUERY` may also be a way to go: DECLARE @OpenQuery varchar(max) --assuming your parameters are integers. If strings, or dates, then you'll need to add some ''''s SELECT @OpenQuery = 'SELECT * FROM OPENQUERY (LinkedServer, ''SELECT * FROM foo WHERE bar BETWEEN ' + @Param1 + ' AND ' + @Param2 + ''')' INSERT INTO #TempTable EXEC (@OpenQuery) (Untested code) [1]:
http://support.microsoft.com/kb/314520
14 People are following this question.
