Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
SQL to update a column using another column
I need the logic/ansi sql to update a column, LP_Qty in my table using another col in the same table this is RF_Qty. RF_Qty gets updated everyday as the table refreshes everyday. But LP_Qty should be equal to RF_Qty only when it is FisPeriodEnd_Dt, else it should retain it's previous value till...
