Skip to content

TSQL

TSQL pattern matching as part of a table join

OK so anyone with some fundamental SQL knowledge will be able to read the following SQL statement and understand what it’s returning, let’s take a look:

To summarize we’re joining the FactInternetSales table to the DimCustomer table via the foreign key called CustomerKey. From the DimCustomer table we’re returning the LastName and FirstName and…

Read More

Need to search strings inside your SQL Objects? Try this utility

While performing¬†a migration from SQL Server 2000 to SQL Server 2014 (wow what a big jump), I needed to find all stored procedures that made a call to an extended stored procedure¬†that was being replaced with functionality that is baked into more recent versions. So what to do? Stack Overflow had a few good suggestions,…

Read More