I use window functions a lot however; I often find myself having to remind myself on certain syntaxes or the different outputs between two functions. The following code snippet is used just as a reminder on what is available and is not a complete exhaustive list. The following code consists of three different CTES. Here … More TSQL Tips – Window Functions
There are occasions when testing TSQL that we only need a small amount of input data and do not want to go through the hassle of creating, populating and then deleting tables. A nice quick solution is generating dynamic data through a Common Table Expression (CTE). Take a look at the following code. WITH CTE … More TSQL Tips – VALUES in FROM Clause
If you have a multi-layered application you may want to keep the file and assembly version numbers of all the assemblies the same. This would entail editing each AssemblyInfo.cs file. An alternative is to create a single file holding the versions and referencing it from each projects. Let me show you how. Imagine the following … More Visual Studio – Synchronize a Version Number across Multiple Assemblies
How many times have you just thrown something together, put it in the wild, expecting to never hear from it again and then five years later you get an email with this in it. Oh, just me then. In this instance it was a fix for Excel 2010 and I thought it was not used … More Five year old piece of code suddenly fails.
There are times when you create an assembly executable that has dependencies on other assemblies. You may want pass this assembly around without having the need for it to be installed however; if you have to copy DLL’s around with the EXE, there could be a chance that they are forgotten or the wrong versions … More Embedding .NET Assemblies inside .NET Assemblies
The TRY/CATCH/FINALLY exception handling has been around since C# 1.0 and you are very unlikely to find a developer who does not know how to use them. What may not be so obvious is that there are a number of hidden gems that few developers use. This is on top of new enhancements that have … More C# Exceptions – Hidden Gems
Developing TSQL summary reports by some variation of date is a very common requirement. Therefore having a library of date expressions is very useful. Below are a group of the common expressions I use. First and Last Day of the Previous Month SELECT CAST(GETDATE() AS DATE) AS [Today], CAST(DATEADD(dd, -(DAY(DATEADD(mm, 1, GETDATE()))-1), DATEADD(mm, -1, GETDATE())) … More TSQL Tips – Useful Date Calculations