{"id":18680,"date":"2025-09-18T06:00:00","date_gmt":"2025-09-17T21:00:00","guid":{"rendered":"https:\/\/www.muscle-hypertrophy.com\/?p=18680"},"modified":"2025-09-17T20:17:23","modified_gmt":"2025-09-17T11:17:23","slug":"%e5%85%a8%e5%9b%bd%e3%81%ae%e5%8c%bb%e7%99%82%e6%a9%9f%e9%96%a2%e3%82%b3%e3%83%bc%e3%83%89%e3%82%92%e7%94%9f%e6%88%90%e3%81%99%e3%82%8b","status":"publish","type":"post","link":"https:\/\/www.muscle-hypertrophy.com\/?p=18680","title":{"rendered":"\u533b\u7642\u6a5f\u95a2\u756a\u53f7\uff0c\u533a\u5206\u70b9\u6570\u30b3\u30fc\u30c9\u304b\u3089\u5168\u56fd\u306e\u533b\u7642\u6a5f\u95a2\u30b3\u30fc\u30c9\u3092\u751f\u6210\u3059\u308b"},"content":{"rendered":"\n

\u3000\u5148\u306e\u6295\u7a3f<\/a>\u3067\u306f\u533b\u79d1\u3068\u6b6f\u79d1\u306e\u30d5\u30a1\u30a4\u30eb\u306e\u5206\u985e\u304c\u8aa4\u3063\u3066\u3044\u305f\uff0e\u4eca\u56de\uff0c\u6b63\u3057\u304f\u5206\u985e\u3057\u76f4\u3057\u305f\u306e\u3067\u518d\u5ea6\u6295\u7a3f\u3059\u308b\uff0e<\/p>\n

<\/p>\n

\u533b\u79d1\u306e\u30d5\u30a1\u30a4\u30eb\u306f\u300c\u533b\u79d1\u300d\u304a\u3088\u3073\u300c\u6b6f\u79d1\u4f75\u8a2d\u300d\uff0c\u6b6f\u79d1\u306e\u30d5\u30a1\u30a4\u30eb\u306f\u300c\u6b6f\u79d1\u300d\u304a\u3088\u3073\u300c\u533b\u79d1\u4f75\u8a2d\u300d<\/h2>\n

\u3000\u5148\u306e\u6295\u7a3f\u3067\u306f\u533b\u79d1\u306e\u30d5\u30a1\u30a4\u30eb\u3092\u300c\u533b\u79d1\u300d\u304a\u3088\u3073\u300c\u533b\u79d1\u4f75\u8a2d\u300d\uff0c\u6b6f\u79d1\u306e\u30d5\u30a1\u30a4\u30eb\u3092\u300c\u6b6f\u79d1\u300d\u304a\u3088\u3073\u300c\u6b6f\u79d1\u4f75\u8a2d\u300d\u3068\u5206\u985e\u3057\u3066\u3044\u305f\u304c\uff0c\u8aa4\u308a\u3067\u3042\u3063\u305f\uff0e<\/p>\n

\u3000\u6b63\u3057\u304f\u5206\u985e\u3057\u3066\u5404\u539a\u751f\u5c40<\/a>\u3054\u3068\uff0c\u533b\u79d1\u3068\u6b6f\u79d1\u3054\u3068\u306b\u30d5\u30a9\u30eb\u30c0\u306b\u5206\u3051\u305f\uff0ePower Query\u3067\u305d\u308c\u305e\u308c\u306e\u30d5\u30a9\u30eb\u30c0\u304b\u3089\u30a4\u30f3\u30dd\u30fc\u30c8\u3057\uff0c\u3055\u3089\u306b\u533b\u79d1\u3054\u3068\uff0c\u6b6f\u79d1\u3054\u3068\u306b\u4e00\u3064\u305a\u3064\u306e\u30d5\u30a1\u30a4\u30eb\u306b\u30a4\u30f3\u30dd\u30fc\u30c8\u3057\u305f\uff0e\u8a73\u7d30\u306f\u5168\u56fd\u306e\u533b\u7642\u6a5f\u95a2\u30b3\u30fc\u30c9\u3092\u53d6\u5f97\u3059\u308b<\/a>\u3092\u53c2\u7167\u306e\u3053\u3068\uff0e<\/p>\n

M_DentalInstitution<\/a><\/p>\n

M_MedicalInstitution<\/a><\/p>\n

SQL Server\u306b\u30a4\u30f3\u30dd\u30fc\u30c8<\/h2>\n

\u3000\u30a6\u30a3\u30b6\u30fc\u30c9\u3092\u4f7f\u7528\u3057\u3066SQL Server\u306b\u30a4\u30f3\u30dd\u30fc\u30c8\u3057\u305f\uff0e\u5217\u30de\u30c3\u30d4\u30f3\u30b0\u306f\u4e0b\u56f3\u3092\u53c2\u7167\u306e\u3053\u3068\uff0e<\/p>\n

\"SQL<\/a>
SQL Server\u3078\u306e\u30a4\u30f3\u30dd\u30fc\u30c8\u306b\u304a\u3051\u308b\u5217\u30de\u30c3\u30d4\u30f3\u30b0<\/figcaption><\/figure>\n

\u533b\u7642\u6a5f\u95a2\u30b3\u30fc\u30c9\uff0c\u90fd\u9053\u5e9c\u770c\u306e\u5217\u306e\u4f5c\u6210<\/h2>\n

\u3000M_DentalInstitution\u30c6\u30fc\u30d6\u30eb\u3092\u4f8b\u306b\u8aac\u660e\u3059\u308b\uff0e\u30c6\u30fc\u30d6\u30eb\u3092\u53f3\u30af\u30ea\u30c3\u30af\u3057\u3066\u300c\u30c7\u30b6\u30a4\u30f3\u300d\u3092\u9078\u629e\u3059\u308b\uff0e<\/p>\n

\"\u30c6\u30fc\u30d6\u30eb\u3092\u53f3\u30af\u30ea\u30c3\u30af\u3057\u3066\u300c\u30c7\u30b6\u30a4\u30f3\u300d\u3092\u9078\u629e\"<\/a>
\u30c6\u30fc\u30d6\u30eb\u3092\u53f3\u30af\u30ea\u30c3\u30af\u3057\u3066\u300c\u30c7\u30b6\u30a4\u30f3\u300d\u3092\u9078\u629e<\/figcaption><\/figure>\n

\u3000\u300c\u533b\u7642\u6a5f\u95a2\u30b3\u30fc\u30c9\u300d\u3068\u300c\u90fd\u9053\u5e9c\u770c\u300d\u5217\u3092\u4f5c\u6210\u3059\u308b\uff0e\u30c7\u30fc\u30bf\u578b\u306f\u4e0b\u56f3\u3092\u53c2\u7167\u306e\u3053\u3068\uff0e<\/p>\n

\"\u30c6\u30fc\u30d6\u30eb\u30c7\u30b6\u30a4\u30f3\u3067\u300c\u533b\u7642\u6a5f\u95a2\u30b3\u30fc\u30c9\u300d\u300c\u90fd\u9053\u5e9c\u770c\u300d\u3092\u8ffd\u52a0\"<\/a>
\u30c6\u30fc\u30d6\u30eb\u30c7\u30b6\u30a4\u30f3\u3067\u300c\u533b\u7642\u6a5f\u95a2\u30b3\u30fc\u30c9\u300d\u300c\u90fd\u9053\u5e9c\u770c\u300d\u3092\u8ffd\u52a0<\/figcaption><\/figure>\n

\u90f5\u4fbf\u756a\u53f7\u30c6\u30fc\u30d6\u30eb\u3068\u4e8b\u696d\u6240\u306e\u500b\u5225\u90f5\u4fbf\u756a\u53f7\u30c6\u30fc\u30d6\u30eb\u304b\u3089\u90fd\u9053\u5e9c\u770c\u3068\u5730\u65b9\u516c\u5171\u56e3\u4f53\u30b3\u30fc\u30c9\u3092\u53d6\u5f97\u3057\uff0c\u533b\u7642\u6a5f\u95a2\u30b3\u30fc\u30c9\u3092\u751f\u6210\u3059\u308b<\/h2>\n

\u3000\u4e0b\u8a18\u30af\u30a8\u30ea\u3092\u5b9f\u884c\u3057\u3066\u90f5\u4fbf\u756a\u53f7<\/a>\u30c6\u30fc\u30d6\u30eb\u3068\u4e8b\u696d\u6240\u306e\u500b\u5225\u90f5\u4fbf\u756a\u53f7<\/a>\u30c6\u30fc\u30d6\u30eb\u304b\u3089\u90fd\u9053\u5e9c\u770c\u3068\u5730\u65b9\u516c\u5171\u56e3\u4f53\u30b3\u30fc\u30c9\u3092\u53d6\u5f97\u3057\uff0c\u533a\u5206\u70b9\u6570\u30b3\u30fc\u30c9\uff0c\u533b\u7642\u6a5f\u95a2\u756a\u53f7\u3068\u5408\u308f\u305b\u306610\u6841\u306e\u533b\u7642\u6a5f\u95a2\u30b3\u30fc\u30c9\u3092\u751f\u6210\u3059\u308b\uff0e<\/p>\n

UPDATE  M_DentalInstitution\n--UPDATE\tM_MedicalInstitution\nSET\t\t\u533b\u7642\u6a5f\u95a2\u30b3\u30fc\u30c9 = CASE WHEN LEFT(Z.\u5168\u56fd\u5730\u65b9\u516c\u5171\u56e3\u4f53\u30b3\u30fc\u30c9, 2) + [\u533a\u5206\u70b9\u6570\u30b3\u30fc\u30c9] +[\u533b\u7642\u6a5f\u95a2\u756a\u53f7] IS NULL \n        THEN LEFT(J.\u6240\u5728\u5730\u306eJIS\u30b3\u30fc\u30c9, 2) + [\u533a\u5206\u70b9\u6570\u30b3\u30fc\u30c9] +[\u533b\u7642\u6a5f\u95a2\u756a\u53f7]\n        ELSE LEFT(Z.\u5168\u56fd\u5730\u65b9\u516c\u5171\u56e3\u4f53\u30b3\u30fc\u30c9, 2) + [\u533a\u5206\u70b9\u6570\u30b3\u30fc\u30c9] +[\u533b\u7642\u6a5f\u95a2\u756a\u53f7] END\n    ,   \u90fd\u9053\u5e9c\u770c = CASE WHEN Z.\u90fd\u9053\u5e9c\u770c\u540d IS NULL THEN J.\u90fd\u9053\u5e9c\u770c\u540d ELSE Z.\u90fd\u9053\u5e9c\u770c\u540d END\nFROM    dbo.M_DentalInstitution AS M\n--FROM\tdbo.M_MedicalInstitution\tAS M\nLEFT\tJOIN\tdbo.M_ZIPCODE\tAS Z\nON\t\tM.\u90f5\u4fbf\u756a\u53f7 = Z.\u90f5\u4fbf\u756a\u53f7\nLEFT\tJOIN\tdbo.M_JIGYOSYO\tAS J\nON\t\tM.\u90f5\u4fbf\u756a\u53f7 = J.\u5927\u53e3\u4e8b\u696d\u6240\u500b\u5225\u756a\u53f7<\/pre>\n
(63582 \u884c\u306b\u5f71\u97ff\u3057\u307e\u3057\u305f)<\/pre>\n
\u3000\u3055\u3089\u306b\u6b21\u306e\u30af\u30a8\u30ea\u3092\u5b9f\u884c\u3057\u3066\u6b8b\u308a\u306e\u30ec\u30b3\u30fc\u30c9\u3092\u66f4\u65b0\u3059\u308b\uff0e<\/p>\n
WITH    UNKNOWNZIP\nAS\n(\nSELECT CASE WHEN LEFT(Z.\u5168\u56fd\u5730\u65b9\u516c\u5171\u56e3\u4f53\u30b3\u30fc\u30c9, 2) + [\u533a\u5206\u70b9\u6570\u30b3\u30fc\u30c9] +[\u533b\u7642\u6a5f\u95a2\u756a\u53f7] IS NULL \n       THEN LEFT(J.\u6240\u5728\u5730\u306eJIS\u30b3\u30fc\u30c9, 2) + [\u533a\u5206\u70b9\u6570\u30b3\u30fc\u30c9] +[\u533b\u7642\u6a5f\u95a2\u756a\u53f7]\n       ELSE LEFT(Z.\u5168\u56fd\u5730\u65b9\u516c\u5171\u56e3\u4f53\u30b3\u30fc\u30c9, 2) + [\u533a\u5206\u70b9\u6570\u30b3\u30fc\u30c9] +[\u533b\u7642\u6a5f\u95a2\u756a\u53f7] END  AS '\u533b\u7642\u6a5f\u95a2\u30b3\u30fc\u30c9'\n       ,M.\u533a\u5206\u70b9\u6570\u30b3\u30fc\u30c9\n       ,M.\u533b\u7642\u6a5f\u95a2\u756a\u53f7\n       ,[\u533b\u7642\u6a5f\u95a2\u540d]\n       ,M.[\u90f5\u4fbf\u756a\u53f7]\n       ,Z.\u90fd\u9053\u5e9c\u770c\u540d\n       ,M.\u6240\u5728\u5730\n--  FROM  dbo.M_MedicalInstitution    AS M\n  FROM [dbo].[M_DentalInstitution] AS M\n  LEFT  JOIN    dbo.M_ZIPCODE   AS Z\n  ON    M.\u90f5\u4fbf\u756a\u53f7 = Z.\u90f5\u4fbf\u756a\u53f7\n  LEFT  JOIN    dbo.M_JIGYOSYO  AS J\n  ON    M.\u90f5\u4fbf\u756a\u53f7 = J.\u5927\u53e3\u4e8b\u696d\u6240\u500b\u5225\u756a\u53f7\n  WHERE CASE WHEN LEFT(Z.\u5168\u56fd\u5730\u65b9\u516c\u5171\u56e3\u4f53\u30b3\u30fc\u30c9, 2) + [\u533a\u5206\u70b9\u6570\u30b3\u30fc\u30c9] +[\u533b\u7642\u6a5f\u95a2\u756a\u53f7] IS NULL \n       THEN LEFT(J.\u6240\u5728\u5730\u306eJIS\u30b3\u30fc\u30c9, 2) + [\u533a\u5206\u70b9\u6570\u30b3\u30fc\u30c9] +[\u533b\u7642\u6a5f\u95a2\u756a\u53f7]\n       ELSE LEFT(Z.\u5168\u56fd\u5730\u65b9\u516c\u5171\u56e3\u4f53\u30b3\u30fc\u30c9, 2) + [\u533a\u5206\u70b9\u6570\u30b3\u30fc\u30c9] +[\u533b\u7642\u6a5f\u95a2\u756a\u53f7] END IS NULL\n), \nCTE(ZIPCODE, PREF, LGCODE)\nAS\n(\nSELECT  UNKNOWNZIP.\u90f5\u4fbf\u756a\u53f7\n    ,   MAX(Z.\u90fd\u9053\u5e9c\u770c\u540d)\n    ,   LEFT(MAX(Z.\u5168\u56fd\u5730\u65b9\u516c\u5171\u56e3\u4f53\u30b3\u30fc\u30c9), 2)\nFROM    dbo.M_ZIPCODE   AS Z\nINNER   JOIN    UNKNOWNZIP\nON      LEFT(Z.\u90f5\u4fbf\u756a\u53f7, 3) = LEFT(UNKNOWNZIP.\u90f5\u4fbf\u756a\u53f7, 3)\nGROUP   BY  LEFT(Z.\u90f5\u4fbf\u756a\u53f7, 3), UNKNOWNZIP.\u90f5\u4fbf\u756a\u53f7\n)\nUPDATE  M\nSET     \u533b\u7642\u6a5f\u95a2\u30b3\u30fc\u30c9 = CTE.LGCODE + M.\u533a\u5206\u70b9\u6570\u30b3\u30fc\u30c9 + M.\u533b\u7642\u6a5f\u95a2\u756a\u53f7\n    ,   \u90fd\u9053\u5e9c\u770c = CTE.PREF\n--FROM    dbo.M_MedicalInstitution AS M\nFROM    dbo.M_DentalInstitution AS M\nINNER   JOIN    CTE\nON  M.\u90f5\u4fbf\u756a\u53f7 = CTE.ZIPCODE<\/pre>\n
(9 \u884c\u306b\u5f71\u97ff\u3057\u307e\u3057\u305f)<\/pre>\n
\u3000\u533b\u79d1\u306e\u5834\u5408\uff0c\u884c\u6570\u306f\u307e\u305f\u5909\u5316\u3059\u308b\uff0e<\/p>\n
(93144 \u884c\u306b\u5f71\u97ff\u3057\u307e\u3057\u305f)<\/pre>\n
(39 \u884c\u306b\u5f71\u97ff\u3057\u307e\u3057\u305f)<\/pre>\n
\u91cd\u8907\u3057\u3066\u3044\u308b\u30ec\u30b3\u30fc\u30c9\u3092\u62bd\u51fa\u3057\u524a\u9664\u3059\u308b<\/h2>\n
\u3000\u4e0b\u8a18\u306e\u30af\u30a8\u30ea\u3092\u5b9f\u884c\u3057\u3066\u91cd\u8907\u3057\u3066\u3044\u308b\u30ec\u30b3\u30fc\u30c9\u3092\u62bd\u51fa\u3059\u308b\uff0e<\/p>\n
SELECT\tM.\u533b\u7642\u6a5f\u95a2\u30b3\u30fc\u30c9\n\t,\tCOUNT(*)\n\t,\tMAX(M.\u533b\u7642\u6a5f\u95a2\u540d)\n\t,\tMIN(M.\u533b\u7642\u6a5f\u95a2\u540d)\nFROM\tdbo.M_DentalInstitution AS M\nGROUP\tBY M.\u533b\u7642\u6a5f\u95a2\u30b3\u30fc\u30c9\nHAVING\tCOUNT(*) > 1<\/pre>\n
(44 \u884c\u306b\u5f71\u97ff\u3057\u307e\u3057\u305f)<\/pre>\n
1130404467\t2\t\u3042\u3084\u30af\u30ea\u30cb\u30c3\u30af\u3000\u6b6f\u79d1\u30fb\u76ae\u3075\u79d1\t\u3042\u3084\u30af\u30ea\u30cb\u30c3\u30af\u3000\u6b6f\u79d1\u30fb\u76ae\u3075\u79d1\n1130602631\t2\t\u30b0\u30ec\u30fc\u30b9\u30c7\u30f3\u30bf\u30eb\u30e1\u30c7\u30a3\u30ab\u30eb\u30af\u30ea\u30cb\u30c3\u30af\u3000\u57fc\u7389\u6771\u5206\u9662\t\u30b0\u30ec\u30fc\u30b9\u30c7\u30f3\u30bf\u30eb\u30e1\u30c7\u30a3\u30ab\u30eb\u30af\u30ea\u30cb\u30c3\u30af\u3000\u57fc\u7389\u6771\u5206\u9662\n0435135447\t2\t\u56fd\u5bb6\u516c\u52d9\u54e1\u5171\u6e08\u7d44\u5408\u9023\u5408\u4f1a\u6771\u5317\u516c\u6e08\u75c5\u9662\u3000\u4ed9\u53f0\u5408\u540c\u5e81\u820e\u8a3a\u7642\u6240\t\u56fd\u5bb6\u516c\u52d9\u54e1\u5171\u6e08\u7d44\u5408\u9023\u5408\u4f1a\u6771\u5317\u516c\u6e08\u75c5\u9662\u3000\u4ed9\u53f0\u5408\u540c\u5e81\u820e\u8a3a\u7642\u6240\n0435430566\t2\t\u4ed9\u53f0\u5e02\u79cb\u4fdd\u8a3a\u7642\u6240\t\u4ed9\u53f0\u5e02\u79cb\u4fdd\u8a3a\u7642\u6240\n1433030392\t2\t\u30bb\u30f3\u30c8\u30bc\u30d3\u30a2\u30af\u30ea\u30cb\u30c3\u30af\t\u30bb\u30f3\u30c8\u30bc\u30d3\u30a2\u30af\u30ea\u30cb\u30c3\u30af\n1433640885\t2\t\u5c71\u624b\u53f0\u30af\u30ea\u30cb\u30c3\u30af\t\u5c71\u624b\u53f0\u30af\u30ea\u30cb\u30c3\u30af\n1439803206\t2\t\u4e09\u6d66\u3057\u3089\u3068\u308a\u5712\u8a3a\u7642\u6240\t\u4e09\u6d66\u3057\u3089\u3068\u308a\u5712\u8a3a\u7642\u6240\n0830630968\t2\t\u539f\u7530\u533b\u9662\u6b6f\u79d1\u5185\u79d1\t\u539f\u7530\u533b\u9662\u6b6f\u79d1\u5185\u79d1\n0834430886\t2\t\u533b\u7642\u6cd5\u4eba\u793e\u56e3\u6d0b\u5149\u4f1a\u3000\u5354\u548c\u30ac\u30fc\u30c7\u30f3\u30af\u30ea\u30cb\u30c3\u30af\t\u533b\u7642\u6cd5\u4eba\u793e\u56e3\u6d0b\u5149\u4f1a\u3000\u5354\u548c\u30ac\u30fc\u30c7\u30f3\u30af\u30ea\u30cb\u30c3\u30af\n1430601732\t2\t\u4fdd\u571f\u30b1\u8c37\u30af\u30ea\u30cb\u30c3\u30af\t\u4fdd\u571f\u30b1\u8c37\u30af\u30ea\u30cb\u30c3\u30af\n1432630952\t2\t\u30a2\u30a4\u30ea\u30b9\u30c7\u30f3\u30bf\u30eb\u30fb\u30e1\u30c7\u30a3\u30ab\u30eb\t\u30a2\u30a4\u30ea\u30b9\u30c7\u30f3\u30bf\u30eb\u30fb\u30e1\u30c7\u30a3\u30ab\u30eb\n1433030236\t2\t\u30bb\u30f3\u30c8\u30eb\u30ab\u773c\u79d1\u6b6f\u79d1\u30af\u30ea\u30cb\u30c3\u30af\t\u30bb\u30f3\u30c8\u30eb\u30ab\u773c\u79d1\u6b6f\u79d1\u30af\u30ea\u30cb\u30c3\u30af\n1435030523\t2\t\u5ddd\u5d0e\u99c5\uff24\uff06\uff24\u30af\u30ea\u30cb\u30c3\u30af\u6b6f\u79d1\u76ae\u819a\u79d1\t\u5ddd\u5d0e\u99c5\uff24\uff06\uff24\u30af\u30ea\u30cb\u30c3\u30af\u6b6f\u79d1\u76ae\u819a\u79d1\n0435135231\t2\t\u30bb\u30eb\u30d7\u30ed\u30b1\u30a2\u30c7\u30f3\u30bf\u30eb\u30af\u30ea\u30cb\u30c3\u30af\u6f22\u65b9\u5185\u79d1\t\u30bb\u30eb\u30d7\u30ed\u30b1\u30a2\u30c7\u30f3\u30bf\u30eb\u30af\u30ea\u30cb\u30c3\u30af\u6f22\u65b9\u5185\u79d1\n1130404368\t2\t\u30b0\u30ec\u30fc\u30b9\u30c7\u30f3\u30bf\u30eb\u30e1\u30c7\u30a3\u30ab\u30eb\u30af\u30ea\u30cb\u30c3\u30af\u3000\u57fc\u7389\u5206\u9662\t\u30b0\u30ec\u30fc\u30b9\u30c7\u30f3\u30bf\u30eb\u30e1\u30c7\u30a3\u30ab\u30eb\u30af\u30ea\u30cb\u30c3\u30af\u3000\u57fc\u7389\u5206\u9662\n1432130474\t2\t\u30b0\u30ec\u30fc\u30b9\u30c7\u30f3\u30bf\u30eb\u30e1\u30c7\u30a3\u30ab\u30eb\u30af\u30ea\u30cb\u30c3\u30af\u3000\u938c\u5009\u5206\u9662\t\u30b0\u30ec\u30fc\u30b9\u30c7\u30f3\u30bf\u30eb\u30e1\u30c7\u30a3\u30ab\u30eb\u30af\u30ea\u30cb\u30c3\u30af\u3000\u938c\u5009\u5206\u9662\n1432330454\t2\t\u30b0\u30ec\u30fc\u30b9\u30c7\u30f3\u30bf\u30eb\u30e1\u30c7\u30a3\u30ab\u30eb\u30af\u30ea\u30cb\u30c3\u30af\u5c0f\u7530\u539f\u5206\u9662\t\u30b0\u30ec\u30fc\u30b9\u30c7\u30f3\u30bf\u30eb\u30e1\u30c7\u30a3\u30ab\u30eb\u30af\u30ea\u30cb\u30c3\u30af\u5c0f\u7530\u539f\u5206\u9662\n1434200291\t2\t\u3055\u3064\u304b\u308f\u533b\u9662\t\u3055\u3064\u304b\u308f\u533b\u9662\n1537131086\t2\t\u4e0a\u6240\u6b6f\u79d1\u8033\u9f3b\u79d1\t\u4e0a\u6240\u6b6f\u79d1\u8033\u9f3b\u79d1\n1231031194\t2\t\u533b\u7642\u6cd5\u4eba\u793e\u56e3\u53f2\u7965\u4f1a\u3000\u623f\u7dcf\u30e1\u30c7\u30a3\u30ab\u30eb\u30af\u30ea\u30cb\u30c3\u30af\t\u533b\u7642\u6cd5\u4eba\u793e\u56e3\u53f2\u7965\u4f1a\u3000\u623f\u7dcf\u30e1\u30c7\u30a3\u30ab\u30eb\u30af\u30ea\u30cb\u30c3\u30af\n1232136216\t2\t\u67cf\u4e94\u5473\u6b6f\u79d1\u5185\u79d1\u30af\u30ea\u30cb\u30c3\u30af\t\u67cf\u4e94\u5473\u6b6f\u79d1\u5185\u79d1\u30af\u30ea\u30cb\u30c3\u30af\n1232331668\t2\t\u30b0\u30ec\u30fc\u30b9\u30c7\u30f3\u30bf\u30eb\u30e1\u30c7\u30a3\u30ab\u30eb\u30af\u30ea\u30cb\u30c3\u30af\u3000\u5343\u8449\u5206\u9662\t\u30b0\u30ec\u30fc\u30b9\u30c7\u30f3\u30bf\u30eb\u30e1\u30c7\u30a3\u30ab\u30eb\u30af\u30ea\u30cb\u30c3\u30af\u3000\u5343\u8449\u5206\u9662\n1431930361\t2\t\u795e\u5948\u5ddd\u6b6f\u79d1\u5927\u5b66\u9644\u5c5e\u75c5\u9662\t\u795e\u5948\u5ddd\u6b6f\u79d1\u5927\u5b66\u9644\u5c5e\u75c5\u9662\n1432230373\t2\t\u30b0\u30ec\u30fc\u30b9\u30c7\u30f3\u30bf\u30eb\u30e1\u30c7\u30a3\u30ab\u30eb\u30af\u30ea\u30cb\u30c3\u30af\u3000\u6e58\u5357\u5206\u9662\t\u30b0\u30ec\u30fc\u30b9\u30c7\u30f3\u30bf\u30eb\u30e1\u30c7\u30a3\u30ab\u30eb\u30af\u30ea\u30cb\u30c3\u30af\u3000\u6e58\u5357\u5206\u9662\n1433330289\t2\t\u30b0\u30ec\u30fc\u30b9\u30c7\u30f3\u30bf\u30eb\u30e1\u30c7\u30a3\u30ab\u30eb\u30af\u30ea\u30cb\u30c3\u30af\u3000\u6a2a\u6d5c\u5206\u9662\t\u30b0\u30ec\u30fc\u30b9\u30c7\u30f3\u30bf\u30eb\u30e1\u30c7\u30a3\u30ab\u30eb\u30af\u30ea\u30cb\u30c3\u30af\u3000\u6a2a\u6d5c\u5206\u9662\n1433830395\t2\t\u30b3\u30f3\u30d1\u30b9\u5185\u79d1\u6b6f\u79d1\u30af\u30ea\u30cb\u30c3\u30af\u90fd\u7b51\u30bb\u30f3\u30bf\u30fc\u5357\t\u30b3\u30f3\u30d1\u30b9\u5185\u79d1\u6b6f\u79d1\u30af\u30ea\u30cb\u30c3\u30af\u90fd\u7b51\u30bb\u30f3\u30bf\u30fc\u5357\n1132901056\t2\t\u4f0a\u52e2\u533b\u79d1\u6b6f\u79d1\u30af\u30ea\u30cb\u30c3\u30af\t\u4f0a\u52e2\u533b\u79d1\u6b6f\u79d1\u30af\u30ea\u30cb\u30c3\u30af\n1136530786\t2\t\u30b0\u30ec\u30fc\u30b9\u30c7\u30f3\u30bf\u30eb\u30e1\u30c7\u30a3\u30ab\u30eb\u30af\u30ea\u30cb\u30c3\u30af\u3000\u5927\u5bae\u5206\u9662\t\u30b0\u30ec\u30fc\u30b9\u30c7\u30f3\u30bf\u30eb\u30e1\u30c7\u30a3\u30ab\u30eb\u30af\u30ea\u30cb\u30c3\u30af\u3000\u5927\u5bae\u5206\u9662\n1430342048\t2\t\u8aa0\u656c\u4f1a\u30af\u30ea\u30cb\u30c3\u30af\t\u8aa0\u656c\u4f1a\u30af\u30ea\u30cb\u30c3\u30af\n1430342121\t2\t\u77f3\u5ddd\u533b\u9662\t\u77f3\u5ddd\u533b\u9662\n1432342699\t2\t\u753a\u7530\u533b\u79d1\u6b6f\u79d1\u8a3a\u7642\u6240\t\u753a\u7530\u533b\u79d1\u6b6f\u79d1\u8a3a\u7642\u6240\n1432647394\t2\t\u533b\u7642\u6cd5\u4eba\u793e\u56e3\u88d5\u4eba\u4f1a\u3000\u30df\u30ca\u30df\u30af\u30ea\u30cb\u30c3\u30af\t\u533b\u7642\u6cd5\u4eba\u793e\u56e3\u88d5\u4eba\u4f1a\u3000\u30df\u30ca\u30df\u30af\u30ea\u30cb\u30c3\u30af\n0832131288\t2\t\u4e09\u53cb\u6b6f\u79d1\u8033\u9f3b\u54bd\u5589\u79d1\t\u4e09\u53cb\u6b6f\u79d1\u8033\u9f3b\u54bd\u5589\u79d1\n1133101342\t2\t\u533b\u7642\u6cd5\u4eba\u3000\u6804\u5b8f\u4f1a\u3000\uff12\uff18\uff23\uff4c\uff49\uff4e\uff49\uff23\u91ce\u4e0a\u6b6f\u79d1\u533b\u9662\t\u533b\u7642\u6cd5\u4eba\u3000\u6804\u5b8f\u4f1a\u3000\uff12\uff18\uff23\uff4c\uff49\uff4e\uff49\uff23\u91ce\u4e0a\u6b6f\u79d1\u533b\u9662\n1136530141\t2\t\u30b7\u30f3\u30dd\u6b6f\u79d1\u30af\u30ea\u30cb\u30c3\u30af\u6d66\u548c\t\u30b7\u30f3\u30dd\u6b6f\u79d1\u30af\u30ea\u30cb\u30c3\u30af\u6d66\u548c\n1430101691\t2\t\u9db4\u898b\u5927\u5b66\u6b6f\u5b66\u90e8\u9644\u5c5e\u75c5\u9662\t\u9db4\u898b\u5927\u5b66\u6b6f\u5b66\u90e8\u9644\u5c5e\u75c5\u9662\n1432230001\t2\t\u30b3\u30f3\u30d1\u30b9\u5185\u79d1\u6b6f\u79d1\u30af\u30ea\u30cb\u30c3\u30af\u85e4\u6ca2\u6e58\u5357\u53f0\t\u30b3\u30f3\u30d1\u30b9\u5185\u79d1\u6b6f\u79d1\u30af\u30ea\u30cb\u30c3\u30af\u85e4\u6ca2\u6e58\u5357\u53f0\n1435043211\t2\t\u5c0f\u6797\u6574\u5f62\u5916\u79d1\u6b6f\u79d1\u533b\u9662\t\u5c0f\u6797\u6574\u5f62\u5916\u79d1\u6b6f\u79d1\u533b\u9662\n1530131224\t2\t\u65e5\u672c\u6b6f\u79d1\u5927\u5b66\u65b0\u6f5f\u75c5\u9662\t\u65e5\u672c\u6b6f\u79d1\u5927\u5b66\u65b0\u6f5f\u75c5\u9662\n1136503742\t2\t\u5409\u898b\u533b\u79d1\u6b6f\u79d1\u30af\u30ea\u30cb\u30c3\u30af\t\u5409\u898b\u533b\u79d1\u6b6f\u79d1\u30af\u30ea\u30cb\u30c3\u30af\n1136509657\t2\t\u30c6\u30a3\u30fc\u30a8\u30e0\u6b6f\u79d1\u533b\u9662\t\u30c6\u30a3\u30fc\u30a8\u30e0\u6b6f\u79d1\u533b\u9662\n1234730487\t2\t\u30b0\u30ec\u30fc\u30b9\u30c7\u30f3\u30bf\u30eb\u30e1\u30c7\u30a3\u30ab\u30eb\u30af\u30ea\u30cb\u30c3\u30af\u3000\u5317\u7dcf\u5206\u9662\t\u30b0\u30ec\u30fc\u30b9\u30c7\u30f3\u30bf\u30eb\u30e1\u30c7\u30a3\u30ab\u30eb\u30af\u30ea\u30cb\u30c3\u30af\u3000\u5317\u7dcf\u5206\u9662\n1430243352\t2\t\u795e\u5948\u5ddd\u6b6f\u79d1\u5927\u5b66\u9644\u5c5e\u6a2a\u6d5c\u30af\u30ea\u30cb\u30c3\u30af\t\u795e\u5948\u5ddd\u6b6f\u79d1\u5927\u5b66\u9644\u5c5e\u6a2a\u6d5c\u30af\u30ea\u30cb\u30c3\u30af\n1431043314\t2\t\u533b\u7642\u6cd5\u4eba\u793e\u56e3\u3000\u6728\u539f\u4f1a\u3000\u6728\u539f\u6b6f\u79d1\u30fb\u5185\u79d1\u533b\u9662\t\u533b\u7642\u6cd5\u4eba\u793e\u56e3\u3000\u6728\u539f\u4f1a\u3000\u6728\u539f\u6b6f\u79d1\u30fb\u5185\u79d1\u533b\u9662<\/pre>\n
\u3000\u898b\u305f\u3068\u3053\u308d\uff0c\u5b8c\u5168\u306b\u91cd\u8907\u3057\u3066\u3044\u308b\u3088\u3046\u306b\u898b\u3048\u308b\uff0e\u3053\u306e\u5834\u5408\uff0c\u91cd\u8907\u30ec\u30b3\u30fc\u30c9\u306e\u524a\u9664\u304c\u5fc5\u8981\u3067\u3042\u308b\uff0e\u5ff5\u306e\u70ba\u5b8c\u5168\u306b\u91cd\u8907\u3057\u3066\u3044\u308b\u304b\u78ba\u8a8d\u3057\u3066\u307f\u308b\uff0e<\/p>\n
SELECT\tM.\u533b\u7642\u6a5f\u95a2\u30b3\u30fc\u30c9\n\t,\tCOUNT(*)\n\t,\tMAX(M.\u533b\u7642\u6a5f\u95a2\u540d)\n\t,\tMIN(M.\u533b\u7642\u6a5f\u95a2\u540d)\nFROM\tdbo.M_DentalInstitution AS M\nGROUP\tBY M.\u533b\u7642\u6a5f\u95a2\u30b3\u30fc\u30c9\nHAVING\tCOUNT(*) > 1\nAND\tMAX(M.\u533b\u7642\u6a5f\u95a2\u540d) > MIN(M.\u533b\u7642\u6a5f\u95a2\u540d)<\/pre>\n
(0 \u884c\u306b\u5f71\u97ff\u3057\u307e\u3057\u305f)<\/pre>\n
\u3000\u5b8c\u5168\u306b\u91cd\u8907\u3057\u3066\u3044\u308b\u3088\u3046\u3067\u3042\u308b\uff0e\u4f59\u8ac7\u3067\u3042\u308b\u304c\uff0c\u3082\u3057\u4e0a\u8a18\u306e\u30af\u30a8\u30ea\u3067\u306a\u306b\u304b\u304c\u62bd\u51fa\u3055\u308c\u3066\u304d\u305f\u3089\uff0c\u30b3\u30fc\u30c9\u4f53\u7cfb\u304c\u7834\u7dbb\u3057\u3066\u3044\u308b\u3053\u3068\u3092\u610f\u5473\u3059\u308b\uff0e\u5730\u65b9\u539a\u751f\u5c40\u306b\u901a\u5831\u3057\u306a\u3051\u308c\u3070\u306a\u3089\u306a\u3044\u6848\u4ef6\u3067\u3042\u308b\uff0e<\/p>\n
\u3000\u3067\u306f\u6b21\u306e\u30af\u30a8\u30ea\u3092\u5b9f\u884c\u3057\u3066\u91cd\u8907\u3057\u3066\u3044\u308b\u30ec\u30b3\u30fc\u30c9\u3092\u524a\u9664\u3057\u3088\u3046\uff0e<\/p>\n
WITH CTE AS (\n  SELECT\n    *,\n    ROW_NUMBER() OVER(PARTITION BY M.\u533b\u7642\u6a5f\u95a2\u30b3\u30fc\u30c9 ORDER BY (SELECT 0)) AS rn\n  FROM\n    --dbo.M_MedicalInstitution    AS M\n    dbo.M_DentalInstitution AS M\n)\nDELETE \n--SELECT  *\nFROM\n  CTE\nWHERE\n  rn > 1<\/pre>\n
(44 \u884c\u306b\u5f71\u97ff\u3057\u307e\u3057\u305f)<\/pre>\n
\u3000\u533b\u79d1\u3067\u306f\u6b21\u306e\u3088\u3046\u3067\u3042\u308b\uff0e<\/p>\n
(569 \u884c\u306b\u5f71\u97ff\u3057\u307e\u3057\u305f)<\/pre>\n
\u307e\u3068\u3081<\/h2>\n
\u3000\u5168\u56fd\u306e\u5730\u65b9\u539a\u751f\u5c40\u304b\u3089\u533b\u79d1\uff0c\u6b6f\u79d1\u306e\u30d5\u30a1\u30a4\u30eb\u3092\u30c0\u30a6\u30f3\u30ed\u30fc\u30c9\u3057\u3066\uff0c\u5730\u65b9\u516c\u5171\u56e3\u4f53\u30b3\u30fc\u30c9\uff0c\u533a\u5206\u70b9\u6570\u30b3\u30fc\u30c9\u304a\u3088\u3073\u533b\u7642\u6a5f\u95a2\u756a\u53f7\u304b\u3089\u533b\u7642\u6a5f\u95a2\u30b3\u30fc\u30c9\u3092\u751f\u6210\u3057\u305f\uff0e\u5b8c\u5168\u306a\u91cd\u8907\u4ee5\u5916\uff0c\u30b3\u30fc\u30c9\u4f53\u7cfb\u306b\u81f4\u547d\u7684\u306a\u91cd\u8907\u306f\u8a8d\u3081\u3089\u308c\u306a\u304b\u3063\u305f\uff0e<\/p>\n
\u3000\u306a\u304a\uff0c\u30c0\u30a6\u30f3\u30ed\u30fc\u30c9\u3057\u305f\u30d5\u30a1\u30a4\u30eb\u306f2025\u5e749\u67081\u65e5\u6642\u70b9\u306e\u3082\u306e\u3067\u3042\u308b\uff0e<\/p>\n","protected":false},"excerpt":{"rendered":"
\u3000\u5148\u306e\u6295\u7a3f\u3067\u306f\u533b\u79d1\u3068\u6b6f\u79d1\u306e\u30d5\u30a1\u30a4\u30eb\u306e\u5206\u985e\u304c\u8aa4\u3063\u3066\u3044\u305f\uff0e\u4eca\u56de\uff0c\u6b63\u3057\u304f\u5206\u985e\u3057\u76f4\u3057\u305f\u306e\u3067\u518d\u5ea6\u6295\u7a3f\u3059\u308b\uff0e<\/p>\n","protected":false},"author":1,"featured_media":18578,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[6748,5659,4698,3561,3562,4673,1030,4000,11219,5413,7095,11264,11265,4674,11266,11267,4067,14000,4672,4657,2740,3560,6392,3557,4658,1152,13999,4282,1806,13971,13970,13972,13983,12108,13973,13984,2723,2919],"class_list":["post-18680","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-technology","tag-as","tag-case","tag-delete","tag-else","tag-end","tag-from","tag-group-by","tag-inner-join","tag-is-null","tag-left","tag-left-join","tag-max","tag-min","tag-order-by","tag-over","tag-partition-by","tag-power-query","tag-row_number","tag-select","tag-set","tag-sql-server","tag-then","tag-update","tag-when","tag-with","tag-1152","tag-13999","tag-4282","tag-1806","tag-13971","tag-13970","tag-13972","tag-13983","tag-12108","tag-13973","tag-13984","tag-2723","tag-2919"],"_links":{"self":[{"href":"https:\/\/www.muscle-hypertrophy.com\/index.php?rest_route=\/wp\/v2\/posts\/18680","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=18680"}],"version-history":[{"count":17,"href":"https:\/\/www.muscle-hypertrophy.com\/index.php?rest_route=\/wp\/v2\/posts\/18680\/revisions"}],"predecessor-version":[{"id":18704,"href":"https:\/\/www.muscle-hypertrophy.com\/index.php?rest_route=\/wp\/v2\/posts\/18680\/revisions\/18704"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.muscle-hypertrophy.com\/index.php?rest_route=\/wp\/v2\/media\/18578"}],"wp:attachment":[{"href":"https:\/\/www.muscle-hypertrophy.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=18680"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.muscle-hypertrophy.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=18680"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.muscle-hypertrophy.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=18680"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}