Archive for July 2015

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