Error!
Success!

A better way to create a dynamic SQL stored procedure

0
kicks

A better way to create a dynamic SQL stored procedure  (Unpublished)

This one has been plaguing me for years: What is the best way to create a dynamic stored procedure that allows null inputs to filter results? Today, while working on another request to come up with a dynamic stored procedure for a specific report a client wants, I had an epiphany. If I use isnull() in conjunction to with the actual value, I can get the desired results, no matter what input(s) are null -if any or all.


Kicked By:
Drop Kicked By: