Attention! AM Attention! AM



Example:   Obtaining SQL column totals

You have an e-commerce web site that stores all sales data in the Amount column of the Sales table in your Microsoft SQL Server database. Every day at 11:45pm you would like a text message sent to your Blackberry with the total sales figures for that day.


Enter the following SQL Select statement in the Attention! AM SQL Agent:


     Select Sum(Amount)
     from Sales
     where DateDiff(dd,SalesDate,GetDate()) = 0




Obtaining SQL column totals

Privacy/Terms   
Copyright © 2007 - All rights reserved.