Hi, I have 2 sprocs.
They both contain the same logic, differing only in a boolean flag at the end.
eg:
sproc 1 = "AND a.isClosed = 1"
sproc 2 = "AND a.isClosed = 0"
I feel I should therefore put the common logic into a SINGLE location.Should I put this common logic into a view, sproc, or UDF?
I'm not sure which.
can anyone advise?
cheers,
yogi