{"author_name":"koogucc11","published":"2016-07-30 16:24:21","blog_title":"\u90fd\u5185\u3067\u50cd\u304fSE\u306e\u6280\u8853\u7684\u306a\u3072\u3068\u308a\u3054\u3068 / Technical soliloquy of System Engineer working in Tokyo","width":"100%","blog_url":"https://ryuchan.hatenablog.com/","provider_name":"Hatena Blog","author_url":"https://blog.hatena.ne.jp/koogucc11/","type":"rich","title":"\u4fbf\u5229\u306a SQL \u306e\u95a2\u6570\u3068\u304b\u3001\u69cb\u6587\u3068\u304b\u3001\u305d\u306e\u4ed6\u8272\u3005\u307e\u3068\u3081\u3066\u307f\u308b - \u305d\u306e12 ( SUM \u306e\u4f7f\u3044\u65b9\u306e\u5de5\u592b ) - ","height":"190","html":"<iframe src=\"https://hatenablog-parts.com/embed?url=https%3A%2F%2Fryuchan.hatenablog.com%2Fentry%2F2016%2F07%2F30%2F162421\" title=\"\u4fbf\u5229\u306a SQL \u306e\u95a2\u6570\u3068\u304b\u3001\u69cb\u6587\u3068\u304b\u3001\u305d\u306e\u4ed6\u8272\u3005\u307e\u3068\u3081\u3066\u307f\u308b - \u305d\u306e12 ( SUM \u306e\u4f7f\u3044\u65b9\u306e\u5de5\u592b ) -  - \u90fd\u5185\u3067\u50cd\u304fSE\u306e\u6280\u8853\u7684\u306a\u3072\u3068\u308a\u3054\u3068 / Technical soliloquy of System Engineer working in Tokyo\" class=\"embed-card embed-blogcard\" scrolling=\"no\" frameborder=\"0\" style=\"display: block; width: 100%; height: 190px; max-width: 500px; margin: 10px 0px;\"></iframe>","image_url":"https://cdn-ak.f.st-hatena.com/images/fotolife/k/koogucc11/20160730/20160730161500.jpg","provider_url":"https://hatena.blog","description":"\u4eca\u5e74\u306f 10 \u5e74\u4ee5\u4e0a\u3076\u308a\u306b\u304a\u76c6\u306b\u5e30\u90f7\u3057\u307e\u3059\u3002\u3057\u304b\u3082\u3001\u8eca\u3067\u3002\u3068\u3044\u3046\u3053\u3068\u3067\u8eca\u306e\u7dcf\u70b9\u691c\u4e2d\u3067\u3059\u3002 \u4eca\u56de\u306f SUM \u95a2\u6570\u306e\u4f7f\u3044\u65b9\u3092\u5c11\u3057\u5de5\u592b\u3057\u3066\u307f\u305f\u3044\u3068\u601d\u3044\u307e\u3059\u3002Sales.SalesOrderHeader \u30c6\u30fc\u30d6\u30eb\u3092\u4f7f\u3063\u3066\u3001TerritoryID \u5225\u306e\u6570\u3092\u7b97\u51fa\u3057\u307e\u3059\u3002\u4e0b\u8a18\u306e\u30af\u30a8\u30ea\u3092 SQL Server Management Studio \u3067\u5b9f\u884c\u3057\u3066\u307f\u307e\u3057\u3087\u3046\u3002 SELECT [TerritoryID_is_1] = SUM(CASE WHEN TerritoryID = 1 THEN 1 ELSE 0 END), [TerritoryID_is_2] = SUM(CASE WHEN Territory\u2026","categories":["SQL Server"],"version":"1.0","url":"https://ryuchan.hatenablog.com/entry/2016/07/30/162421"}