I was asked to get a list of customers with a single address for each, and preferably the Postal address if the customer has one. Getting the first record is easy enough with a MIN function, but when you have to add an ORDER BY or GROUP BY […]
I have had this error several times on different servers, and here are the steps that I recommend following to find and resolve the problem. Step 1 – Track down the source of the error One of the things I found with this error, is that it doesn’t […]
In this article I will run through a problem I overcame where I needed to query a JSON array of attributes for each a record. I was working on a Stored Procedure that was querying JSON using REPLACE, SUBSTRING and a number of CHARINDEX‘s for every attribute. This […]
This article was written for SQL 2014 Summary If you have an SSRS subscription that emails out a report, but there is a requirement to only send that report if there is data, then that should be easy enough to do, shouldn’t it? From what I’ve found so […]
In the previous article I talked about using savepoints for nested transactions. In this article will talk about how to handle rollbacks, and what to do when the Stored Procedures you use have their own transaction handling. There was a quote that I read once, I can’t remember […]
Transactions are a great way to group statements together in an all or nothing batch.However, nesting transactions is where things get a little messy, some people even call them evil. I note here that a big part of the reason people don’t like nested transactions is because they […]
One of the applications I work with has more than 900 tables, so as you can imagine trying to determine where the data lives can sometimes be difficult. This script shows me which tables were updated by the last transaction. Add the database name in the USE and […]
Even though SQL Server 2016 has been out for a while now, and I’m sure there are plenty of articles on the new features that are available, I thought that I would write about are the features that I particularly like. Note that the outputs shown below are […]
Being sick of the difference between date formats in different systems, I decided to always format my dates in YYYY-MM-DD, Nobody’s going to get that screwed up, are they? I ran a query in an enterprise system today to retrieve everything since ‘2014-11-03’, it didn’t work???It turns out […]