I need and one ore more SQL query to clean some data in the following way:
1. If the BBSctr field is empty insert the most frequently used BBSctr corresponding to the SpnsrSctr of that record by that Spnsr. Note that different Spnsr may have different "most frequent" BBSctr associations.
2. When there is neither a SpnsrSctr or BBSctr search for any BBSctr association of CnsTckr and assign the most frequent there.
You may not use temporary tables but you can create explicit mapping tables. Execution speed is important but not my primary concern at this time.
Sample data is provided attached.
Budget --- $ 60
21 pekerja bebas membida secara purata $74 untuk pekerjaan ini
I already have the query . you can have a look if works for you fine else you always have option to hire anybody. looking forward to your chat. thank you. best regards, Muhammad