--update srra82223..vouchertrans set StaffCode1=b.StaffCode from srra82223..vouchertrans a,srra8main..giftvoucher b where a.voucherid=b.voucherid and a.vouchercode=b.couponcode
--alter table srra82223..vouchertrans add StaffCode1 Decimal(20,5)
select entrypoint,voucherid,de,StaffCode,CusCode,StaffCode1,* from srra82223..vouchertrans where isnull(StaffCode,0)<>isnull(staffcode1,0)