Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <asp:GridView ID="GridView3" DataSourceID="test" runat="server" AutoGenerateColumns="False">
- <Columns>
- <asp:BoundField DataField="deuda"
- HeaderText="deuda" ReadOnly="True"
- SortExpression="deuda" DataFormatString="{0:#,##0}" HtmlEncode="False" />
- </Columns>
- </asp:GridView>
- set @lvl = 0;
- set @saldo = 0;
- WHILE @saldo < (SELECT (80 * (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)) / 100)
- FROM kdue a1
- LEFT JOIN KDMM ON KDMM.C1 = 'U' AND A1.C3 = KDMM.C2 AND A1.C4 = KDMM.C3 AND A1.C5 = KDMM.C4
- LEFT JOIN KDMS ON A1.C1 = KDMS.C1
- LEFT JOIN KDUD ON A1.C2 = KDUD.C2
- LEFT JOIN KDUV ON A1.C18 = KDUV.C2
- WHERE a1.c1 = '02-01')
- BEGIN SET
- @saldo = @saldo +
- (SELECT
- 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
- FROM KDUE A1
- LEFT JOIN KDMM ON KDMM.C1 = 'U' AND A1.C3 = KDMM.C2 AND A1.C4 = KDMM.C3 AND A1.C5 = KDMM.C4
- LEFT JOIN KDMS ON A1.C1 = KDMS.C1
- LEFT JOIN KDUD ON A1.C2 = KDUD.C2
- LEFT JOIN KDUV ON A1.C18 = KDUV.C2
- WHERE a1.c1 = '02-01' GROUP BY kdud.c3 ORDER BY x DESC OFFSET @lvl ROWS FETCH NEXT 1 ROWS ONLY);
- SET @lvl = @lvl + 1 END
- select replace(cliente,' ','')as cliente,replace(convert(varchar,round(p,0)),'.000000000','')as deuda from
- (
- SELECT TOP (@lvl) kdud.c3 as cliente,
- (sum(CASE WHEN a1.c11 <> 0 THEN ((a1.C17 / a1.C11) * a1.C20) END)) AS p
- FROM KDUE A1
- LEFT JOIN KDMM ON KDMM.C1 = 'U' AND A1.C3 = KDMM.C2 AND A1.C4 = KDMM.C3 AND A1.C5 = KDMM.C4
- LEFT JOIN KDMS ON A1.C1 = KDMS.C1 LEFT JOIN KDUD ON A1.C2 = KDUD.C2
- LEFT JOIN KDUV ON A1.C18 = KDUV.C2
- WHERE a1.c1 = '02-01' AND DATEADD(DAY, CONVERT(FLOAT(10), KDUD.C16), A1.C7) < DATEADD(day, - 90, GETDATE())
- GROUP BY kdud.c3 ORDER BY p DESC)as x
- <asp:SqlDataSource ID="test" runat="server" ConnectionString="<%$ ConnectionStrings:ServIndustrialConnectionString2 %>" SelectCommand="my query">
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement