Contents tagged with SQL Server
-
Creating a SQL Exclusion Table Using LEFT JOIN
For a current project I needed to create a table that contained a list of exclusions that should be filtered out from another table when a specific set of criteria were met. This is a pretty common scenario where you have a large table of data and you want to be able to provide the ability through a user interface for a user to filter the data using an exclusion list.
-
SQL Stored Procedure Modified Date Query
While working on a project I needed to determine the last modified date for some SQL stored procedures.