{"id":15291,"date":"2022-07-07T06:00:00","date_gmt":"2022-07-06T21:00:00","guid":{"rendered":"https:\/\/www.muscle-hypertrophy.com\/?p=15291"},"modified":"2022-06-29T09:56:26","modified_gmt":"2022-06-29T00:56:26","slug":"%e6%97%a5%e6%9c%80%e9%ab%98%e6%b0%97%e6%b8%a9%e3%81%a8%e7%86%b1%e4%b8%ad%e7%97%87%e3%81%ae%e9%87%8d%e7%97%87%e5%ba%a6%e5%88%a5%e3%81%ae%e6%90%ac%e9%80%81%e6%95%b0%e3%82%92%e6%a4%9c%e8%a8%8e%e3%81%99","status":"publish","type":"post","link":"https:\/\/www.muscle-hypertrophy.com\/?p=15291","title":{"rendered":"\u65e5\u6700\u9ad8\u6c17\u6e29\u3068\u71b1\u4e2d\u75c7\u306e\u91cd\u75c7\u5ea6\u5225\u306e\u642c\u9001\u4eba\u54e1\u6570\u3092\u691c\u8a0e\u3059\u308b"},"content":{"rendered":"\n

\u3000\u71b1\u4e2d\u75c7\u306e\u642c\u9001\u4eba\u54e1\u3068\u6700\u9ad8\u6c17\u6e29\u3068\u306e\u76f8\u95a2\u95a2\u4fc2\u3092\u53ef\u8996\u5316\u3057\u95be\u5024\u3092\u03c7\u4e8c\u4e57\u691c\u5b9a\u3059\u308b<\/a>\u3067\u306f\u65e5\u6700\u9ad8\u6c17\u6e29\u3068\u71b1\u4e2d\u75c7\u642c\u9001\u4eba\u54e1\u3068\u306e\u76f8\u95a2\u95a2\u4fc2\u3092\u53ef\u8996\u5316\u3057\u305f\uff0e\u4eca\u56de\u306f\u71b1\u4e2d\u75c7\u642c\u9001\u4eba\u54e1\u3092\u91cd\u75c7\u5ea6\u5225\u306b\u65e5\u6700\u9ad8\u6c17\u6e29\u3068\u306e\u76f8\u95a2\u95a2\u4fc2\u3092\u53ef\u8996\u5316\u3059\u308b\uff0e<\/p>\n

<\/p>\n

\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9<\/h2>\n

\u3000\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u306f\u524d\u56de\u540c\u69d8\uff0c\u71b1\u4e2d\u75c7\u306e\u642c\u9001\u4eba\u54e1\u3068\u6700\u9ad8\u6c17\u6e29\u3068\u306e\u76f8\u95a2\u95a2\u4fc2\u3092\u53ef\u8996\u5316\u3057\u95be\u5024\u3092\u03c7\u4e8c\u4e57\u691c\u5b9a\u3059\u308b<\/a>\u3067\u4f5c\u6210\u3057\u305f\u3082\u306e\u3092\u4f7f\u7528\u3059\u308b\uff0e\u7dcf\u52d9\u7701\u6d88\u9632\u5e81\u306e\u6551\u6025\u642c\u9001\u72b6\u6cc1<\/a>\u304a\u3088\u3073\u6c17\u8c61\u5e81\u306e\u904e\u53bb\u306e\u6c17\u8c61\u30c7\u30fc\u30bf\u30fb\u30c0\u30a6\u30f3\u30ed\u30fc\u30c9<\/a>\u304b\u3089\u306e\u30c7\u30fc\u30bf\u3092\u3082\u3068\u306b\u3057\u3066\u3044\u308b\uff0e<\/p>\n

\u65e5\u6700\u9ad8\u6c17\u6e29\u3068\u91cd\u75c7\u5ea6\u5225\u306e\u642c\u9001\u4eba\u54e1\u6570\u306e\u7d71\u8a08<\/h2>\n

\u3000\u65e5\u5225\u5e73\u5747\u6c34\u84b8\u6c17\u5727\u3068\u540c\u69d8\uff0c\u65e5\u6700\u9ad8\u6c17\u6e29\u304c\u4e0a\u6607\u3059\u308b\u306b\u3064\u308c\u3066\u3069\u306e\u91cd\u75c7\u5ea6\u3082\u642c\u9001\u4eba\u54e1\u6570\u304c\u6307\u6570\u95a2\u6570\u7684\u306b\u5897\u52a0\u3059\u308b\u50be\u5411\u306b\u3042\u308b\uff0e\u4eca\u56de\u306f\u7e26\u8ef8\u3092\u5bfe\u6570\u3068\u3057\u305f\uff0e\u7247\u5bfe\u6570\u30b0\u30e9\u30d5\u306b\u76f4\u7dda\u304c\u73fe\u308c\u305f\u5834\u5408\u306f\u81ea\u5df1\u7d44\u7e54\u5316\u304c\u8d77\u304d\u3066\u3044\u308b\uff0e\u3053\u306e\u5834\u5408\uff0c\u3042\u308b\u4e00\u5b9a\u4ee5\u4e0a\u306e\u5916\u6c17\u6e29\u306b\u4eba\u4f53\u306f\u8010\u3048\u3089\u308c\u306a\u3044\u3068\u3044\u3046\u9650\u754c\u3092\u793a\u3057\u3066\u3044\u308b\u3082\u306e\u3068\u8003\u3048\u3089\u308c\u308b\uff0e<\/p>\n

\u8efd\u75c7<\/h3>\n
\"\u65e5\u6700\u9ad8\u6c17\u6e29\u3068\u8efd\u75c7\u306e\u642c\u9001\u4eba\u54e1\u6570\"<\/a>
\u65e5\u6700\u9ad8\u6c17\u6e29\u3068\u8efd\u75c7\u306e\u642c\u9001\u4eba\u54e1\u6570<\/figcaption><\/figure>\n

\u4e2d\u7b49\u75c7<\/h3>\n
\"\u65e5\u6700\u9ad8\u6c17\u6e29\u3068\u4e2d\u7b49\u75c7\u306e\u642c\u9001\u4eba\u54e1\u6570\"<\/a>
\u65e5\u6700\u9ad8\u6c17\u6e29\u3068\u4e2d\u7b49\u75c7\u306e\u642c\u9001\u4eba\u54e1\u6570<\/figcaption><\/figure>\n

\u91cd\u75c7<\/h3>\n
\"\u65e5\u6700\u9ad8\u6c17\u6e29\u3068\u91cd\u75c7\u306e\u642c\u9001\u4eba\u54e1\u6570\"<\/a>
\u65e5\u6700\u9ad8\u6c17\u6e29\u3068\u91cd\u75c7\u306e\u642c\u9001\u4eba\u54e1\u6570<\/figcaption><\/figure>\n

\u6b7b\u4ea1<\/h3>\n
\"\u65e5\u6700\u9ad8\u6c17\u6e29\u3068\u6b7b\u4ea1\u306e\u642c\u9001\u4eba\u54e1\u6570\"<\/a>
\u65e5\u6700\u9ad8\u6c17\u6e29\u3068\u6b7b\u4ea1\u306e\u642c\u9001\u4eba\u54e1\u6570<\/figcaption><\/figure>\n

\u30b9\u30c8\u30a2\u30c9\u30d7\u30ed\u30b7\u30fc\u30b8\u30e3<\/h2>\n

\u3000\u4e0b\u8a18\u30b9\u30c8\u30a2\u30c9\u30d7\u30ed\u30b7\u30fc\u30b8\u30e3\u306f\u65e5\u6700\u9ad8\u6c17\u6e29\u3068\u6b7b\u4ea1\u3068\u306e\u56db\u5206\u8868\u3092\u4f5c\u6210\u3059\u308b\u3082\u306e\u3067\u3042\u308b\uff0e\u6b7b\u4ea1\u3092\u8efd\u75c7\uff0c\u4e2d\u7b49\u75c7\uff0c\u91cd\u75c7\u306b\u5165\u308c\u66ff\u3048\u308b\u3068\u305d\u308c\u305e\u308c\u306e\u56db\u5206\u8868\u3092\u4f5c\u6210\u3067\u304d\u308b\uff0e<\/p>\n

CREATE PROCEDURE Temperature_Death\n\t@Temperature int \nAS\nBEGIN\n\tSET NOCOUNT ON;\nSELECT\t@Temperature\tAS '\u95be\u5024'\n,\tSUM(CASE WHEN E.\u6b7b\u4ea1 > 0 AND T.\u65e5\u5225\u6700\u9ad8\u6c17\u6e29 >= @Temperature\tTHEN 1 ELSE 0 END) AS 'a'\n,\tSUM(CASE WHEN E.\u6b7b\u4ea1 = 0 AND T.\u65e5\u5225\u6700\u9ad8\u6c17\u6e29 >= @Temperature\tTHEN 1 ELSE 0 END) AS 'b'\n,\tSUM(CASE WHEN E.\u6b7b\u4ea1 > 0 AND T.\u65e5\u5225\u6700\u9ad8\u6c17\u6e29 < @Temperature\tTHEN 1 ELSE 0 END) AS 'c'\n,\tSUM(CASE WHEN E.\u6b7b\u4ea1 = 0 AND T.\u65e5\u5225\u6700\u9ad8\u6c17\u6e29 < @Temperature\tTHEN 1 ELSE 0 END) AS 'd'\n,\tSUM(CASE WHEN E.\u6b7b\u4ea1 > 0\t\t\t\t\tTHEN 1 ELSE 0 END) AS 'a+c'\n,\tSUM(CASE WHEN E.\u6b7b\u4ea1 = 0\t\t\t\t\tTHEN 1 ELSE 0 END) AS 'b+d'\n,\tSUM(CASE WHEN\tT.\u65e5\u5225\u6700\u9ad8\u6c17\u6e29 >= @Temperature\tTHEN 1 ELSE 0 END) AS 'a+b'\n,\tSUM(CASE WHEN\tT.\u65e5\u5225\u6700\u9ad8\u6c17\u6e29 < @Temperature\tTHEN 1 ELSE 0 END) AS 'c+d'\n,\tCOUNT(*)\t\t\t\t\t\t\t\t\tAS 'N'\nFROM\tdbo.Emergency\tAS E\nINNER\tJOIN\tdbo.Temperature\tAS\tT\nON\tE.\u65e5\u4ed8 = W.\u5e74\u6708\u65e5\nAND\tE.\u90fd\u9053\u5e9c\u770c\u30b3\u30fc\u30c9 = W.\u90fd\u9053\u5e9c\u770c\u30b3\u30fc\u30c9\nEND\nGO<\/pre>\n
\u7d50\u679c<\/h2>\n
\u3000\u91cd\u75c7\u5ea6\u5225\u306eROC, \u95be\u5024\uff0c\u611f\u5ea6\uff0c\u7279\u7570\u5ea6\u3092\u793a\u3059\uff0e<\/p>\n
\u8efd\u75c7<\/h3>\n
\u3000\u8efd\u75c7\u306b\u304a\u3051\u308b\u95be\u5024\u306f28\u2103\uff0c\u611f\u5ea6\u306f0.77, \u7279\u7570\u5ea6\u306f0.72\u3067\u3042\u3063\u305f\uff0e<\/p>\n
\"\u8efd\u75c7\u306e\u65e5\u6700\u9ad8\u6c17\u6e29\u306eROC\"<\/a>
\u8efd\u75c7\u306e\u65e5\u6700\u9ad8\u6c17\u6e29\u306eROC<\/figcaption><\/figure>\n
\u4e2d\u7b49\u75c7<\/h3>\n
\u3000\u4e2d\u7b49\u75c7\u306b\u304a\u3051\u308b\u95be\u5024\u306f29\u2103\uff0c\u611f\u5ea6\u306f0.74, \u7279\u7570\u5ea6\u306f0.74\u3067\u3042\u3063\u305f\uff0e<\/p>\n
\"\u4e2d\u7b49\u75c7\u306e\u65e5\u6700\u9ad8\u6c17\u6e29\u306eROC\"<\/a>
\u4e2d\u7b49\u75c7\u306e\u65e5\u6700\u9ad8\u6c17\u6e29\u306eROC<\/figcaption><\/figure>\n
\u91cd\u75c7<\/h3>\n
\u3000\u91cd\u75c7\u306b\u304a\u3051\u308b\u95be\u5024\u306f31\u2103\uff0c\u611f\u5ea6\u306f0.78\u7279\u7570\u5ea6\u306f0.70\u3067\u3042\u3063\u305f\uff0e<\/p>\n
\"\u91cd\u75c7\u306e\u65e5\u6700\u9ad8\u6c17\u6e29\u306eROC\"<\/a>
\u91cd\u75c7\u306e\u65e5\u6700\u9ad8\u6c17\u6e29\u306eROC<\/figcaption><\/figure>\n
\u6b7b\u4ea1<\/h3>\n
\u3000\u6b7b\u4ea1\u306b\u304a\u3051\u308b\u95be\u5024\u306f32\u2103\uff0c\u611f\u5ea6\u306f0.82, \u7279\u7570\u5ea6\u306f0.73\u3067\u3042\u3063\u305f\uff0e<\/p>\n
\"\u6b7b\u4ea1\u306e\u65e5\u6700\u9ad8\u6c17\u6e29\u306eROC\"<\/a>
\u6b7b\u4ea1\u306e\u65e5\u6700\u9ad8\u6c17\u6e29\u306eROC<\/figcaption><\/figure>\n
\u307e\u3068\u3081<\/h2>\n
\u3000\u8efd\u75c7\u306b\u304a\u3051\u308b\u95be\u5024\u306f28\u2103\uff0c\u611f\u5ea6\u306f0.77, \u7279\u7570\u5ea6\u306f0.72\u3067\u3042\u3063\u305f\uff0e<\/p>\n
\u3000\u4e2d\u7b49\u75c7\u306b\u304a\u3051\u308b\u95be\u5024\u306f29\u2103\uff0c\u611f\u5ea6\u306f0.74, \u7279\u7570\u5ea6\u306f0.74\u3067\u3042\u3063\u305f\uff0e<\/p>\n
\u3000\u91cd\u75c7\u306b\u304a\u3051\u308b\u95be\u5024\u306f31\u2103\uff0c\u611f\u5ea6\u306f0.78\u7279\u7570\u5ea6\u306f0.70\u3067\u3042\u3063\u305f\uff0e<\/p>\n
\u3000\u6b7b\u4ea1\u306b\u304a\u3051\u308b\u95be\u5024\u306f32\u2103\uff0c\u611f\u5ea6\u306f0.82, \u7279\u7570\u5ea6\u306f0.73\u3067\u3042\u3063\u305f\uff0e<\/p>\n
\u3000\u8efd\u75c7\u304b\u3089\u6b7b\u4ea1\u3078\u3068\u91cd\u75c7\u5ea6\u304c\u4e0a\u304c\u308b\u306b\u3064\u308c\u3066\uff0c\u95be\u5024\u304c\u4e0a\u6607\u3057\u3066\u3044\u308b\u306e\u306f\u7406\u89e3\u3067\u304d\u308b\uff0e<\/p>\n","protected":false},"excerpt":{"rendered":"
\u3000\u71b1\u4e2d\u75c7\u306e\u642c\u9001\u4eba\u54e1\u3068\u6700\u9ad8\u6c17\u6e29\u3068\u306e\u76f8\u95a2\u95a2\u4fc2\u3092\u53ef\u8996\u5316\u3057\u95be\u5024\u3092\u03c7\u4e8c\u4e57\u691c\u5b9a\u3059\u308b\u3067\u306f\u65e5\u6700\u9ad8\u6c17\u6e29\u3068\u71b1\u4e2d\u75c7\u642c\u9001\u4eba\u54e1\u3068\u306e\u76f8\u95a2\u95a2\u4fc2\u3092\u53ef\u8996\u5316\u3057\u305f\uff0e\u4eca\u56de\u306f\u71b1\u4e2d\u75c7\u642c\u9001\u4eba\u54e1\u3092\u91cd\u75c7\u5ea6\u5225\u306b\u65e5\u6700\u9ad8\u6c17\u6e29\u3068\u306e\u76f8\u95a2\u95a2\u4fc2\u3092\u53ef\u8996\u5316\u3059\u308b\uff0e<\/p>\n","protected":false},"author":1,"featured_media":15341,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[11702,697,3574,32,11235,1830,5562,11211,11208,11220,5085,11706,11180,11701,11708,11197,5852,11705,661,11707,2862,2893,4424,11221,3622,649,11195,5961,11234,11703,11242,11236,11230,2588,963],"class_list":["post-15291","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-technology","tag-roc","tag-697","tag-3574","tag-32","tag-11235","tag-1830","tag-5562","tag-11211","tag-11208","tag-11220","tag-5085","tag-11706","tag-11180","tag-11701","tag-11708","tag-11197","tag-5852","tag-11705","tag-661","tag-11707","tag-2862","tag-2893","tag-4424","tag-11221","tag-3622","tag-649","tag-11195","tag-5961","tag-11234","tag-11703","tag-11242","tag-11236","tag-11230","tag-2588","tag-963"],"_links":{"self":[{"href":"https:\/\/www.muscle-hypertrophy.com\/index.php?rest_route=\/wp\/v2\/posts\/15291","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.muscle-hypertrophy.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.muscle-hypertrophy.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.muscle-hypertrophy.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.muscle-hypertrophy.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=15291"}],"version-history":[{"count":21,"href":"https:\/\/www.muscle-hypertrophy.com\/index.php?rest_route=\/wp\/v2\/posts\/15291\/revisions"}],"predecessor-version":[{"id":15354,"href":"https:\/\/www.muscle-hypertrophy.com\/index.php?rest_route=\/wp\/v2\/posts\/15291\/revisions\/15354"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.muscle-hypertrophy.com\/index.php?rest_route=\/wp\/v2\/media\/15341"}],"wp:attachment":[{"href":"https:\/\/www.muscle-hypertrophy.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=15291"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.muscle-hypertrophy.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=15291"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.muscle-hypertrophy.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=15291"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}