Fixit SQL Scripts

How to Zero out all 12 months in assumptions details
update assumptions set P01=0, P02=0, P03=0, P04=0, P05=0, P06=0, P07=0, P08=0, P09=0, P10=0, P11=0, P12=0 where budgetid='2016 Budget&#...
Wed, 27 Jan, 2016 at 12:30 AM
Converting From Negative to Positive Revenue Format
When converting from a Negative to Positive Revenue Format on Manage Company Databases and you have several years of data where revenues were recorded ...
Thu, 23 Jun, 2016 at 3:35 PM
update PayrollExp joining on EmpRoster
update payrollexp set Field1='FICA', Field2='Medicare', Field3='FUTA', Field8=substring(b.DivisionCode,8,2), Field4=b.Meta3, ...
Thu, 23 Aug, 2018 at 9:10 PM