FATBASLIK tablosundan saat aral\u0131klar\u0131na g\u00f6re rapor alan MSSQL kodum.<\/p>\n
select\r\nTARIH=(convert(VARCHAR(10),FB.TARIH,120)),\r\n'_09'=(select SUM(FATURA_TUTARI) from FATBASLIK FB1 where FB1.TARIH BETWEEN convert(VARCHAR(10),FB.TARIH,120)+' 08:59:00.000' AND convert(VARCHAR(10),FB.TARIH,120)+' 09:59:00.000' ),\r\n'_10'=(select SUM(FATURA_TUTARI) from FATBASLIK FB1 where FB1.TARIH BETWEEN convert(VARCHAR(10),FB.TARIH,120)+' 09:59:00.000' AND convert(VARCHAR(10),FB.TARIH,120)+' 10:59:00.000' ),\r\n'_11'=(select SUM(FATURA_TUTARI) from FATBASLIK FB1 where FB1.TARIH BETWEEN convert(VARCHAR(10),FB.TARIH,120)+' 10:59:00.000' AND convert(VARCHAR(10),FB.TARIH,120)+' 11:59:00.000' ),\r\n'_12'=(select SUM(FATURA_TUTARI) from FATBASLIK FB1 where FB1.TARIH BETWEEN convert(VARCHAR(10),FB.TARIH,120)+' 11:59:00.000' AND convert(VARCHAR(10),FB.TARIH,120)+' 12:59:00.000' ),\r\n'_13'=(select SUM(FATURA_TUTARI) from FATBASLIK FB1 where FB1.TARIH BETWEEN convert(VARCHAR(10),FB.TARIH,120)+' 12:59:00.000' AND convert(VARCHAR(10),FB.TARIH,120)+' 13:59:00.000' ),\r\n'_14'=(select SUM(FATURA_TUTARI) from FATBASLIK FB1 where FB1.TARIH BETWEEN convert(VARCHAR(10),FB.TARIH,120)+' 13:59:00.000' AND convert(VARCHAR(10),FB.TARIH,120)+' 14:59:00.000' ),\r\n'_15'=(select SUM(FATURA_TUTARI) from FATBASLIK FB1 where FB1.TARIH BETWEEN convert(VARCHAR(10),FB.TARIH,120)+' 14:59:00.000' AND convert(VARCHAR(10),FB.TARIH,120)+' 15:59:00.000' ),\r\n'_16'=(select SUM(FATURA_TUTARI) from FATBASLIK FB1 where FB1.TARIH BETWEEN convert(VARCHAR(10),FB.TARIH,120)+' 15:59:00.000' AND convert(VARCHAR(10),FB.TARIH,120)+' 16:59:00.000' ),\r\n'_17'=(select SUM(FATURA_TUTARI) from FATBASLIK FB1 where FB1.TARIH BETWEEN convert(VARCHAR(10),FB.TARIH,120)+' 16:59:00.000' AND convert(VARCHAR(10),FB.TARIH,120)+' 17:59:00.000' ),\r\n'_18'=(select SUM(FATURA_TUTARI) from FATBASLIK FB1 where FB1.TARIH BETWEEN convert(VARCHAR(10),FB.TARIH,120)+' 17:59:00.000' AND convert(VARCHAR(10),FB.TARIH,120)+' 18:59:00.000' ),\r\n'_19'=(select SUM(FATURA_TUTARI) from FATBASLIK FB1 where FB1.TARIH BETWEEN convert(VARCHAR(10),FB.TARIH,120)+' 18:59:00.000' AND convert(VARCHAR(10),FB.TARIH,120)+' 19:59:00.000' ),\r\n'_20'=(select SUM(FATURA_TUTARI) from FATBASLIK FB1 where FB1.TARIH BETWEEN convert(VARCHAR(10),FB.TARIH,120)+' 19:59:00.000' AND convert(VARCHAR(10),FB.TARIH,120)+' 20:59:00.000' ),\r\n'_21'=(select SUM(FATURA_TUTARI) from FATBASLIK FB1 where FB1.TARIH BETWEEN convert(VARCHAR(10),FB.TARIH,120)+' 20:59:00.000' AND convert(VARCHAR(10),FB.TARIH,120)+' 21:59:00.000' )\r\nfrom\r\nFATBASLIK FB \r\ngroup by convert(VARCHAR(10),FB.TARIH,120)<\/pre>\nBu da olmas\u0131 gerekti\u011fi gibi olan kod \ud83d\ude42<\/p>\n
SELECT\r\n\tTARIH,\r\n\tSUM([09]) AS [09],\r\n\tSUM([10]) AS [10],\r\n\tSUM([11]) AS [11],\r\n\tSUM([12]) AS [12],\r\n\tSUM([13]) AS [13],\r\n\tSUM([14]) AS [14],\r\n\tSUM([15]) AS [15],\r\n\tSUM([16]) AS [16],\r\n\tSUM([17]) AS [17],\r\n\tSUM([18]) AS [18]\r\nFROM(\r\nSELECT\r\n\tTARIH,\r\n\t[09]=CASE WHEN SAAT BETWEEN '09:00:00' AND '09:59:59' THEN SUM(TUTAR) ELSE 0 END,\r\n\t[10]=CASE WHEN SAAT BETWEEN '10:00:00' AND '10:59:59' THEN SUM(TUTAR) ELSE 0 END,\r\n\t[11]=CASE WHEN SAAT BETWEEN '11:00:00' AND '11:59:59' THEN SUM(TUTAR) ELSE 0 END,\r\n\t[12]=CASE WHEN SAAT BETWEEN '12:00:00' AND '12:59:59' THEN SUM(TUTAR) ELSE 0 END,\r\n\t[13]=CASE WHEN SAAT BETWEEN '13:00:00' AND '13:59:59' THEN SUM(TUTAR) ELSE 0 END,\r\n\t[14]=CASE WHEN SAAT BETWEEN '14:00:00' AND '14:59:59' THEN SUM(TUTAR) ELSE 0 END,\r\n\t[15]=CASE WHEN SAAT BETWEEN '15:00:00' AND '15:59:59' THEN SUM(TUTAR) ELSE 0 END,\r\n\t[16]=CASE WHEN SAAT BETWEEN '16:00:00' AND '16:59:59' THEN SUM(TUTAR) ELSE 0 END,\r\n\t[17]=CASE WHEN SAAT BETWEEN '17:00:00' AND '17:59:59' THEN SUM(TUTAR) ELSE 0 END,\r\n\t[18]=CASE WHEN SAAT BETWEEN '18:00:00' AND '18:59:59' THEN SUM(TUTAR) ELSE 0 END\r\nFROM(\r\n\r\nselect\r\n\tconvert(VARCHAR(10),FB.TARIH,120) as TARIH,\r\n\tSAAT=CONVERT(VARCHAR(10),FB.TARIH,108),\r\n\tFB.FATURA_TUTARI AS TUTAR\r\nFROM\r\n\tFATBASLIK FB \r\n) AS X\r\n\r\nGROUP BY\r\n\tTARIH,SAAT\r\n) AS Y\r\n\r\nGROUP BY TARIH<\/pre>\n<\/p>\n","protected":false},"excerpt":{"rendered":"
FATBASLIK tablosundan saat aral\u0131klar\u0131na g\u00f6re rapor alan MSSQL kodum. select TARIH=(convert(VARCHAR(10),FB.TARIH,120)), ‘_09’=(select SUM(FATURA_TUTARI) from FATBASLIK FB1 where FB1.TARIH BETWEEN convert(VARCHAR(10),FB.TARIH,120)+’ […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_uag_custom_page_level_css":"","site-sidebar-layout":"default","site-content-layout":"","ast-site-content-layout":"default","site-content-style":"default","site-sidebar-style":"default","ast-global-header-display":"","ast-banner-title-visibility":"","ast-main-header-display":"","ast-hfb-above-header-display":"","ast-hfb-below-header-display":"","ast-hfb-mobile-header-display":"","site-post-title":"","ast-breadcrumbs-content":"","ast-featured-img":"","footer-sml-layout":"","ast-disable-related-posts":"","theme-transparent-header-meta":"","adv-header-id-meta":"","stick-header-meta":"","header-above-stick-meta":"","header-main-stick-meta":"","header-below-stick-meta":"","astra-migrate-meta-layouts":"default","ast-page-background-enabled":"default","ast-page-background-meta":{"desktop":{"background-color":"var(--ast-global-color-4)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"ast-content-background-meta":{"desktop":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"footnotes":""},"categories":[2],"tags":[9,43,44],"class_list":["post-211","post","type-post","status-publish","format-standard","hentry","category-yazilim","tag-mssql","tag-rapor","tag-satis"],"uagb_featured_image_src":{"full":false,"thumbnail":false,"medium":false,"medium_large":false,"large":false,"1536x1536":false,"2048x2048":false},"uagb_author_info":{"display_name":"VeYSeL","author_link":"https:\/\/dijitalturk.com\/veysel\/author\/veysel\/"},"uagb_comment_info":0,"uagb_excerpt":"FATBASLIK tablosundan saat aral\u0131klar\u0131na g\u00f6re rapor alan MSSQL kodum. select TARIH=(convert(VARCHAR(10),FB.TARIH,120)), '_09'=(select SUM(FATURA_TUTARI) from FATBASLIK FB1 where FB1.TARIH BETWEEN convert(VARCHAR(10),FB.TARIH,120)+' […]","_links":{"self":[{"href":"https:\/\/dijitalturk.com\/veysel\/wp-json\/wp\/v2\/posts\/211","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/dijitalturk.com\/veysel\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/dijitalturk.com\/veysel\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/dijitalturk.com\/veysel\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/dijitalturk.com\/veysel\/wp-json\/wp\/v2\/comments?post=211"}],"version-history":[{"count":0,"href":"https:\/\/dijitalturk.com\/veysel\/wp-json\/wp\/v2\/posts\/211\/revisions"}],"wp:attachment":[{"href":"https:\/\/dijitalturk.com\/veysel\/wp-json\/wp\/v2\/media?parent=211"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/dijitalturk.com\/veysel\/wp-json\/wp\/v2\/categories?post=211"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/dijitalturk.com\/veysel\/wp-json\/wp\/v2\/tags?post=211"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}