Viewing 3 posts - 1 through 3 (of 3 total)
Jeff Moden (7/29/2015)
What's the execution plan without the IF statement look like?
Here:
|--Compute Scalar(DEFINE: ([Expr1008]=CONVERT_IMPLICIT(int,[Expr1013],0)))
|--Stream Aggregate(DEFINE: ([Expr1013]=Count(*)))
...
July 30, 2015 at 2:36 am
I think i was misunderstood. I made a mistake in the original post by copying the wrong query into it. The current post (after my edit) is the actual issue....
July 29, 2015 at 8:41 am
Thanks for noticing. That was actually an error on my part. I copied into the post an older version of the query from when I was troubleshooting. Edited and corrected.
July 29, 2015 at 7:20 am
Viewing 3 posts - 1 through 3 (of 3 total)