Create TSQL Queries for Report Development

Let's create a small Meter Report using the information published in SQL Server by SQL Access.

Note: The Templates and Attributes used throughout \the TSQL Query topics will most likely differ from the ones you may have for your Database.

The following are the some of the steps we might use:

• Select CASEs Function
• Liquid Meters Function
• Gas Meters Function
• Solid Meters Function
• Meters Stored Procedure
• Testing the Stored Procedure