I'm confused by your expected results.

You said you want to get the "latest status as of April 1, 2012." And state that you would expect ConsumerID 101 to be...

Thanks for that. Sounds like a good term for it to me.

Just realized the inner case statement was over complicated and I had a WHEN that could never be satisfied..

revised:

CREATE FUNCTION dbo.itvf_BankersRound(@Num decimal(38,9))

RETURNS TABLE

AS

RETURN

(

SELECT

CASE

WHEN

ROUND(@Num, 2) - @Num = .005

AND...

Here's what I came up with. Granted I made a pretty sweeping assumption (always rounding to hundredths), but that was the business case I was working with. It...

Thanks LutzM, I'll have to check out the quirky update.

I did come up with a solution that seems to work also (Props to LutzM for the idea of counting the...

Sure...