SQL Pivot Table Kullanımı_Logo Veritabanı Örnekli

Blog Detay

SQL Pivot Table Kullanımı_Logo Veritabanı Örnekli
SQL Pivot Table Kullanımı_Logo Veritabanı Örnekli

SQL Pivot Table Kullanımı_Logo Veritabanı Örnekli

<h2><span style="color:#000000"><strong>SQL Pivot Table Nedir ?&nbsp;</strong></span></h2> <p><span style="color:#000000">Genelde excel den bildiğimiz toplam ağırlıklı verileri düzenli haliyle görebildiğimiz bir yapıdır. Görsele bakınca net anlaşılacağını düşünüyorum,Satırlara ait ( genelde ) kolonlarda toplam verilerine ulaşmak amacıyla kullanırız.</span></p> <h3><span style="color:#000000"><strong>SQL Dışında kullanımı Var mıdır ?&nbsp;</strong></span></h3> <p><span style="color:#000000">Normalde sql den yazacağınız satır bazlı verileri excelde pivot table haline de getirebilirsiniz. Excelinde sunduğu imkanlardan da yararlanabilirsiniz. Ben genelde SQL Pivot table yerine Excel Pivot table kullanıyorum .&nbsp;</span></p> <h2><span style="color:#000000"><strong>Örnek Kullanım ;&nbsp;</strong></span></h2> <blockquote> <p><span style="color:#000000">&nbsp;&nbsp; &nbsp;<br /> &nbsp;&nbsp; &nbsp;--SQL Pivot Table Kullanımı<br /> &nbsp;&nbsp; &nbsp;Select *<br /> &nbsp;&nbsp; &nbsp;From(<br /> &nbsp;&nbsp; &nbsp;Select<br /> &nbsp;&nbsp; &nbsp;ISNULL(sum((STL.AMOUNT)),0) Fiilis,IT.CODE Kodus,MONTH(STL.DATE_)Ay<br /> &nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;FROM LG_003_03_STLINE STL&nbsp;<br /> &nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;JOIN LG_003_ITEMS IT ON IT.LOGICALREF=STL.STOCKREF<br /> &nbsp;&nbsp; &nbsp;WHERE LINETYPE=0 AND STL.TRCODE=8<br /> &nbsp;&nbsp; &nbsp;GROUP BY &nbsp;IT.CODE,MONTH(STL.DATE_)<br /> &nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;)ToplamTablo<br /> &nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;Pivot<br /> &nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;(<br /> &nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;Sum(Fiilis)<br /> &nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;For Ay<br /> &nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;In([1],[2],[3],[4])<br /> &nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;)<br /> AS PivotTable</span></p> </blockquote> <p><span style="color:#000000"><span style="font-size:11pt"><span style="font-family:Calibri,sans-serif"><img src="data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAAXYAAAFnCAIAAAA9tvUMAAAAAXNSR0IArs4c6QAAP1BJREFUeF7tfQ18HFW99kn5VBDEQvV6vUpoNtAkypWmvpjwUuCWjySApXKj7VWitCaUKyQWgoKBvoXIK5TWFJS6kXItYiu5tRRoEz4qUi7J9bUpUElSyAZSRbhaWqB89QvI+z/nzMzO7uzuzJyd2Z3NPOe3v83s7Pn4n+ecffI//5nzTNGTA3uYJd189UXX3Xa/9bxxpv2aOW+M/QN9fOfN1478+HHy/GOrb85QJOVXRx99NJ3v3t3d81aPkaHmqJrao2ut+VetWjVnzhy3TSA/EAACeURgQsq2M/OLuYjBL9n0ofawA3cc+Z7xoo/Z1IayQAAIBAeBopqamrGxMatBRUVF1y5em85Q8mJefuNgg1+kL6PsxbC9D7A9D8bb+siF7PCvwIsJziyBJUBAGYEJxC/ks1hfKXknnf/iiS+j3AcUBAJAILAIaAslCr4YJpqPbe0m/8U2T0Fm2PHEtEWL5g3m3vbBeYvWdFua7V6zqGgRf+XDpNyDgBbHDwKpYzHO+xcI/6WbFRWxaUtNVsfYtCJ+kr/mZegN/Z61n66nv94dS5cncEHsieWSIIzXtCd2OAeZctZevHBs4fwlk1wVQmYgkH8EEihG2X/Jry/TvZYt2cDYahaTeBK/lLLZw4xCTPx1V2aUyzcspF/vwrH507euWb7U+OFPOmPzwoV3lXszQpEz5vMmFl48l2nNbT4DbOENtqgl4AjEKUbyi3OWMfsv+fVl1m5lF9Sy2Yw9pHGMEuaTymZP2jEkln3WVQl3Q5Y/YVRPGTQ3RKynzEsY4bAsv2oHW6EtbUy0lX75k+xDDa6Rddo4O5bWlXqOQkDARwTiFHP6uV+noC+9u2otv/6L4AO2dTaLMHbBbLb6IWF7hK1awq4qZUXTdL/GSZcGn7xqx6QycYuPdVUSOeP0uTu2PaT5OINrB8sXkRtCv/Dl22bPT3CChMPCVzRz+dKGr24WpPdXRENGcSMEM1i3bYp0rNim38Ydq+ReDM5bvnORLL7wYmZ2wZz0F3mAQE4Q0CiGyOW0s79GLdK785tiKH9+/RcyYOlCdvJJglguiK+VIgv4Eml4NiulWIwN0QzWSTdkzWtL5megg/JZ5TtWD3GOiT3x5IryKXRrYGxoW3/56RqDTDpjUbnmBLkYON1bKVq+qT9erHzDxWKFZnKsUtS547WtTDd+0ZoVLlpFViCQOwQm0P0vtDiyvuh8ZivM/kvefJkYW93PVtSJsG4p6+9PWCtJopnbz26xXqEx/541RyCTu8Fdm9Ons21DMbbjoW1syemeBGkG53Fe07yYSreD/trO/knThzXjbdwlt3UjPxDwCoEJdH9dyvtiMtx3J9sOQiwm9hDrn6uHdcltWaKvlQx4YmwrY2W0jso+kU/Btj00OLSaTblArH0iZVMqB5/UFjI7nlg4qK2zyP046Ti29TW7a0bcDdFS95NmL0Y/y9du5D2lMb18ytwdm27Jw2X17KFEDSFCINuL1nnzX8QYPbSazZ0VH63ISaz/KtYtrmFrr1J28ga2wB3F8EvO5pCtfivKpAWnH3fVmk0nn36GVh9ddbr4uKt45kVFPCgT94O4y7NJXqhOH+4VaytZfOGx0+fG+2Feu10sNmulNKn8Ln4VTL8QbopGh2j+oquBR6Ao5TZIW7Nv/9EVf37z0KRs2EBgixsyAIGwIaDuxQQiFhO24UJ/gUChIaBOMUGIxRQa2rAXCIQOAXWKkVDlNxYTuuFCh4FAoSGQLcXk/b6YQgMc9nIEbG+JAEzjBgF1ikEsZtxMAnQECPiHgDrFIBbj36igZiAwbhBQp5ggx2LmFdHWpdwkeceKAyWX+F6B+HbK3JiY0MqOJ5YvWpPxfr1C61EeQESTLhDIlmIQi6F7eeUmAJPyg/YrTZCPKr9Y7my03ygQWzqNYhU8TVuazd5xF9MgKaulR/Et3aY7CQupR+pYoGSWCKhTDGIxaaAnmavfsq86ko8il2J5sjZV97zSq07eQLqmY2PDs1eXzsuVO5ZhIu1Y+lttS/fwdHbVbzN5YQXSoyx/NSjuAgF1iglCLGbpNJbwE6StA8a+an0bQVwNzySFZ5TqnsfmLY1L5Gm/51Q5HYNafldGAQdzPZPOmH/6zuWLzDTTvXZF5ZLvi10DsYf4Hs+16TlmcM0iI+mLHzq35glaDIkUr5ivj+SpTXZbp6wdnbRgvtzHwCLHHcd27MzgWmXZI8cgI2PBIKBOMUGIxZx0Mtv6PDdEBl9idHwy146hVLdWbI/cIHYtiTPzStkiqYNHD1yoY8YaZMVqtkqc3DCXyd9zupx+jGr5xQvnT9lmxEdiz28lcQrqQve8otLVs5fMpQ6m/UVTWS3Nn/7aGiPCMrhp5+n8/MXlOzY9KcIug2uWbzpOZp4/PRu5vdhrrzEhZJEhZdMjPxBGnflFIFuKyW8sJlIm0CNVqkqNHSrlGcY2SD3NCNNiH2LLdZ2+PdKsrjJ3kcZKtXexu7gMTNqcPg0V/efnklImn4P4pY5tGNu8QCjhpE+GG5Pgm5RfLOVmjjtWY5PBbYOTpnugPzG4pnTTcZqWTUa71HvkE8SoNn8IqFNMEGIxfGv1EHdeZi9iW9eSRpQmT5UCzxjrr2TDuhdDPkva7dfOc3o0bOIiDyNvhoT0IuSYrahbWDY8JthO92lStjS4Zs1r0+d74Js46QcXDF3DNizUVkyZi6j2yIkhyFNgCKhTTBBiMdxJ2cpuGdK0e0nEN600TK2tNpU+cs5zejHW5Igs3zaF3BhNFqZ21lxWOfsCsdrrvuWq/rmz0i1LdtCiRUuDT2aMsJA7s2ObUOzb8cRvFWIxJPS3nPsvzvhFvUde4Ik6goZAnGKe2fykgnF53qMUYSf3s61lQru3jK3oZzyMkSbdNcy2Sn08O7VN5zlTNSUfnBJXCM/w5CP6b//ksfOF+2Kk2rv4hSRxzbpu65Jh7sykTpPOOJ2CLSKK++Sx0zPJ8E0646tcvoYHe3eernOZ88He8cQczkuGiGemZzll1SPnJiFn4SAQ14shivnitNMdWg69GB0ougWGX6LOoAGeACndYPJbtmq+LmrlEO6cZstFj4g/bR83mtNOozHfEFBfKAUhFuMbLKgYCAABbxBQp5hAxGK8ASHLWjRxTJtHwcoNBAlPGsiyXf+Kj78e+YcVarZBwN1C6Zk/PPrxT0wqLv1nY6FEvozBNTkQ1jR6M2fOHIwtEAACwUfAKcX8/ZXRuzuuMtbPRx7zGS+1e4OPEywEAkBACQGnC6UVP1lgjs+9sfN/EItRAhyFgEC4EHBKMUkyZfv2vYdYTLhmCnoLBJQQcEoxXzz1HHP9hx72Efkxz/fFKPUZhYAAEMgZAk4p5ryvXvbNf7/55C/9i7TsqKMnyoP87lHKGUxoCAgAATUEnFIM1f5PxVPOveg7dECLpoMPOQyxGDXEUQoIhAoBFxRDuKyKLqT37934qyT/Bb5MqCYNOgsEnCPggmLe3PW3V/48/L+mX3j4R44wGkAsxjnWyAkEQoiAU4o5sH/vnf93ft3XvvsvF3zbDBP8lxBOGnQZCDhHwCnF9D/V3Xrz6i9UnpXSf4Ev4xxx5AQCoULAKcV8+axZhxx6eDr/Bb5MqCYNOgsEnCPglGLS1Qj/xTnWyAkEQohAthQD/yWEkwZdBgLOEYhTjHM9Klk77otxjjJyAoHQIqDuxWCPUmgnDToOBJwjoE4xVl/GeavICQSAQEgQyJZiEIsJyURBN4GAGgLqFINYjBriKAUEQoWAOsUgFhOqiYLOAgE1BNQpBrEYNcRRCgiECoFsKQaxmFBNF3QWCLhFQJ1iEItxizXyA4EQIqBOMYjFhHC6oMtAwC0C6hSDWIxbrJEfCIQQgWwpBrGYEE4adBkIOEdAnWIQi3GOMnICgdAioE4xiMWEdtKg40DAOQLqFINYjHOUkRMIhBaBbCkGsZjQTh10HAg4QUCdYhCLcYIv8gCBkCOgTjGIxYR86qD7QMAJAuoUg1iME3yRBwiEHIFsKQaxmJBPIHQfCGRGQJ1iEIvB3AICQMAWAXWKQSzGFlxkAAJAQJ1iEIvB7AECQMAWgWwpBrEYW4iRAQiEGQF1ikEsJszzBn0HAg4RUKcYxGIcQoxsQCDMCKhTDGIxYZ436DsQcIhAthSDWIxDoJENCIQTAXWKQSwmnDMGvQYCrhBQpxjEYlwBjcxAIJwIqFMMYjHhnDHoNRBwhUC2FINYjCu4kRkIhA0BdYpBLCZscwX9BQIKCKhTDGIxCnCjCBAIGwLqFINYTNjmCvoLBBQQKHpyYI9Csdt/dMWf3zw0qeDazmsVqspvkY997GP5NQCtA4HxjYA6xQxu322slSguQ8dEMZ/5zGcKCK+//vWvoJgCGi+YWogIqC+UEIspxPGGzUAgxwioUwxiMTkeKjQHBAoRgWwpJuN9Md3zpi2Naah0zyuSaV532jMGgJbMsaXT4gULEWfYDARCioA6xWS+L4ZzQlHdCh3V7nl1bMMYpeElW+sEyVjPxEege+2KuTz3hrkrFgqO6r7lqpM33FWbwzE6cODAq6++umvXrhy2iaaAwDhEQJ1iMsdiIgs2E51U6g4LccYswRCRC2ZXbn0+xjiLJJ5JD25s6cKtS76fQ4J5//33d+7cecghh3ziE58Yh2OOLgGBHCKgTjGKsZjISSf3D+mrJ1GH9Uzt98nXoTVV3Yq5ixZEuAtDf7IAZenPfvmZsunGiz5mqOyDDz4g5+Xggw8+9thjyYYsmkVRIAAEWLYU488eJe4DiXRXrebCWEM5LgZvwb9/a94l/yoL0AF9zFD49ddfJy/mmGOOAb+4gBhZgUAaBNQpRnGPUuz5rZVlCS6J9Uzc1tjSOatnryJPJh6dWauHi12N6f/5wXeJXOhFB5kLErlMmDBh9+7dxHCumkBmIAAErAgU/eK+XgVc1t7bsfP945IKJt96RyHfOWzVZr7GISdk7SzySRidKx1aREfWMynMMDLpB8YJBZutRdLderd//36KxRx22GETJ070pCFUAgRCi0DR1mVTL73nG3f3t3yBY/CnjspLR294ZNmF8qe164Erz318hvbxT7dXXnoP+8Zd/S3/zJqamp55+WDKIe/rlfCZKYZTyVX98jxdHRKUIi8wiU/8wHomaRRMFGVkrlwyLDjLk5Th7t59+/YRyxxxxBEf//jHPWkLlQCBcCJQNHXqT3R+EaTyYPO5NxabGYcJTjEY5yZ2/SO3f+U6nWLMqGEDQTjnEHoNBDIgMKH6hm8K/0VLEz9bzNjo6A7x8dnH72XVxZ+Of3najGrWN/qKOKEYi8FoAAEgECYEitb9fewrk0w9frajct7o9d3L6CT3aDaeRT6LEZAwfJyfNX37mZc/mgQUdlqHaeagr0DAEQITis38Qgulv4wyVixPvrK9l5UUmwOe/ExV8T/yL/fK6s2+jKMGkQkIAIEwIZB00XrXUxt72SVnydDv4xTcPd28iuJnqmecxknnLe3Oen/uiwnTCKCvQGBcI5C4UDKtktiOB5prHz9LrJhk4leURnislyjm2zNP+387Pp2kF/PY6pvHNVboHBAAAq4RmHDTb/6kFeL8cu837tI4ZdcfHu/VV0zi6jVdsf7G3VpcZtcbO9+AXoxrsFEACIQPgaJ1V0y9qU/227g7ht8Oo5/UIKk2bpYRTLRnz54jPncGfWe+LwZeTPjmD3oMBGwQKFK7Td649c5cPSgG0w0IAIEkBNQp5r+ei6+VpC9zb0fzeMX3k5/85HjtGvoFBHxFQJ1i5AYCcyKKKS0t9dXcvFQ+PDwMiskL8mh0HCCQLcWYYzHjmGLGwUg77ALI1CFQyOYQgWwpBl6MQ6ALItvf//53UExBjFQBGalOMSljMekWSk2dW1KCssVyuj86NWjwWRdKzz77LBn51ltvmU19/fW3Zs48P2jGu7IHFOMKLmR2goC6JJXb+2KmGokRiWiv+Elx5MTiIOR54YUjp0+ffoEpnXrqqX373g2CbbABCAQKAXWKkd1wvkdpi5EYuS7xT+Yj/k3KNNJRpT0jRf6paupRgpHqqeoYUSqashA5Mlt2MXpt3H5oWuO9aw41AYGCQyBbinG4R4n8k2jjVPn6zilj9E4LInotmfOOPOi9vaKROzGdaRH88k9iUs93bCzW/fnnbsqCKTwimueffz4Wi42N9g+/tPvtZzwkroKbRTAYCKRFQJ1ilPVi3n03vqCQ4QySmKNEB4ce+pyTsSqpmfn5/96W8BgDJ8U8zdO5ZQvxC8WSBgdf2D+0/rDDnndR/Ut3nk1qei2P6UXE57PvfMlFFcgKBAoDAXWKcRWLoV8gpf7+/k2bNhEw9C4T91s6tzz66KP33/+Qc8BGetY99+UpXF5zpKNJrqCqmqRXo6+oxGeztxI/3rb4ku/9939/LyJWTAn5nVvAWOPUqRSKaWyc2tDwb/Q6tOz873znlO5hdt/ICL3sn/E2bdq0wZjGKS89fP9mN20jLxAoHATUKUb20Xks5qSTTqqsrKQoKZWid5n+538+/fWvR+ig4vx/s3EEiBT0cEyE1D3vaSkhfrika8o9Yu10z5SuS4gyehZ/7/PdfClV/9z3FqcJ10xpvecnX6ZlVx/V4CR/6sEk3d/XRCJHZvXm3ZSJejd72tFEPRSUqa+/xY5lLrqo/P6HJce8OMy+9a1phTNpYCkQcI5AthTjMBazb99JVptocfQP//AqnY8dOMreYiMWE+v+CXtuHS2TRtZ3cW9EEE+EHJOu9SORKV/urK2qalp/4j2xaI19pW7zx2ukpxQMifTOO5uO/NuTb08QTlRnJ+tsor8///l3bFnmvDqNYx7bMHhRnX5X9Et3tvBFFK2bWuTCSS6qjM9JH9ljWnaeQS684jWcrS2+7Oq0xwk5gIAqAuoU4yoW88EHf6QrR3Jx9MKRRz700ENyfURezG9+ExtY/2t67XN40bekpuX6z3eukz5KI/dZtERuSUlLH3k010/ZdlMk4uSik9v8cZhPOOEEwxejFZP2RWMja4zOmHHMZb/4BZ0hlsk0LpNLGfdjOMOcN1lmfOnOpvtLo2/yFC29v4lI5rHbryv/T/r49EWD193+WPJHxs7ueExk5xlupfxUw3XsmqdFDRcJz8i2TtW5g3JAwAEC6hTjKhZDltBtL/I3SeuIc845R66PaHE09atTKyp4LIOe9Lp//+cd2MxYzcxG4piS8+u/3LnOiMHw2EpPU1FVB6tpidJa6LkX2IkUFV4vYzSxbalqTszv8qKQvGLN10qaBCB5MU30/Bdin6lTtzQS3WS+0eeE8y5iwy8Sw5RHTtAYhoIym687RXgtp1y3eTMx0OTSab/817PPbnk4En2642yW9FH6LMLNofycTx6+n9185dlafYJhbOt0BDkyAQE1BNQpRrbnPBZj2EeLI3n9SFsfbWfDH/JYhptEC5znXhgpabmnm3WJldIl2+p5dKam9SefFyciXfwzfXxOrKSqFq8zVV9yYj2j0+TmJOV3Y4LI+9kPX/vLBPEYKXlHT2OURaNEPd+f0cX5Jd1tPlo7xDGDt946WF53tqnhb3GfRUuPXX7CCZeTlxK9pnT41lNOoZVQ0sfHWk65v/Qa4fY8fXP6aE7mOl33GgWAgHMEsqUYh7EYMoiWSHJ9JBdHdAmJFkf8t7lly5v9q+iVyWha0PDorJH0zyU1UVoZUeqLyq9LWvQT4rNYCImvo1Feg1auRpzmwZqk/M6Bo5xElBq/bNfLNZEXU0kUc8vGeidVcT9ms4lh6PO0X24wYjD8MvZjLRRQYWdf3hG9mV+CSvpIjZSzydxneenhYe7F8BppQSWiOBRFlmds6nRiKfIAAUUE1CnGVSyGrLv22msXLVr/y19e0dnZSe933PFkNPozetHHX+nJ4X0xin31qdh2ul+wUrscFo2+1t7zzjvvzDlxiZ0LI6zhTgktf4x0wuXR/2T3i5VS0/BF0ctPYGdfeXO5OHHK/fyz9aOe/f5BrcbozYP/Kmq4dVBcCret0ydcUC0Q4Aiob4MMs17MffeNnHLK2NNPFxnRlsMGnqe7Y8iFIUz7v/Pzy35xGd3JTOz5u9/dmq+JRh7PKRvqEhjMzhRsg7RDCN+7RkDdi5FNKcRiXNsYyAJ0zaiv7w4iEZmkjavn/a6zMUrUQ/zi7n5f7/poXMU+5VYe+PWuYtQEBFQQgBdjj5oT1bt169bT0s9aVx69GPuOWXLAi1EADUUyI6BOMa70Ygp6GJxQTEF30DAeFDM+xjFQvVCnmFDFYgI1ZjAGCBQQAtlSTBi0ewtoOGEqEAgaAtlSjLk/ZnnwNWvXB62rsAcIAIHcI6BOMZljMUQxF8/yUcj21Vdf/fSnP517vPLYoh9dLpQ63cLuR7/c2kD5A2KGguUeFlG/aO12j5KHRqMqIAAECgUBdYqRPQztfTGFMsCwEwjkF4FsKcb5HqX89hOtAwEgkBcE1CnG7R4l37s3sqy6epmux0AfiuKfUradkN9363xsYGRZE9817lnqaaqW+oI2ALppUK+z2ktD3Rhg5CX9Dg/7pWRCuAoRxex64MqOP5l6/afbSSJSpuYHdsS/MJ2vfOqpp4Ici+lpirRUdPc2m/Zmj89h5UxaFGlJ/9wG993uaapl9eJhD7H6Lke6XvZtUJ0Dos5YG6vNK8mMLGv3Eiz7riPHhF0P3nhT3+ioiUq+cGX/3Zcwdsnd/f3LvjIpDpHpfP9pp30psLEY+tnVDnQ40tUs+PEvae6lH253o4cdqYmORSU3l9TVVw0Mu9TpSmkJ1Sn5viRS5lGVSj0eWdbQVdFYpVQWhRQRmPAUO+sbrHeUS+gaadfoCKs+/h8tVZrPHyq/DVwsJsmBoUWE9PoND10/U93Q1UcdMC+X9GPhG4gyxsJLEd6CLjayoauvotRTT9CHKl1A3LO4q6KttcxFCWTNHoEJxReeVlzFRv9iaEMytuOpx/uqzzp1YnLtCef3By4WQ+b2tUTaB6qYLuxL/NHQwtqEh14/IDz0+JmVbRVp4OtZTKssWaYl3WMMskc+6DUIpDpaHWisO+wJJ+6It1U6bFlm62lqZ21ONONd1YrMdghM+AKbWFzCere/Es/56mgvKy42LZG0r0zn39r+x0DGYqo6Vvb2djd2tgv3g/5n8h+J8NCl028+Qz57anToi87a6uqmDaUrw7HcssJAdNDQVR/zNJolFnXexXfsZnbS9xSEGaj3kDBdNh/i7PyK0j8eX81GRg03ZtdfRllVcYplEp1n914q4sAvfySQsZiq+jrik5rWDtbSoL7GEb+FlW1lQ+3OHmMw3qYP8QtJH6/0lF90jLyL77hDna/QyMflqs5cozWCi0ru8Msi9wTii3Nv7DXVsOupjb3VM06zLJPE+Rse6e9/5Poq9saevbJI4GIx3KiS5pWCZFhdPaOljubQ8LgCzXDzGZ63tKJvaIP2lIIhzaOmy5qspjm6siOfscksRjWbonyB5PHVOL5EahLDwB1Lr+M7jjor4+LiOllHVVWHt/6ZIwtCm2kCPQS2v/v66r5RfaX0ymgfK/5snGHoWnXHs4SPcX7iV9quP+avLwcxFmMMoySZxTH+p117IoFY9PAvBmr5mYYhJhZK5PMMiH9v1fpTCuhMhf4Yg5Xj/8J34tynQFQf66zVH7zpyX97Ar1bDgOhXh/WxWdYOUZsg9zxQHPtTcV39bf8M2PPdlTOG72+W7tcvevB5nM3nvXI7V+ZmHj+2zNPG9x/chJoSTutsQ3S20nlx566QqnTLZJ+9MutDZQ/IGYoWO5hEbovprmy9iZaKd07r/KHbZWV8+5lrPemWu3eO1pD0aLpFboZTzuv3Yx36Cf/SRqBPUoeDgaqAgLjDwF1MYfMqncQc/B8rvjxL7FQ6nQLph/9cmsDvBiJ2Djao6QwBVAECAABnxFQp5hA3hfjM1qoHggAAZcIZLtQSqfdSwuls//lf7s0xl12et4hPco5bO/uMELuvCJw9NFH57X9QDSeLcWYO5F0RYkoxj+Id+/evfcDdRcsENi7NOLwgz70HE+C0Z86d7vsnMfZRbeCYAMoppBjMZ+aeJTHEzPY1ZG/FmwDYR0QSIGAuiOQ91jM33a9FaohpVVhqPqLzo4PBNQpRvY/j/fFuPNiRl/cTluszMl6xvshfbHzvBmdSe2qtuLaixmhpNoYygEBjxDIhmLGGBsTvgw/EC9nySMhyDRezKOtE48i9hEv7ef9+IIZn6ps+m7lUecveFSaaD1jmL59Y/P5eg3nL7hzu/xi9E7j5KfOa05mDfO3E2e0bnxRr21y48MbG4sTayDS2aifOU+vnxEZHXX+z42CKZC08WISUeVClpGGhkhcJ8fZ2CTm8miktEpH7q4umhXfnUofq+8WHPj7pqJrTcKg+sd4Bt0q6xm3vQqCDW5tLvD86hTzzps7Rd85s+jHtmB4KQSZ3ov59qpdbxEB/W2X+HmP3rl0aNYfdm1cv+uZC4du5exgPWMYvrH5u7exBf2y+Fs/LX3hVJ2VGNOrvfrEB+cb1KCXnPbjP8hG+6+J3PZFjSyIejQSebS1cu2Fstrlsx78WvPjiVA9vuCLN5StWX/Z5AwIpvdiLKgK5YLYWG8v17yRwhZuk5cjZWp7S0uDpJU8piDYkMfu57ppvtOaktjo6C5x/0V3X7Rj+wq8FIJM7cWMjmybduIJZktefKG/rOR4fmZySdkfY+QoWM9o+V/svG3wwuXLzpJ+B2PHX7bsb0vPSe7WjJIpm194KV1ni89pXP5jtu6R7eYM3KpZ58hqiy9fv2vZWaZvt/98xpyhH//B2lBiE+m9GAuqsSF9O7PYSB6zHxhLDi9HKl551cKOivV5lvkKgg0KA1KwRfhO60duqL53XoJCuKPu0P5J8l92C19GHOc4pfViNq/97nl8oSRdie0jg5WlmndwQumXto28aD2jWT76yINMJ4IMndloYbGkzMUWDio+90L2g5/9/NHkeBAV3Nh86g/LVz18+fF28DmPxYwMD1SVRWR9+RXLtfaprvX8gfY8OzJBsMFutMfP93yhNPGz+n9t9/3Ko15M2itK02YtWE4LljVT1n2xVUY9FNLGZi2gEw+X/MccGaP52topV2dmhMmRaYMjCVHeyY3L10SGbz21Mh4h4kZt/sGptw1Wsv/ocWDnOLmiVHJpW94dmSDYoDAnC7MIpxiSuau+4ZtfcNkBs/+iHbusIcvsqb0YWoY8fDlf6RSf8+8zuc+i2MqMZSKw8uPKeHk9FtM/a5slmJLYyouxzeUlSbxNC6ilG6nOP9xXfkM8lPOlG5dvXH/ft391myW4Y7HbuRej2OVcFauJXsHy7cgEwYZc4Z3ndngs5kZ2w7ILLSp3doaR/2JcSZLHOU4O74s5vqS8f1gjmpeG/zilZLL1jGY5X86sfdT2GjNlS3ZSErtujQeZvj9+Rt03jVCODNDMuPJG9oPvZrycRBU492LMAZh4WCbHw5OpuTNb69c3LDZCRMVlVS/EH6YyMjpQFdGWeT7aHAQbfOxecKqeUE3yMDf+yvyoNofGcS0rxt4VsRh5nOOU0ouh0OmnFjy6nUwZffRnP2QXnjuZTT6xcmiEn2Evjgx9KUJhGesZzfTJjVeXPzi/+XHJMqN0GegH/dZeUcjG6qQY2UYf7Zz/g6SVlLBK81O2b9zwq6SANKNl1I/ZD5sy30HjwouJB2DMYZkcj0+m5kqar6joXMUfMsPT8aUVW4ZiYohIejMW66sgxXrfUxBs8L2TAWhgwrL+u7/B7l3xoOkhJ27MClos5vjLoqvYradSxKTyVvajKL9oXXz5grK1p06ccf7ELz5Ydk3qM0aXZyz76dVsKY+YHPWp+Rsi95kXSnospnLtlPsSLgnx0hRVkZGayltjVz+zeEYCiMIqsoFnOPU2tmq5JZRTfPlPf8RuuEO7bSflCDj3Ykg+tI1Lg1bTvTH05KBAaoOe2dox1ehmTXRT2boF1dWz6NWwLhKLnql91bcoUvS5Ivlq+j0/aT3jZrom5g2CDerWF0pJ2ga584Erzx29VKhqOk5NTU3/9dwbRxx9rCxBvgwd/3pZS2lpqTwjd1p7vsXOMJD279F/dYdrJV6K7uVlk483x0esZxx3Py8ZiZ7ceYv85t6Skoz+ALZB+jeUYismtkEy8cBZdv033fCLHJUC26NUnMgv1AHrGf+mmxc1u/BiZHNELzlYb3jRNdQxjhGYcO72uf2k/u2+i8GMxbjvR8GUcBGLKZg+wdDxj8CE/ivdXq1OACVosZhxPGKuvZhxjAW6VjgIqO9RMl9Lksc5Tu52WufYOB+agxfjA6io0ncEslK9M6KP9AwuOraGe/02H6qafiOM+rNBAOFeQk+dYp7+y0FUXl5LksOQ4ytKYRs/367+eHzVww873f7OYYNbxPzLr75QkhoxKnox/vUGNQMBIBAwBNQp5t3d/G69sbEPhS+jeOdewNCAOUAACHiMgDrF5P2+GI+RQHVAAAj4gIA6xZj9F3nsJHHBR5GqlbTY7JsQam1aqm7yqRF7M3KbQ0e1usmkT+mBCd4Ka0qD/KjTfVd7mnybge6NGd8l1ClG4uLuvpieplpGgo+UYvVdEY9/D/GBauzmTYyNtZV1NYSAZAhVLqNJoLaxWq9A9UNY0486lX6eJDzaqVQQhdwjoE4xKrGYmuhYVG7KK6mrrxqIb+B3b7iTEjWqqpJOKg9OHkK1V6Ba4qHEnR/Cmn7UqTAMI8sauioaqxRKoogCAuoUk10sZmRDly4vq2C1wyI9JoFJh0UKOltOQC1ohLjxPYtp93lrWcH3o1A6oE4xarEYiQv9H2lhHa01PqHUWSuDMbVBVTLwod98ERLxE1QfbM5HlT1N7awt6tfMy0ePgt6mOsXInrmLxWj8Ut3QVR+Tvr0vSY/F0BM+PItN+GKoh5WKRYivES4Pjc1bVeLpL779a8tbtwLdsDrF8FjMGBv78EN6l8dOEv2zjXTVr/SRX0xW5CTg46TXucoTug67BJavJPtaIuTgRlr4gV+XNV2aNb6zq1OMSiyGL5AqunPDL3w9louAT97nB18iNfWI55+Fo8PqiMt4s7ii2VFV1eGnJ61u5HgrqU4x3H+h+3rfEvf4imPb1LO4pY/pgRL/bo0xmiBVye7xv+wuaV7Zzdr5v+aihqH62PjvsO08Q4YgIZDFNsg/c3oqmjDB4Jdf3/69XAprYhtk9hPJj+2CftTptqewwS1i/uVX92LM/os8RgICQAAIJCGgTjEqsRjADwSAQMgQUKcYhVhMyLBFd4EAEGDqFCPBU7gvBqgDASAQHgTUw738OUpHaU8uoFgMHVvDveHBET0FAlYEwnZFIuUcUKeYZ14+eOzDD2SlRRMOouNf374AV5T8+6X5cZXEtzp3+4eDk5rFY9KCYIPHoqVO+h60POoLJckv7771Or0bXBO07sEeIAAE8otAFhQjxHspFsMlfMULCQgAASCQhIA6xbwn/JcPhS8jj5GAABAAAp5RjNp9MX5JQBrdMgtrCkUHLgNHJ+M73ngO/knmjKvEic8ym/NKAjGhSCUyLibqpcyftyKYI3dXF82Km0cfq+8WW6t+31R0rUkRVP8Yz6CjbD3jFv8g2ODW5gLPr+7FmP0XeWyffJGAtDRL+9u0zW78T9KenZ6mSHwnZlVVXHqPbyE0VeW8Evtu5yCHrl+h6d9l36JPIphbWhokreQxBcGGPHY/102rU4y01N19Mb5IQLqAjH43tQMdpp2C9fUVXRvklI8NsUZHaouWSlwY4EvWET/E/fwRwaxa2FGxfrG3GuZuMQ2CDW5tLuT86hSTVSwmL6oDCQ6MNmh1MzWO6Vk3UD/TgdpiqkryPwH6uhrEgxeCL4BS13r+QHueHZkg2JD/OZMrC9QpRi0WQ/3yXQJSig5pSY+10Mn2gSrWuS7pX2ikjHE/hjNMXcSEuqtKcjVaadupqm9bSSIo3RU+PtfBo06WXNqWd0cmCDZ4BGfwq1GnGJVYjMDDdwnIhDCKEYqp6ljZ29vd2NmeGA8loTg2FCOGqShNEPp0VUl+x5kA7W2uIetLalpz8FyHrDtbE72C5duRCYINWQNZGBWoU4xKLCaOSc4lIKvq6+hHWNPawVoSn61Elgy0tw9UzHQgGZ22ksIY7MBYeWZr/fqGxTHdnuKyqhfiD7wZGR2oipgdSn/MDoIN/vQsYLWqU4xCLCYAEpAkEZdMMtyP6XPEMPrYpagkj8MaR3WEZAWZoNKgp5LmKyo6V+lX8I4vrdgyFNsujR6JxfoqinPQhyDYEPRx8sI+dYpRiMXkSAIyIYxiiYBKfjBf1eArN4scpdtKvBgMtTriqEbaWcdK/x7soGZemlJntnZMNb6qiW4qW7egunoWvRrWRWLRM7Wv+hZFij5XJF9Nv+cnrWfUzQqCDerWF0pJ9W2QW7YXUSffe/v1j37sE7K3q+7ANkgfx923LYseb9UTdgZhC2IQbPAYWx+nl29Vq3sx0iR398X41g1UDASAQDARUKcY8l+oSx9+IPYoiWMkIAAEgEASAuoUoxCLAfpAAAiEDQF1ivnwg/dJwkH4LyQXw4/Dhh36CwSAgC0C2YR7eeUTDjpY8AtPq+64Kkn1zrZ5ZAAC4xgBCGvS4KpTDGn3fvRjx8j58d7b/NhKMf5B7MfllYDPdT+67FuduJrD/MA24FM0pXnqCyXEYgpxvGEzEMgxAuoUI9dH5L/Qu7FWyrH1aA4IAIGAI6BOMbJjuC8m4AMM84BAfhFQpxiz/yKPnSdSgvRL2cSpJmYPyWjGRTXJdCm+ma54XB2Cq7IYBUd0oVBxVt/DnaDjyWtuMjdlNEHteSjO5K0IphxLb+sMhqilMWJ+zUDnP4Nw5FSnGPVYzMiy9k4/0XWkiVlTl6h7QCJZ2g7ClMVNJ0mVZUAqQvQ0NbSzNl3Fc2XZUCSBtCRvFRVFWkzdJUmrrnpZZGV9V21yASVc/BDB9KNO6ly+RS1J2pVJ+GP1wdfWUZoNQSukTjGqsZiRZQ1dFY4ULL3HyqyJyTdY66KaxAUGw9i2WlIzs6JvKEb00T5QvzLKhVpEKmmOWnZTWuQpuQimvhc65fZL2+ZTZPBDBNOPOhnLu6glSbtG5UbRnMuJqIzseCijTjGy965jMT2LuyraWh0oWHqPbpImppljXDAMGyH9qqqyiJsi8b7wRlsWL+sZybdGtvfwOqsxMKKWedF2dYbR+MqlTjFKsZieJlpZWIQTPIbUqSZmnGMS6CJdcT0cQ5IJbUmSCcZTRuzX91x6oWyoPcK1P+1ze4xMEKoLhqgl+dItrKPVgQxZEDAraBvUKUYhFiOWFv4Pq2NNTJ1jEh2SlMWNk7HuDjawzhBsk4NP7jdf3XdUOZkLJTXN0V6evbsiSYDPSelxkCfvopa0Xm6ggFhvgUjrFPiQq1OM+1gMd02lixBp4Qc5/SeeUhNT4xjncRiuj9vcVsFFxhNjOQrTgGI6jTymE8KUT1FL4hcKuK8Ev+Rq3qlTjPtYjIwgav/vyS3IxygnaWIKnmjQryU5BJ2oQXAMcU1XQ1OPjKrQ5WsiTrsahAimdm2bYjqdFNOxKzIuv8+bqCVfIFV052PmjctxdNIpdYpRisU4MSnrPG40MYVwb6Lebebi3LpImXyIZE10ZRtrl09UaVhX1m2/UBIimF2yBMV0ugtFBjPrMbFUkB9RSxI37mOdtXpYLad+tPcYFkaN6tsgn3n54A/0PdYHHcSPV1t2WmMbpIezwI9tdb7ViW2Q2AapzX11L0byyx5xX6/BNR7+olAVEAAC4wABdYoRGlRj4roSP4Ak1TiYDegCEPAcAXWK2fP2m8J/OSB8GX6MBASAABBIQkCdYrj/orsv2jHQBQJAAAgkIqAe7u0f5WK9e9558yNHflzWufqnV0NYExMMCBgI+He5o4BAzpZiDjr4kA/e52ullBTjH8R+XAoJ+LD50eVCqdPt0PjRr0K0wa3NfuRXXyiR/0IGSX6Rx0hAAAgAgSQE1ClGYY8S0AcCQCBsCKhTjNl/MdZKYYMP/fUAgRFKHlSDKoKJgDrFyP641IsxVA98kzJwqYzJ+8CNMm4lH+lZZghkih7yzyTvwuXrTPKY4rP5/vOESnSZTvOYm7sub2D3RPHOaMJbEUxZrf91cpnLSENDxCRW6vMPBcKaPgOcXL06xajGYhq7tb2Qvu1Fc66MKTlk3UBjY4UugFdSU1dmUlwkIcausjqhbFdVJXcmid8ebRpPgDKxklSDKAUftNTdyFjjTK/USvwQwcxJnULdIzbW20syl5pYqc/zH8KaPgNsrV6dYlRiMVxWMv97i3VlTI0thgcqZkZnGhxDO6hXdgwIUV2pw2lsVayvNzLFhlijWRyUOpZYScaBJGGugY6Yd8pcfohg5qTO2FBfRamUuSwVYqW+Jwhr+g6xd16MYiymr6uBLznyqfimKWMa/kgFuRORMpOQrySZ6iYSGU7Y91+nExH5LPUzTeKg5NRYKkk3lIK36sO7xdqEi/k/jr57PWe/AAhr5ghqdS9GGugyFkPLjfq2lULxzT/9dzfKmBo5JAtMCVmZzopkDVCNiDjD1JmEXtJUkmoIhTg69EpyNLvTNwNhzZwNgTrFqMRiyPvubeaBjZKa1sRnjHjZYRfKmPxfmZQP4UJ88QcSCHOsazquLjMUI4bR3HvDEUpfSWLEhj/hhB5a4GVvUZdrBCCs6RqyLAqoU4xKLCYLQz0raihjUo3c/dCjzyS9a1orpWmOOGagvZ3iLiaWcFyJCMFghRSH1hyAiYdlPBvp1BVBWNNngJOrV6cYhViMkJUUQpQjJD+WqDWXy35rypji4Unx6LMjMV6hkpfMME4q4SEY1ubbVbRcwuddW/EATK4uBEBY07vRc1iTOsXIBlzFYoSspBCiJFFJ//6fO1XGTH4SkjOOIQFi80onfSVmM5qW8avccUVHH+6LcTjggcom5I/pnhi6N4aerpWDBwJAWDP346++DfK/nnvjI0ceLS3e885uOl7909akndbYBunhiPqxtS8QdfKbe0tK9IdqeoKYH/1ya1gQbHBrsx/51b2YQo3F+IEi6swGAaIXT/klG1tQ1nME1Cnmg/f3S/+F3uUxEhAAAkAgCQF1ilGIxQB9IAAEwoaAOsWY/Rd5jAQEgAAQSEJAPdzLn6Okr48OOvhQOraGewE3EAgzAv5d7iggVNUppn/0QxmLMa4r4YqSrwPvxxUK3+rMs1e7ezf9uoNgg3bJ1deJEfDK1RdK8vED5ucQBLyrMA8IAIHcI6BOMXveFdeSDojrSuIYCQgAASCQhIA6xeC+GEwmIAAEbBFQp5j3D+ynpRL5L/Qujx0lXdew2ltZSaNt2gsU17vkm6Lkp5G4nqJJNzP+vShvLmsIdFJ1pE5l/jZ1qYyKnFJJ09dtA16LYHovQDlyd3XRLDEaEs+7q6vvFp9+31R0rcRYJP1jPIO1iKO5liJTEGxQtb1Ay6lTjOywqz1KXCa3tlPsbY7VMyEs52fqaYq0SG0WOqI9iDGharmSdDPNort9LQ3xaa+bQwW6SPFR5K/vSmGptVQGRc4OWZNMPkg5+CCC6ZcA5ZaWBkkreUxBsCGP3c910+oUs1fEX8h/oXd5bJ961nVWdbRyIYSS5qgfP7a4CVIUU6hXcoVYfiTvUifNmu6KlsU6vVV1dFR0GZ+08nzfb32dkd9qacpSaRU57YHJLocPIpg+CVBWLeyoWJ+Mdnadd106CDa4NrqAC6hTjEIshn65LEHMyTfg4g6MlPJObJU0BDrXGS5UXatFmprvuW5ZzB88kNbCFKU4faVW5PStnzmo2GMByrrW8wfa8+zIBMGGHIxcQJpQpxiz/yKPnaQqto4ea8G1e/1bJpGKQvtAFTOxSJJ+HUkhmW0VkgKJ/1q57ETZUHuEC0+YV1WmYilKCR/JqsiZUujTCVgByOO9AGXJpW15d2SCYEMABjc3JqhTjLTPZSyG9bGy1l4Ri5Ei/76kqo6Vvb3djZ3tepAlSdyee1MJqSbaxozM8hsSx4sKQ2lVlSJYw7OkKCXLJjFaSqFPXzrucaU+CVDWRK9g+XZkgmCDx6MV1OrUKUYhFkPeQ1WZDHHQUiT+VCKPwZFhlJrWDibIwdoUiTgmP8SItIS7GhYPWS2hJ6I0pn38RtpSHvcoH9X5KUB5Zmv9+obFxjNNisuqXtCfUEUL29GBqohJfN2nzgfBBp+6Fqxq1SlG+C/iDl82ph/b9a1mJg+0iovIlgCJXVnX34s1CycZvqRpiUhFT7p6LeLAIuZsTjxTZ6d8/poQANU8IHoiSmf6Zz+ZS7k2MMgFfBagLGm+oqJzlf60u+NLK7YMxbZLPEZisb6K4hwIyATBhiBPAa9sU6eY9w/sIyP2vvsWvctjB6kmqitrki63D5dvk2mDkwxFWWqiMa1dkvQcqo+llNAlt6dKlhcCoCT4KJ5M0M66M0l6x0ul7b690KcD5HKbxX8ByjNbO6YafaqJbipbt6C6eha9GtZFYtEzta/6FkWKPlckX02/5yetZ9SRCYIN6tYXSkn1bZCbX/qAOnnwIYcZ/PKbn10DYU3/Bt63LYseb9UTdjq7icE3sLAN0jdoXVes7sWY/Rd5jAQEgAAQSEJAnWIU7osB+kAACIQNAXWKUYrFhA1e9BcIhB0BdYqRyLm9LybseKP/QCBkCKiHe+k5SocfcZSEi2IxdGwN94YMTHQXCCQgAGFNgkOdYki717iWJK8r4YqSr7+wgrqi5PFVKrfA+oFVIdrg1mY/8qsvlBCL8WM8UCcQGGcIqFMMYjHjbCqgO0DADwTUKQb3xfgxHqgTCIwzBNQpRuG+GEOs0keRyYQ2dMWIBLXNVCOYqEpp1ZRMLQdq1bLsaUor/uD3xEndhew0M6wdzF6+M7EG+qRpe1ilB/1BzG9lV3+sLuBa1Snm/f37aAsk92XGmDy2TVKdTUuxjqrk7c62FTjLYIgnkGJEkkRDigosqpRWTUk6MyBkNmNtuhxoai3LnnUDjY0VXRtyLB2ZqgvJBjuDLp7L2sHs5TstNQg1Gi54SsCmk8xwa3jm/CmG0tsGUFsyAuoUk2UspmdxV71lu7PH40PiEWl1GIymLKqUVk1JOiM3TpaQXt6AkB1IqWVJOjQVM6Mzc84xqbqQbLBbaK0dzF6+M1UNtIudkM0omeHW9Az544qpJbR/dSAufehhG6gqEQF1itn7nthjTf4L3Rcjjl0kLqeri+O6KOYuK+kwDKTXYXBQl0VxIrMEBX1bMbOGRcpYzv2YdJ3JgWaGAxzTZuECpgIrPlQ++bQJjfN/OtrgjGwY6pP/LpB8RUCdYhRiMUZP+I+xTfgFfiRdPIF0GOoz6TDYtJ2kKcm9/EgLsyrN6NVoDMMlsALBMbYG+4G9yzpJNoOkwKqrG9pZm+/aHtw2UhOpEDId1aQ/pml3uLQZ2d0hoE4x7+/fS2JUwn8Zk8eOW6ZFEv9371cyYjG9UWUas2pKCi8/Vt9F2lYpDecOQ2etkJhp6dP/VfrVRSf12hnspA6f83CUGYmg9vauLGtPo5HstQk1Qi91rDc6k1RekfxHQJ1ipG0Ke5TEIsnvMExWyKXXlEyvB8p9GP6AKJFiHYHwYwgEPwVMs8KYFybMmLZczr3rl7vHYWSNU2FXoE4xe997m7ou/BeKxfBjZ8k0r5wVyHUui6ak0NnUZDnT6YHyXpUZgrO5/8EkgOTE4Fyjmqq9hMhI8pNo/DGQ7ioQkqkjXNcvF9Eff7pRSLWqU4xiLGYkxur9C8Okh96sbsmXOnyupVzxWDUlhc5mu9DZbCBVzlQxg2TezC/HODA4GHPUiIwURXIhtEqd5squPBYTqR1o9F/ZNRgo59kK9W2Qm198X/ovh3/0Y7ITv7nz+xDW9G88/djaVyh1ukXVj34Vog1ubfYjv7oXI61RiMX40Q3UCQSAQDARUKcY8l/oGtKB/XvpXR4jAQEgAASSEFCnGMVYDEYACACBMCGgTjHkvxBQ+8S1JHmMBASAABBIQkA93PtHEe495NDDDX65zxLuBdxAILQIQFVTDr06xZB272H6tSTyZeg4iWIunnV+aKcXOg4EgIBEQH2hhFgM5hAQAAK2CKhTDGIxtuAiAxAAAuoUI7HDfTGYQ0AACGRAQJ1izNeS5DESEAACQCAJAXWKQSwGkwkIAAFbBNQpBrEYW3CRAQgAAXWKQSwGswcIAAFbBNQphsdfxsYO7NtD7/LYtjFkAAJAIGwIqFMMYjFhmyvoLxBQQECdYrj/QnuU9rxD7/IYCQgAASDg2RUlxGIwmYAAELBFQN2LMfsv8hgJCAABIOCZF4NYDCYTEAACtgioezGIxdiCiwxAAAioUwxiMZg9QAAI2CKgTjGIxdiCiwxAAAioUwxiMZg9QAAI2CKgTjGIxdiCiwxAAAioUwxiMZg9QAAI2CKgTjGIxdiCiwxAAAioUwxiMZg9QAAI2CKgTjGIxdiCiwxAAAioUwxiMZg9QAAI2CKgTjEiFkN6Me/Ruzy2bQwZgAAQCBsC6hSDWEzY5gr6CwQUEFCnGOG/kF7Mu/Quj5GAABAAAkkIqFMMrYvoRb6MPMAyCXMLCAABKwLqFLNf+C/7hf8ij5GAABAAAp55MYjFYDIBASBgi0AWXozJf5G+DBIQAAJAwDMvRgZguC+DYAymFRAAAmkQyMKL2StiMXtFLEYcIwEBIAAEPPNiEIvBZAICQMAWgWy8mLj/In0ZJCAABICAZ16MrMjsywBcIAAEgIBnFCPjL4jFYEoBASCQAQH1hRJiMZhYQAAI2CKgTjFm/wWxGFugkQEIhBMBdYpBLCacMwa9BgKuEFCnGMRiXAGNzEAgnAioUwxiMeGcMeg1EHCFgDrFCC9mzPzuqmFkBgJAIAwIqFMMYjFhmB/oIxDIEgF1isEVpSyhR3EgEAYE1CkGsZgwzA/0EQhkiYA6xeCKUpbQozgQCAMC6hSDWEwY5gf6CASyRECdYhCLyRJ6FAcCYUBAnWIQiwnD/EAfgUCWCKhTDGIxWUKP4kAgDAioUwxiMWGYH+gjEMgSAXWK4bGYMfEEJXoXx0hAAAgAgSQE1CkGsRhMJiAABGwRUKcYPA3SFlxkAAJAQJ1iEIvB7AECQMAWAXWKMT/NGk+DtAUaGYBAOBFQpxiKxRiPgZTHSEAACAABz8K9++haEmMHxNOs5TESEAACQMAziuFPtGZj4roSHmqNeQUEgEBqBNQXSgf27RH+yzvCl+HHSEAACAABz7wY3BeDyQQEgIAtAupejNl/kcdIQAAIAAHPvBhZEZ5pjSkFBIBABgTUvRjEYjCxgAAQsEVAnWIQi7EFFxmAABBQpxjEYjB7gAAQsEVAnWIQi7EFFxmAABBQpxjEYjB7gAAQsEVAnWIQi7EFFxmAABBQpxjEYjB7gAAQsEVAnWIQi7EFFxmAABBQpxjEYjB7gAAQsEVAnWIQi7EFFxmAABBQpxjEYjB7gAAQsEVAnWKkSgz3ZSAXYwszMgCBsCKgTjEH9pNGzNi+996md3kcVgzRbyAABNIioE4xiMVgWgEBIGCLgDrFCP+FHdi/l97lMRIQAAJAIAkBdYqRFUEvBlMKCACBDAioU4zZf5HHSEAACACBJAT+PzYmJwosGskuAAAAAElFTkSuQmCC" style="height:359px; width:374px" /></span></span></span></p> <p><span style="color:#000000">Logo veritabanından klasik satış irsaliyelerini ay bazlı listeleyen sorguyu pivot table haliyle görüyoruz .&nbsp;</span></p>

Bunu paylaş
SQL_RollUp Kullanımı Logo Veritabanı Örnekli
Logo Muhasebe Programı
Yazar erydogan
1992 yılı İstanbul doğumluyum. "Beykent Üniversitesi/Bilgisayar Programcılığı" bölümü mezunuyum, 7 yılı aşkın süredir Logo firmasının üretmiş olduğu ERP ürünlerine teknik destek vermek üzere “Logo Erp Danışmanı/Sistem Uzmanı” olarak çalıştım. 2020 Şubat ayında yıllardır hayalini kurduğum "kendi işimi yapma" düşüncemi hayata geçirmek üzere DGN Yazılım firmasını kurdum. Ayrıca .Net C# (MVC) yazılım dilini kullanarak Web tabanlı/Mobil Uyumlu, Logo yazılım entegreli ya da tamamen bağımsız uygulamalar geliştiriyorum.

İlişkili Bloglar:

0 Yorum

Copyrights © 2020 All Rights Reserved by DGN Software.