update EMPMILL12.tbl_payslip_print_component set payslip_order=1,payslip_print=1,total_print=0 where payscheme_id<>152 and desc_print='Emp Code'update EMPMILL12.tbl_payslip_print_component set payslip_order=2,payslip_print=1,total_print=0 where payscheme_id<>152 and desc_print='Name'update EMPMILL12.tbl_payslip_print_component set payslip_order=3,payslip_print=0,total_print=0 where payscheme_id<>152 and desc_print='Department'update EMPMILL12.tbl_payslip_print_component set payslip_order=4,payslip_print=0,total_print=0 where payscheme_id<>152 and desc_print='Designation'update EMPMILL12.tbl_payslip_print_component set payslip_order=5,payslip_print=0,total_print=0 where payscheme_id<>152 and desc_print='Uan no'update EMPMILL12.tbl_payslip_print_component set payslip_order=6,payslip_print=0,total_print=0 where payscheme_id<>152 and desc_print='Esi No'update EMPMILL12.tbl_payslip_print_component set payslip_order=19,payslip_print=1,total_print=1 where payscheme_id<>152 and component_id=54update EMPMILL12.tbl_payslip_print_component set payslip_order=7,payslip_print=0,total_print=0 where payscheme_id<>152 and component_id=166update EMPMILL12.tbl_payslip_print_component set payslip_order=22,payslip_print=1,total_print=1 where payscheme_id<>152 and component_id=165update EMPMILL12.tbl_payslip_print_component set payslip_order=10,payslip_print=1,total_print=1 where payscheme_id<>152 and component_id=7update EMPMILL12.tbl_payslip_print_component set payslip_order=7,payslip_print=0,total_print=0 where payscheme_id<>152 and component_id=115update EMPMILL12.tbl_payslip_print_component set payslip_order=7,payslip_print=0,total_print=0 where payscheme_id<>152 and component_id=119update EMPMILL12.tbl_payslip_print_component set payslip_order=7,payslip_print=0,total_print=0 where payscheme_id<>152 and component_id=65update EMPMILL12.tbl_payslip_print_component set payslip_order=12,payslip_print=1,total_print=1 where payscheme_id<>152 and component_id=72update EMPMILL12.tbl_payslip_print_component set payslip_order=14,payslip_print=1,total_print=1 where payscheme_id<>152 and component_id=73update EMPMILL12.tbl_payslip_print_component set payslip_order=7,payslip_print=0,total_print=0 where payscheme_id<>152 and component_id=23update EMPMILL12.tbl_payslip_print_component set payslip_order=7,payslip_print=0,total_print=0 where payscheme_id<>152 and component_id=22update EMPMILL12.tbl_payslip_print_component set payslip_order=7,payslip_print=0,total_print=0 where payscheme_id<>152 and component_id=64update EMPMILL12.tbl_payslip_print_component set payslip_order=7,payslip_print=0,total_print=0 where payscheme_id<>152 and component_id=63update EMPMILL12.tbl_payslip_print_component set payslip_order=15,payslip_print=1,total_print=1 where payscheme_id<>152 and component_id=77update EMPMILL12.tbl_payslip_print_component set payslip_order=7,payslip_print=0,total_print=0 where payscheme_id<>152 and component_id=18update EMPMILL12.tbl_payslip_print_component set payslip_order=7,payslip_print=0,total_print=0 where payscheme_id<>152 and component_id=19update EMPMILL12.tbl_payslip_print_component set payslip_order=7,payslip_print=0,total_print=0 where payscheme_id<>152 and component_id=126update EMPMILL12.tbl_payslip_print_component set payslip_order=13,payslip_print=1,total_print=1 where payscheme_id<>152 and component_id=74update EMPMILL12.tbl_payslip_print_component set payslip_order=20,payslip_print=1,total_print=1 where payscheme_id<>152 and component_id=25update EMPMILL12.tbl_payslip_print_component set payslip_order=7,payslip_print=0,total_print=0 where payscheme_id<>152 and component_id=20update EMPMILL12.tbl_payslip_print_component set payslip_order=17,payslip_print=1,total_print=1 where payscheme_id<>152 and component_id=66update EMPMILL12.tbl_payslip_print_component set payslip_order=11,payslip_print=1,total_print=1 where payscheme_id<>152 and component_id=8update EMPMILL12.tbl_payslip_print_component set payslip_order=7,payslip_print=0,total_print=0 where payscheme_id<>152 and component_id=118update EMPMILL12.tbl_payslip_print_component set payslip_order=7,payslip_print=0,total_print=0 where payscheme_id<>152 and component_id=120update EMPMILL12.tbl_payslip_print_component set payslip_order=7,payslip_print=0,total_print=0 where payscheme_id<>152 and component_id=90update EMPMILL12.tbl_payslip_print_component set payslip_order=7,payslip_print=0,total_print=0 where payscheme_id<>152 and component_id=24update EMPMILL12.tbl_payslip_print_component set payslip_order=23,payslip_print=1,total_print=1 where payscheme_id<>152 and component_id=21update EMPMILL12.tbl_payslip_print_component set payslip_order=9,payslip_print=1,total_print=1 where payscheme_id<>152 and component_id=51update EMPMILL12.tbl_payslip_print_component set payslip_order=21,payslip_print=1,total_print=1 where payscheme_id<>152 and component_id=62update EMPMILL12.tbl_payslip_print_component set payslip_order=16,payslip_print=1,total_print=1 where payscheme_id<>152 and component_id=9update EMPMILL12.tbl_payslip_print_component set payslip_order=8,payslip_print=1,total_print=1 where payscheme_id<>152 and component_id=6update EMPMILL12.tbl_payslip_print_component set payslip_order=7,payslip_print=0,total_print=0 where payscheme_id<>152 and component_id=154update EMPMILL12.tbl_payslip_print_component set payslip_order=7,payslip_print=0,total_print=0 where payscheme_id<>152 and component_id=125update EMPMILL12.tbl_payslip_print_component set payslip_order=19,payslip_print=1,total_print=1 where payscheme_id<>152 and component_id=16update EMPMILL12.tbl_payslip_print_component set payslip_order=7,payslip_print=0,total_print=0 where payscheme_id<>152 and component_id=121update EMPMILL12.tbl_payslip_print_component set payslip_order=7,payslip_print=0,total_print=0 where payscheme_id<>152 and component_id=26update EMPMILL12.tbl_payslip_print_component set payslip_order=7,payslip_print=0,total_print=0 where payscheme_id<>152 and component_id=55update EMPMILL12.tbl_payslip_print_component set payslip_order=7,payslip_print=0,total_print=0 where payscheme_id<>152 and component_id=27