Many legacy systems from the 20th century stored dates as decimals due to limitations of the technology at the time. For example 08/03/2011 would be stored as a decimal with value 20110803. Modern reporting platforms that enab...

Financial organizations often want an aging report that categorizes transactions into 30 day blocks. How would you code a query for this type of requirement....

This question invites you to share your thoughts on writing reporting queries that deals with more than one databases....