title: Call remote function from View - SQL Server
body: <p>I looking for a way to call <code>REMOTE FUNCTION</code> in <code>SELECT</code> clause in <code>VIEW</code>.
  Basically I'am trying to do somthing like this:</p>
  
  <pre><code>    CREATE VIEW [dbo].[View_Year_Forcast] AS
          (SELECT    BshForecast.ProjectId, 
                     BshForecast.JobTypeId,
                     Job_Type.NAME,          
                     ProjectName , 
                     ProjectManagerID,                       
                     ProjectManagerName , 
  
  
  ***EXEC @START_DATE  =[192.168.0.10].[LudanProjectManager].[dbo].[func_Project_Get_Start_Date] @PROJECT_ID as [Start_Date],***
  
                     StartBudget , 
                     AdditionalBudget , 
                     TotalBudget  , 
                     UsedBudget ,   
          FROM       BshForecast  INNER  JOIN Job_Type ON BshForecast.JobTypeId = ID                   
          WHERE   (dbo.BshForecast.Year = DATEPART(YYYY,GETDATE()))   
                  AND (dbo.BshForecast.IsDeleted = 0) 
                  AND (dbo.BshForecast.BranchId = 200)
                  AND (dbo.BshForecast.Approved = 1) );
  </code></pre>
  
  <p>And what I'am trying to get is a view that the seven'th column will hold the start date of each project that will be evaluate from a function in remote server.</p>