How to split the single row into two

Hi All,

There is a requirement for me to split a record from Source into two rows and insert into destination as mentioned below. Kindly let me know, which will be the best approach to handle this.

Source:

Location Tool Number Date Run Hours REC_ID MCHN_NO
605 5047836/5047837 9/10/15 1:37 0.2 14013 945

Destination:

Location Tool Number Date Run Hours REC_ID MCHN_NO
605 5047836 9/10/15 1:37 0.2 14013 945
605 5047837 9/10/15 1:37 0.2 14013 945

September 10th, 2015 3:35am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics