{"id":52,"date":"2017-03-23T14:52:48","date_gmt":"2017-03-23T14:52:48","guid":{"rendered":"http:\/\/www.polysyncronism.com\/wordpress\/?p=52"},"modified":"2017-03-23T14:52:48","modified_gmt":"2017-03-23T14:52:48","slug":"sample-net-capacity-sql","status":"publish","type":"post","link":"http:\/\/www.polysyncronism.com\/wordpress\/2017\/03\/23\/sample-net-capacity-sql\/","title":{"rendered":"Sample net capacity SQL"},"content":{"rendered":"<pre class=\"toolbar:1 lang:tsql decode:true \" title=\"Sample net capacity SQL\">CREATE TABLE #Sample\r\n(  \r\n Status int,\r\nMonth varchar(5),  \r\nCapacity int\r\n);  \r\n\r\nInsert into #Sample (Status,Month,Capacity) values (1,'01\/16',5)\r\nInsert into #Sample (Status,Month,Capacity) values (3,'01\/16',2)\r\nInsert into #Sample (Status,Month,Capacity) values (1,'02\/16',11)\r\nInsert into #Sample (Status,Month,Capacity) values (3,'02\/16',20)\r\nInsert into #Sample (Status,Month,Capacity) values (1,'03\/16',8)\r\nInsert into #Sample (Status,Month,Capacity) values (3,'03\/16',12)\r\nInsert into #Sample (Status,Month,Capacity) values (1,'04\/16',4)\r\nInsert into #Sample (Status,Month,Capacity) values (2,'04\/16',10)\r\nInsert into #Sample (Status,Month,Capacity) values (3,'04\/16',18)\r\nInsert into #Sample (Status,Month,Capacity) values (2,'05\/16',14)\r\nInsert into #Sample (Status,Month,Capacity) values (3,'05\/16',37)\r\nInsert into #Sample (Status,Month,Capacity) values (2,'06\/16',4)\r\nInsert into #Sample (Status,Month,Capacity) values (3,'06\/16',8)\r\n\r\nselect * from #Sample\r\n\r\nSELECT\r\n   a.status,\r\n   a.month,\r\n   a.capacity,\r\n   b.capacity AS total_capacity,\r\n   a.capacity - b.capacity AS net_capacity\r\nFROM\r\n   #Sample a\r\nJOIN\r\n   #Sample b\r\n   ON (a.month = b.month)\r\n   AND (b.status = 3)\r\nWHERE\r\n   a.status IN (1,2);\r\n\r\ndrop table #Sample<\/pre>\n<p>A handy way of calculating based on a transaction file.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>CREATE TABLE #Sample ( Status int, Month varchar(5), Capacity int ); Insert into #Sample (Status,Month,Capacity) values (1,&#8217;01\/16&#8242;,5) Insert into #Sample (Status,Month,Capacity) values (3,&#8217;01\/16&#8242;,2) Insert into #Sample (Status,Month,Capacity) values (1,&#8217;02\/16&#8242;,11) Insert into #Sample (Status,Month,Capacity) values (3,&#8217;02\/16&#8242;,20) Insert into #Sample (Status,Month,Capacity) values (1,&#8217;03\/16&#8242;,8) Insert into #Sample (Status,Month,Capacity) values (3,&#8217;03\/16&#8242;,12) Insert into #Sample (Status,Month,Capacity) values (1,&#8217;04\/16&#8242;,4) Insert into &hellip; <a href=\"http:\/\/www.polysyncronism.com\/wordpress\/2017\/03\/23\/sample-net-capacity-sql\/\" class=\"more-link\">Continue reading<span class=\"screen-reader-text\"> &#8220;Sample net capacity SQL&#8221;<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"class_list":["post-52","post","type-post","status-publish","format-standard","hentry","category-uncategorized"],"_links":{"self":[{"href":"http:\/\/www.polysyncronism.com\/wordpress\/wp-json\/wp\/v2\/posts\/52","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/www.polysyncronism.com\/wordpress\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/www.polysyncronism.com\/wordpress\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/www.polysyncronism.com\/wordpress\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/www.polysyncronism.com\/wordpress\/wp-json\/wp\/v2\/comments?post=52"}],"version-history":[{"count":4,"href":"http:\/\/www.polysyncronism.com\/wordpress\/wp-json\/wp\/v2\/posts\/52\/revisions"}],"predecessor-version":[{"id":56,"href":"http:\/\/www.polysyncronism.com\/wordpress\/wp-json\/wp\/v2\/posts\/52\/revisions\/56"}],"wp:attachment":[{"href":"http:\/\/www.polysyncronism.com\/wordpress\/wp-json\/wp\/v2\/media?parent=52"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.polysyncronism.com\/wordpress\/wp-json\/wp\/v2\/categories?post=52"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.polysyncronism.com\/wordpress\/wp-json\/wp\/v2\/tags?post=52"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}