Openquery

Category: SQL Server

How to run a stored procedure on a linked server and fetch the data on SQL Server 2005:

This is carried out by using openquery. Setup the linked server in server objects, then call the server using a tabled-valued function

CREATE FUNCTION p_get_closing_prices
(	
	-- Add the parameters for the function here
	@valueDate datetime
	
)
RETURNS TABLE 
AS
RETURN 
(

select * from openquery(SALD157, 'exec CreditPricer.dbo.p_get_closing_prices ''18 feb 2008''') 

	
)

Tags: