select concat('config.source.', cast(buf.dataid as varchar(50)), ' = H:\Production\Southern Region\Well Files\Anadarko Woodford\SCOOP\',well.name) path concat('config.dest.', cast(buf.dataid as varchar(50)), ' = ', cast(buf.dataid as varchar(50)) from dtree st join dtree cty on st.dataid = cty.parentid join dtree well on cty.dataid = well.parentid join drree buf on wll.dataid = buf.parentid where st.name = 'Oklahoma' and buf.name = 'Completions & Production'