Viewing 2 posts - 1 through 2 (of 2 total)
Not sure if your specific requirements and the approach I've used before mesh, but here's how I've used optional parameters in a WHERE clause before.
CREATEPROCEDURE spOptionalParam
...
October 29, 2003 at 7:15 am
#480101
I found this snippet in the SQL Books Online, SP3 version, in the reference for LIKE:
It is recommended that LIKE be used when you search for datetime values, because datetime...
July 30, 2003 at 7:22 am
#467726