It is possible to use a stored procedure in a View ?
To use a stored procedure inside a View, you must create a linked server and use OPENQUERY statement:
Example:
Stored Procedure:CREATE PROCEDURE [dbo].[sp_getContacts]
AS
BEGIN
SELECT * from CONTACTS
END
GO
Create a linked server to your SQL Server instance
No instance example:Linked Server name:
.Named instance example:Linked Server name:
.\SQL1Where SQL1 is instance nameView:CREATE VIEW [dbo].[vStoredProcedureView]
AS
SELECT XXX FROM OPENQUERY([.\SQL1], '[myDatabaseName].[dbo].[sp_getContacts]') AS mySpInView
GO