Viewing 2 posts - 1 through 2 (of 2 total)
Why not use something like this:
="Select * FROM blablabla WHERE" + IIF(@region = null, " (employee = " + @employee + ")", IIF(@employee = null, " region = "...
April 1, 2009 at 2:39 pm
#970234
Did you try to update the appropriate statistics for the columns used in the query.I'm sure that will help your query to be faster by 5 times atleast.
October 16, 2006 at 8:11 am
#666019