I recently had to use back end data from SQL Server to deliver several reports in excel. All of my SQL code gave me results in seconds; however, the users had distinct formatting requests. I would have to use a few excel tricks to get things just right in each report.
DateDiff is a great tool in SQL Server. But you have to extend DateDiff a bit to get things in a nicer format, such as HH:MM:SS. See what Rudy found on SQLServerCentral.com which saved the afternoon!
If you’re like me, you like using descriptive variable, procedure and function names. Along with those, descriptive transaction names are
Rudy Rodarte is thinking about taking an MCM immersion class given by the good folks over at http://www.sqlskills.com.
