The Situation You have a SQL Server stored procedure that needs variable for use in a query, but you don't want to pass it into the stored procedure as a parameter, and you don't want to hard-code it. Instead you have the value stored in a table and want to retrieve it from there. There … Continue reading How to Set a Default Value on a Configurable Variable in a SQL Server Stored Procedure Using IsNull()