Viewing 15 posts - 2,371 through 2,385 (of 26,488 total)
November 21, 2017 at 1:39 pm
November 21, 2017 at 1:17 pm
Actually, I think I did. Try this one, of course it may not look the same thinking about it: (may need a group by clause)
SELECT
November 21, 2017 at 1:01 pm
Oh, it wasn't really from reading the plan that I came up with the rewrite, I simply "looked with eye" at the code and made what I thought were logical...
November 21, 2017 at 12:31 pm
For S & G's could you post the new execution plan?
Never mind, you did.
November 21, 2017 at 12:26 pm
Not sure if this will work (return the same result set) as your current query, but it is a shot at a rewrite with nothing to test against. Be sure...
November 21, 2017 at 12:02 pm
November 21, 2017 at 10:43 am
I need help with a query to remove a record from a data set....
November 21, 2017 at 10:35 am
November 21, 2017 at 9:48 am
Also, I would look at a rewrite of the existing query. It looks like a year to date reporting query and there is a better way to do that little...
November 21, 2017 at 9:21 am
November 21, 2017 at 9:15 am
Viewing 15 posts - 2,371 through 2,385 (of 26,488 total)