Advertisement
egyware

Untitled

Sep 29th, 2016
108
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
T-SQL 1.15 KB | None | 0 0
  1. SELECT T.Mb_Epr_cod, @local as Mb_sedecod, 1 as gc_lis_pre, @ano as gc_lp_ano, @mes as gc_lp_mes, 'P' as gc_lp_tip, T.Art_cod, @cant as gc_lis_can, T.Art_cod_la, A.Ve_lis_pes, 0 as gc_lis_cos, 0 as gc_lis_mar, ROUND(A.Ve_lis_pes*(1-@descuento),-1)as descuento, '1753-01-01' as c1, ' ' as c2, ' ' as c3, '1753-01-01' as c4, ' 'as c5, 0 as c6, 0 as c7, 1 as c8, ' ' as c9, ve_incenti,0,0,'1753-01-01','1753-01-01','1753-01-01','1753-01-01','1753-01-01','1753-01-01','1753-01-01',0,0,0,0,0,0,' ', ' ', 0,' ','1753-01-01',' ', 0, 0, ' '
  2.         FROM super_gc.T0018 AS T
  3.         INNER JOIN super_gc.GCPRCART AS A ON (T.Mb_Epr_cod = A.Mb_Epr_cod and T.Art_cod = A.Art_cod and Ve_lista_p = 1 and ve_lis_des = 1)
  4.         WHERE T.Mb_Epr_cod = 'ARI' and gc_fam_cod <= 4 and T.Art_cod IN ('153-0126','153-0127','090-0058','090-0654','090-0927','141-0114','141-0108','136-7143','090-1190','153-0401','153-0227','204-0395','090-0441','090-0958','136-8206','090-0423','153-0468','014-0236','014-0235','144-0098','144-0116','144-0115','144-0074','158-0145','158-0124','158-0145','090-1450','090-1448','200-3837','200-3838','200-3839','090-1018','090-0533','090-1320','090-0543','090-1024','204-0209','090-1190')
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement