Your code is using an implicit equijoin and a cartesianjoin. WHERE RF.REPAIR_ORD = RH.REPAIR_ORD and Rp.REPAIR_ORD = cg.REPAIR_ORD For simplicity, let me assume the actual table names are RF, RH, RP and CG. RH and RH are joined and RP and CG are joined but RF is not joined to RP or CG; and also RH is not joined to RP and CG. So the end result is a cartesian product of two equijoins (RF-RH X RP-CG). I would suggest using an explicit join. From your code, I assume that REPAIR_ORD is common to all the tables. So my code would look like SELECT ..... FROM RF INNER JOIN RH ON RF.REPAIR_ORD=RH.REPAIR_ORD INNER JOIN RP ON RH.REPAIR_ORD=RP.REPAIR_ORD INNER JOIN CG ON RP.REPAIR_ORD=CG.REPAIRD_ORD WHERE .... I am using inner joins but depending on what you need, you may find left joins or right joins more suitable.

No problem :) I Love T-SQL "Don't torture yourself,let the life to do it for you." If my post helps you kindly save my time by voting my post. www.cacttus.com

SELECT current_date FROM dual; or SELECT SYSDATE FROM dual;

Give this a try this should fix your problem; return (int)Refurb_Rate;

More clarity about how the "change" happens in the figures would be helpful. For example: 1. Are you tring to update the figures whenever a new item is scanned?, If so you need to catch the scanning event (typically this would be an OnKeyDown or OnTextChanged event in a TextBox somewhere? 2. Are there lots of different places where the figures may change (e.g. the are lots of different people scanning in refurbs in different places) and you want to constantly check the database. If so a solution where you check the database at regular intervals might be better (e.g. use a Timer control and put the code in there). Without knowing exactly what you are trying to achieve and the thought process behind it, it's difficult to work out the best solution.