November 2015 Summaries

The text discusses the implementation of User-Defined Table Types (UDTTs) and Table-Valued Functions (TVFs) in stored procedures for basic statistics gathering. It presents a scenario where an order database needs to provide a dashboard with metrics per order type, which can be achieved by storing smaller snapshots of statistics in another table called `order_stats`. The implementation involves creating TVFs and UDTTs, including the `tvf_gather_anayltics` function that accepts a temporary table of the UDTT type `udtt_order_stats`. A full example is provided with scripts to set up the database and create all necessary objects.