I am trying to write a query that shows me how much I sold to every customer every day over the last 60 days. I want a day represented in my resulting dataset even if there were no sales on that ...

I Have an application that creates some form of log in a SQL table that has an identity column. An auditor checked these logs and found some gaps in the identity column sequence. Now, I know that this ...