Example:

If we got the traditional Orders table and OrderItems table as follows:

Orders (id int,OrderDate smalldatetime)

OrderItems ( ItemID int, OrderID int , ItemPrice money)

Several storeprocs and views might do this...