Here is what I came up with:

CREATE FUNCTION dbo.fn_BRound (

    @TestValue decimal(38,12),

    @pos int

)

RETURNS money

as begin

    return round(@TestValue, @pos, case when (nullif(round(@TestValue * power(cast(10 as decimal(38,12)), @pos),0,1),round((@TestValue * power(cast(10 as...

Without digging into myself at the moment, I'd say the problem is using float.  This is an imprecise numeric representation.  Try changing the floats to a large decimal, and see...

Why are you using the view v_div_all in v_rpt?  The only field you are using from that view is v_div_All.Div_Dep and this is the same as div.dion from the table...

Steve, what about PeopleSoft?  Their documentation says their app needs SA privs to the database.

To help we will need more information.  If you could post the code for your query and the DDL for the table(s)/view(s) used and perhaps some sample data would go...

Sounds like you are adding requirments to your original request.  Can you provide more details as to what you are asking?  It also sounds like you need to expand you...

How about we form a company so we all can benefit.

 I think you need to post what you have, the DDL for the tables, some sample data, and what the results of the query should return.  with that, there are...

Took a minute, but that little change makes sense.  Something I can add to my little tool box.

Thanks Sergiy!

Notice it is always the shortimers who seem to jump right in and help?

For about 20 weeks out of the year (10 weeks in fall and 10 weeks in spring) I get out of the office and do something totally different, I am...

I am assuming (bad habit) that the data in this case is numeric.  This actually sounds like a good use for using CLR integration and write some procedures/functions in VB.NET...

Had this problem with maintenance plans at my previous employer.  We had to delete and recreate the maintenance plans to get it to work properly.  If we had to make...

Unfortunately, we also had other issues to deal with as a result of the upgrade from SQL Server 2000 to SQL Server 2005 besides this particular query running slower on...

From what I can tell, the mirrored backups isn't supposed to protect from a failure during the backup, but from the media failing after the backup is completed.  I am...