Thank you for your response.  To clarify, I have a stored procedure that used to pass in a multi-value parameter, so the proc was running over and over for each...

The problem I identified was actually found in legacy code.  I have always used decimal, rather than float.  Therefore, my knowledge of float is fairly limited.  I just thought it...

Thank you Ken.  This is exactly what I was trying to confirm - Microsoft changing the functionality of float.

I'm not sure how server specs would translate to different behavior in the query engine.  I did actually verify that the problem is version- specific.  And a calculation with a...

I’m not following.   The table structures and data content aren’t relevant here.  I’m simply asking how the scenario I provided is expected to behave in SSRS in terms of...

If I use a parameter, then the proc will run for each value.  I am looking to run it once in full and filter on the dataset produced.

Mostly integers and strings.  The procedure returns about a hundred records and filtered, only 6.

Did you find that the DBA questions were fairly involved or suitable for someone with limited DBA experience? I am going by what is included per the MS site,...