Counting Transactions per Hour using a Pivot Table

From SQLTeam – When you create a pivot table you rotate rows to columns. This produces a resultset that facilitates trend analysis. In the example shown in this article I show how to use a pivot table to display the number of transactions that occur per hour per day. Before we get to that, though, l

Read More - Register for Free Membership