{"id":676,"date":"2012-09-07T14:07:36","date_gmt":"2012-09-07T05:07:36","guid":{"rendered":"http:\/\/auctionpro.co.kr\/?p=676"},"modified":"2017-03-22T11:09:33","modified_gmt":"2017-03-22T02:09:33","slug":"%ec%9b%94%eb%b3%84-%ed%8b%b0%ec%bc%93-%ea%b0%9c%ec%88%98-%ed%95%a9-ms-sql-query","status":"publish","type":"post","link":"https:\/\/www.auctionpro.co.kr\/?p=676","title":{"rendered":"\uc6d4\ubcc4 \ud2f0\ucf13 \uac1c\uc218 \ud569  MS SQL  Query"},"content":{"rendered":"<p>\uc6d4\ubcc4 \ud2f0\ucf13 \uac1c\uc218 \ud569 MS SQL Query<\/p>\n<pre class=\"prettyprint\">\r\nSELECT DATEPART(yyyy,Issue_Date) AS Year\r\n,MAX(DATENAME(mm,Issue_Date)) AS \u00a0Month\r\n,MAX(DATENAME(dd,Issue_Date)) AS \u00a0DATE\r\n,SUM(COALESCE(GO_TKTCNT,0)) AS \u00a0TICKET\r\nFROM [dbo].[FF_DB]\r\nwhere \u00a0Regi_Date&gt;'2013-01-01'\r\nGROUP BY DATEPART(yyyy,Issue_Date),\r\nDATEPART(mm,Issue_Date),\r\nDATEPART(dd,Issue_Date)\r\nORDER BY DATEPART(yyyy,Issue_Date),DATEPART(mm,Issue_Date)\r\n<\/pre>\n","protected":false},"excerpt":{"rendered":"<div class=\"mh-excerpt\"><p>\uc6d4\ubcc4 \ud2f0\ucf13 \uac1c\uc218 \ud569 MS SQL Query SELECT DATEPART(yyyy,Issue_Date) AS Year ,MAX(DATENAME(mm,Issue_Date)) AS \u00a0Month ,MAX(DATENAME(dd,Issue_Date)) AS \u00a0DATE ,SUM(COALESCE(GO_TKTCNT,0)) AS \u00a0TICKET FROM [dbo].[FF_DB] where \u00a0Regi_Date&gt;&#8217;2013-01-01&#8242; GROUP <a class=\"mh-excerpt-more\" href=\"https:\/\/www.auctionpro.co.kr\/?p=676\" title=\"\uc6d4\ubcc4 \ud2f0\ucf13 \uac1c\uc218 \ud569  MS SQL  Query\">[&#8230;]<\/a><\/p>\n<\/div>","protected":false},"author":6,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_monsterinsights_skip_tracking":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[16],"tags":[111],"class_list":["post-676","post","type-post","status-publish","format-standard","hentry","category-mssql-server","tag-111"],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/www.auctionpro.co.kr\/index.php?rest_route=\/wp\/v2\/posts\/676","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.auctionpro.co.kr\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.auctionpro.co.kr\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.auctionpro.co.kr\/index.php?rest_route=\/wp\/v2\/users\/6"}],"replies":[{"embeddable":true,"href":"https:\/\/www.auctionpro.co.kr\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=676"}],"version-history":[{"count":0,"href":"https:\/\/www.auctionpro.co.kr\/index.php?rest_route=\/wp\/v2\/posts\/676\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.auctionpro.co.kr\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=676"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.auctionpro.co.kr\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=676"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.auctionpro.co.kr\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=676"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}