I have an INT parameter in a sproc. I check it's value and change it to
NULL if it's zero so that I can use ISNULL in my select statement. This
worked well until I needed to convert this whole mess to dynamic SQL.
Now I'm confused as to how to deal with this parameter. (I'm using this
for an ASP.Net page) My question is, how can I alter the value of my
parameter in my IF statement and then use it later? It looks like this:
ALTER Procedure spYieldGridDynamic