The Amazing Adobe Acrobat

The Amazing Adobe Acrobat Kelly Cummings I’ve worked in technology since before the days of GUIs, so Adobe Acrobat has been nothing new to me over the past 20 years or so. We have all used it. Even the most computer illiterate person in your office has more than likely read a file in PDF…

Read Moreabout The Amazing Adobe Acrobat

How Many Days Since Previous/First Order?

Some of the most popular courses we teach are the ones dealing with writing SQL queries against SQL Server. Recently I had some students ask how, for each order, can I see the number of days since the customer’s most recent order, as well as the number of days since the customer’s first order. Actually, these students were working in the healthcare industry, and they wanted to know the number of days since a patient’s most recent appointment and the number of days since the same patient’s first appointment, but we’ll adopt the question to order data to make it easy to practice with the many variations of SQL Server sample databases. How to solve the problem? SQL Server Window Functions to the rescue.


Read Moreabout How Many Days Since Previous/First Order?
 Previous 1 2 Next     1 2 10