A while back, I wrote an application that processes sales information. These sales actually represent a hierarchy of data because there can be refunds, charge backs, charge backs of charge backs, refunds of refunds, adjustments, and so on and so forth. The way the data processing is handled, though, treating the entire hierarchy as a single transaction is important. This requires a bit of recursion.
.NET and SQL Recursion
posted on February 23, 2017 by long2know in ASP.NET, Database, Entity Framework, LINQ
Querying Timezones in MS SQL
posted on November 2, 2016 by long2know in Database
If you’ve read my various posts on dealing with datetimes and timezones lately, I discovered a handy little mechanism for dealing with timezones in Microsoft SQL.