Advertisement
Guest User

Untitled

a guest
Jul 31st, 2015
224
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 2.12 KB | None | 0 0
  1. <asp:GridView ID="GridView3" DataSourceID="test" runat="server" AutoGenerateColumns="False">
  2. <Columns>
  3. <asp:BoundField DataField="deuda"
  4. HeaderText="deuda" ReadOnly="True"
  5. SortExpression="deuda" DataFormatString="{0:#,##0}" HtmlEncode="False" />
  6. </Columns>
  7. </asp:GridView>
  8.  
  9. set @lvl = 0;
  10. set @saldo = 0;
  11. WHILE @saldo < (SELECT (80 * (sum(CASE WHEN a1.c11 <> 0 AND DATEADD(DAY, CONVERT(FLOAT(10), KDUD.C16), A1.C7) < DATEADD(day, - 90, GETDATE())
  12. THEN ((a1.C17 / a1.C11) * a1.C20) END)) / 100)
  13. FROM kdue a1
  14. LEFT JOIN KDMM ON KDMM.C1 = 'U' AND A1.C3 = KDMM.C2 AND A1.C4 = KDMM.C3 AND A1.C5 = KDMM.C4
  15. LEFT JOIN KDMS ON A1.C1 = KDMS.C1
  16. LEFT JOIN KDUD ON A1.C2 = KDUD.C2
  17. LEFT JOIN KDUV ON A1.C18 = KDUV.C2
  18. WHERE a1.c1 = '02-01')
  19. BEGIN SET
  20. @saldo = @saldo +
  21. (SELECT
  22. sum(CASE WHEN a1.c11 <> 0 AND DATEADD(DAY, CONVERT(FLOAT(10), KDUD.C16), A1.C7) < DATEADD(day, - 90, GETDATE()) THEN ((a1.C17 / a1.C11) * a1.C20) END) AS x
  23. FROM KDUE A1
  24. LEFT JOIN KDMM ON KDMM.C1 = 'U' AND A1.C3 = KDMM.C2 AND A1.C4 = KDMM.C3 AND A1.C5 = KDMM.C4
  25. LEFT JOIN KDMS ON A1.C1 = KDMS.C1
  26. LEFT JOIN KDUD ON A1.C2 = KDUD.C2
  27. LEFT JOIN KDUV ON A1.C18 = KDUV.C2
  28. WHERE a1.c1 = '02-01' GROUP BY kdud.c3 ORDER BY x DESC OFFSET @lvl ROWS FETCH NEXT 1 ROWS ONLY);
  29. SET @lvl = @lvl + 1 END
  30. select replace(cliente,' ','')as cliente,replace(convert(varchar,round(p,0)),'.000000000','')as deuda from
  31. (
  32. SELECT TOP (@lvl) kdud.c3 as cliente,
  33. (sum(CASE WHEN a1.c11 <> 0 THEN ((a1.C17 / a1.C11) * a1.C20) END)) AS p
  34. FROM KDUE A1
  35. LEFT JOIN KDMM ON KDMM.C1 = 'U' AND A1.C3 = KDMM.C2 AND A1.C4 = KDMM.C3 AND A1.C5 = KDMM.C4
  36. LEFT JOIN KDMS ON A1.C1 = KDMS.C1 LEFT JOIN KDUD ON A1.C2 = KDUD.C2
  37. LEFT JOIN KDUV ON A1.C18 = KDUV.C2
  38. WHERE a1.c1 = '02-01' AND DATEADD(DAY, CONVERT(FLOAT(10), KDUD.C16), A1.C7) < DATEADD(day, - 90, GETDATE())
  39. GROUP BY kdud.c3 ORDER BY p DESC)as x
  40.  
  41. <asp:SqlDataSource ID="test" runat="server" ConnectionString="<%$ ConnectionStrings:ServIndustrialConnectionString2 %>" SelectCommand="my query">
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement