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
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
Viewing 2 posts - 1 through 2 (of 2 total)
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy