If you are simply wanting counts of loans within the various criteria, try this:

-- produces counts by criteria

select sum(case when amount 15000 and terms 15000 and terms between...

Just whenever you get a chance. Thanks, prodigy.

The great thing about this is we all get a deeper understanding of what's going on under the hood. That's...

I'm also curious to know if it does 9 scans on the nonclustered index. Can you post those stats up too?

Is EntityCollection a partitioned table by any chance?

Prodigy, what else is going on in your proc? I see a simple Select Count statement but you post that it's taking 9 scans of the table...

(message found inside a magnetic bottle drifting between the stars)

Barry: Consider yourself fortunate. - bh

(appears briefly due to a temporal anomaly)

Snoop with a banjo??

The tune is original, like the lyrics. I'm making this up as I go along. 😉

(suddenly sucked back...

(warps in)

You know I love the ladies: silver, gold, blue or green,

Hot pink, fluorescent purple, and some shades in between.

I charm them and disarm them, if you know what...

Nawar, although your function may get the desired result, using a while loop is going to run much slower than a set based solution. If you will...

I'm inspired!! Imagine a banjo....

Ohhhhhhhhhhhh

I call up Engineering... holler "Gimme warp three"

I got a half a billion Klingons all as pissed as they can be

And the pointy-eared alien...

Gail, to quote Heisenberg: "It might." 😛

With MY name on it ??? :w00t:

No rules?! Then why are you fingering your red card in a threatening manner, Lynn? 😛

Maxims of a Klingon Code Warrior:

10.Specifications are for the weak and timid!

9.You question the worthiness of my code? I should kill you where you stand!

8.Indentation?! - I will...

Q: What's a Red Shirt's favorite color?

A: We don't know... they keep dying off before we can ask them.