Writing date-based queries with SQL Server are common in our industry. Writing good queries is likely less common. As a subscriber to the MS SQL Tips new letter, I frequently encounter useful information and helpful tips. “Using a calendar table in SQL Server – Part 1” by Aaron Bertrand (2021-04-22) is particularly useful for creating… Read More
C#, Excel, and SQL Server
Using Excel to work with SQL Server data sets is often more convenient than having to write a complete solution using C#. A variety of solutions exist to work with Excel from your C# code and Microsoft.Office.Interop.Excel is just one of them. EPPlus is also a popular solution for working with Excel. EPPlus is free… Read More
SQL Server – Dynamic Data Pivot
Creating a pivot table dynamically is not difficult as it may seem. Try it and you’ll see how relatively simple it can be. Read More
SQL Server – MERGE
I write numerous queries and admittedly few of them involve the use of MERGE, but this article posted on mssqltips.com titled “Using MERGE in SQL Server to insert, update and delete at the same time” by Arshad Ali (2019-04-09) has given me cause to change. The article presents a very simple example of how MERGE… Read More