I have two columns in source table and need to insert two records in a single column in target table.
For example -
Source.ColA > 0 then insert 'XYZ' in target column
Source.ColB >0 then insert 'ABC' in target column
If both Source. Col A and Source.Col B >0 then insert 'XYZ' as one record and 'ABC' as other record.
How could i do that?
Appreciate your help.