karodhill (5/4/2015)
Im trying to create a procedure that if either one of the parameters are null then the other one will apply
Please go and read the blog post I referenced. What you're doing is very prone to performance problems and is not a good way of doing things.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability