SQL: Rolling up or archiving transactions past a cutoff date in T-SQL

added by DotNetKicks
11/7/2019 7:20:27 PM

240 Views

Another question that I recently saw on Stack Overflow was asking how you SELECT a bunch of transactions back past a cutoff date, add them up, INSERT a roll-up row, and then delete the old ones. The concern was with how you make sure the ones you are deleting are the same rows that you ...


0 comments