daily pastebin goal
66%
SHARE
TWEET

Untitled

a guest Feb 14th, 2018 57 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. if (datediff(day,((select top 1 fec_ven from
  2. cxc_cuedoc inner join cxc_cuedoc cue
  3. on cli.cod_cli = cue.cod_cli  where sal_doc !=0 and num_doc=cue.num_doc)),getdate())) > 110 and cue.tip_doc = '010'
  4. begin
  5.  update cxc_cliente
  6.  set ind_mora ='2'
  7. set IND_JURIDICO = '2'
  8. end
  9. else
  10. begin
  11. set ind_mora ='1'
  12. set ind_juridico ='1'
  13. end
  14.    
  15. update cxc_cliente
  16.     set ind_mora = '2',
  17.         IND_JURIDICO = '2';
RAW Paste Data
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy. OK, I Understand
 
Top