Advertisement
Guest User

Untitled

a guest
Dec 17th, 2014
150
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.06 KB | None | 0 0
  1. select 1 ,'0782300202'+
  2. cast(year(getdate()) as varchar)+
  3. right(100+month(getdate()),2)+
  4. right(100+day(getdate()+1),2)+
  5. 'SERVIPAG'+
  6. right(cast((COUNT(saldo)+1000000000) as varchar),6) +
  7. right(cast((sum(montoTotal)+1000000000000000) As numeric),14)+ ' ' as col1
  8. from
  9. (
  10. select saldo,
  11. case -- monto: SUMA EL SALDO MAS LOS INTERESES Y SI LA DIF EN DIAS ES > 30 TAMBIEN LO SUMA
  12. when DATEDIFF(day,fecha_vencimiento,getdate())<= 0 then
  13. saldo
  14. when DATEDIFF(day,fecha_vencimiento,getdate())>30 then
  15. saldo+round(((saldo*5)/100),0)+
  16. (round((((saldo*1.2)/100)/30)*DATEDIFF(day,fecha_vencimiento,getdate()),0))
  17. else -- SUMA EL SALDO MAS LOS INTERESES (no contempla g.cobrazas)
  18. saldo+(round((((saldo*1.2)/100)/30)*DATEDIFF(day,fecha_vencimiento,getdate()),0))
  19.  
  20. end
  21. as montoTotal
  22. from servipag)
  23. x
  24. -- + ' ' from servipag INTO OUTFILE '\\\\10.12.12.70\Publico\media\temp\archivosExportados\\data.txt' LINES TERMINATED BY '\n'
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement