FUNCIÓN TIPO TABLA

CREATE FUNCTION [Billing].[fn_GetSumItems]

(

    @Id         NUMERIC

)

RETURNS @ItemsTable TABLE               --

(

       Column1    MONEY,

       Column2    MONEY,

       Column3    MONEY

)

AS

BEGIN

         DECLARE @Variable INT;

         INSERT INTO @ItemsTable (Column1, Column2, Column3)

  

         SELECT TotalAmount = SUM (TotalAmount)                    

                           ,ServiceAmount      = SUM (ServiceAmount)

                           ,TaxAmount          = SUM (TaxAmount)

         FROM       SchemaName.TableName

         WHERE             Id = @Id

       RETURN

END