Advertisement
Guest User

Untitled

a guest
Jun 23rd, 2017
54
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
T-SQL 0.31 KB | None | 0 0
  1. SELECT mpcp.nlenr, dl16.last_edit_by, mpcp.mes_create_date, dl16.wo_id
  2. FROM data_log_16  dl16 WITH (NOLOCK)
  3.     INNER JOIN mes_prod_conf_pubr mpcp WITH (NOLOCK) ON mpcp.pro_ord = dl16.wo_id AND mpcp.NLENR = (dl16.value10 + dl16.value11)
  4. WHERE mpcp.nlenr LIKE '35000144125%' AND mpcp.mes_create_date > (GETDATE() - 1)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement