SQL Query: Joining a SQL Table with a Table-valued Function

Applications

Did you know that you can use a SQL Query to join together a SQL Table with a Table-valued Function into a single result set? Here’s how: I have created a Function that contains several calculations and returns some standard Project Metrics: CREATE FUNCTION [dbo].[fnGetProjectMetrics] (    @ProjectId int ) RETURNS @results table (     [ActivityStartDate] datetime     , [ActivityEndDate] datetime     ,…