Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- select 1 ,'0782300202'+
- cast(year(getdate()) as varchar)+
- right(100+month(getdate()),2)+
- right(100+day(getdate()+1),2)+
- 'SERVIPAG'+
- right(cast((COUNT(saldo)+1000000000) as varchar),6) +
- right(cast((sum(montoTotal)+1000000000000000) As numeric),14)+ ' ' as col1
- from
- (
- select saldo,
- case -- monto: SUMA EL SALDO MAS LOS INTERESES Y SI LA DIF EN DIAS ES > 30 TAMBIEN LO SUMA
- when DATEDIFF(day,fecha_vencimiento,getdate())<= 0 then
- saldo
- when DATEDIFF(day,fecha_vencimiento,getdate())>30 then
- saldo+round(((saldo*5)/100),0)+
- (round((((saldo*1.2)/100)/30)*DATEDIFF(day,fecha_vencimiento,getdate()),0))
- else -- SUMA EL SALDO MAS LOS INTERESES (no contempla g.cobrazas)
- saldo+(round((((saldo*1.2)/100)/30)*DATEDIFF(day,fecha_vencimiento,getdate()),0))
- end
- as montoTotal
- from servipag)
- x
- -- + ' ' 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