ossiejhmoore

Untitled

Jun 14th, 2019
382
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.48 KB | None | 0 0
  1. select concat('config.source.', cast(buf.dataid as varchar(50)), ' = H:\Production\Southern Region\Well Files\Anadarko Woodford\SCOOP\',well.name) path
  2. concat('config.dest.', cast(buf.dataid as varchar(50)), ' = ', cast(buf.dataid as varchar(50))
  3. from dtree st
  4. join dtree cty on st.dataid = cty.parentid
  5. join dtree well on cty.dataid = well.parentid
  6. join drree buf on wll.dataid = buf.parentid
  7. where st.name = 'Oklahoma' and buf.name = 'Completions & Production'
Advertisement
Add Comment
Please, Sign In to add comment