Pasted

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'