Execute the following Microsoft SQL Server T-SQL script in SSMS Query Editor to create a report on recent orders:

USE AdventureWorks;

GO

-- T-SQL SELECT TOP 3 most recent orders for specific customer

-- T-SQL create user-defined function - inline table-valued function - UDF - TVF

CREATE FUNCTION Sales.MostRecentOrders

               (@CustomerID AS INT)

RETURNS TABLE

AS

  RETURN

    SELECT   TOP ( 3 ) TotalDue = '$' + CONVERT(VARCHAR,TotalDue,1),

                       OrderDate = CONVERT(CHAR(10),OrderDate,112),

                       SalesPersonID

    FROM     Sales.SalesOrderHeader

    WHERE    CustomerID = @CustomerID

    ORDER BY OrderDate DESC

GO

-- T-SQL CROSS APPLY with TVF

SELECT   Store = Name,

         m.*

FROM     Sales.Store

         CROSS APPLY Sales.MostRecentOrders(CustomerID) AS m

ORDER BY Store,

         OrderDate DESC

GO

/*

Store                   TotalDue    OrderDate   SalesPersonID

A Bike Store            $29,418.53  20020501    280

A Bike Store            $31,972.17  20020201    280

A Bike Store            $22,152.24  20011101    280

A Great Bicycle Company $42.08      20031201    275

A Great Bicycle Company $528.99     20030301    275

A Great Bicycle Company $1,889.24   20020601    277

.....

*/