<?xml version="1.0"?>
<feed xmlns="http://www.w3.org/2005/Atom" xml:lang="zh-Hant-TW">
	<id>http://tskds213.synology.me/mediawiki/index.php?action=history&amp;feed=atom&amp;title=%E9%9B%BB%E7%B7%9A%E4%BD%BF%E7%94%A8%E6%98%8E%E7%B4%B0</id>
	<title>電線使用明細 - 修訂紀錄</title>
	<link rel="self" type="application/atom+xml" href="http://tskds213.synology.me/mediawiki/index.php?action=history&amp;feed=atom&amp;title=%E9%9B%BB%E7%B7%9A%E4%BD%BF%E7%94%A8%E6%98%8E%E7%B4%B0"/>
	<link rel="alternate" type="text/html" href="http://tskds213.synology.me/mediawiki/index.php?title=%E9%9B%BB%E7%B7%9A%E4%BD%BF%E7%94%A8%E6%98%8E%E7%B4%B0&amp;action=history"/>
	<updated>2026-11-17T02:37:27Z</updated>
	<subtitle>本 wiki 上此頁面的修訂紀錄</subtitle>
	<generator>MediaWiki 1.43.5</generator>
	<entry>
		<id>http://tskds213.synology.me/mediawiki/index.php?title=%E9%9B%BB%E7%B7%9A%E4%BD%BF%E7%94%A8%E6%98%8E%E7%B4%B0&amp;diff=3707&amp;oldid=prev</id>
		<title>Unknown user：​/* 匯入程式碼 */</title>
		<link rel="alternate" type="text/html" href="http://tskds213.synology.me/mediawiki/index.php?title=%E9%9B%BB%E7%B7%9A%E4%BD%BF%E7%94%A8%E6%98%8E%E7%B4%B0&amp;diff=3707&amp;oldid=prev"/>
		<updated>2021-06-09T10:47:30Z</updated>

		<summary type="html">&lt;p&gt;&lt;span class=&quot;autocomment&quot;&gt;匯入程式碼&lt;/span&gt;&lt;/p&gt;
&lt;table style=&quot;background-color: #fff; color: #202122;&quot; data-mw=&quot;interface&quot;&gt;
				&lt;col class=&quot;diff-marker&quot; /&gt;
				&lt;col class=&quot;diff-content&quot; /&gt;
				&lt;col class=&quot;diff-marker&quot; /&gt;
				&lt;col class=&quot;diff-content&quot; /&gt;
				&lt;tr class=&quot;diff-title&quot; lang=&quot;zh-Hant-TW&quot;&gt;
				&lt;td colspan=&quot;2&quot; style=&quot;background-color: #fff; color: #202122; text-align: center;&quot;&gt;←上個修訂&lt;/td&gt;
				&lt;td colspan=&quot;2&quot; style=&quot;background-color: #fff; color: #202122; text-align: center;&quot;&gt;於 2021年6月9日 (三) 18:47 的修訂&lt;/td&gt;
				&lt;/tr&gt;&lt;tr&gt;&lt;td colspan=&quot;2&quot; class=&quot;diff-lineno&quot; id=&quot;mw-diff-left-l7&quot;&gt;第7行：&lt;/td&gt;
&lt;td colspan=&quot;2&quot; class=&quot;diff-lineno&quot;&gt;第7行：&lt;/td&gt;&lt;/tr&gt;
&lt;tr&gt;&lt;td class=&quot;diff-marker&quot;&gt;&lt;/td&gt;&lt;td style=&quot;background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;&quot;&gt;&lt;div&gt;*程式碼&lt;/div&gt;&lt;/td&gt;&lt;td class=&quot;diff-marker&quot;&gt;&lt;/td&gt;&lt;td style=&quot;background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;&quot;&gt;&lt;div&gt;*程式碼&lt;/div&gt;&lt;/td&gt;&lt;/tr&gt;
&lt;tr&gt;&lt;td class=&quot;diff-marker&quot;&gt;&lt;/td&gt;&lt;td style=&quot;background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;&quot;&gt;&lt;div&gt;&amp;lt;sql&amp;gt;&lt;/div&gt;&lt;/td&gt;&lt;td class=&quot;diff-marker&quot;&gt;&lt;/td&gt;&lt;td style=&quot;background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;&quot;&gt;&lt;div&gt;&amp;lt;sql&amp;gt;&lt;/div&gt;&lt;/td&gt;&lt;/tr&gt;
&lt;tr&gt;&lt;td class=&quot;diff-marker&quot; data-marker=&quot;−&quot;&gt;&lt;/td&gt;&lt;td style=&quot;color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;&quot;&gt;&lt;div&gt;INSERT INTO CABLEINOUT SELECT RTRIM(MB001) MB001,MB002,LMONTH,THEIN,THEOUT,HMOUT,SOLD,SMC007,&#039;202104&#039; THEMONTH FROM INVMB JOIN ( SELECT TH004,SUM(ASUM) LMONTH,SUM(AIN) THEIN,SUM(HMOUT+SAOUT) THEOUT, SUM(HMOUT)HMOUT, SUM(SAOUT) SOLD,SUM(ASUM+AIN-HMOUT-SAOUT) SMC007 FROM( SELECT TH004,SUM(CASE WHEN TH001=&#039;1201&#039; AND TH007=&#039;06&#039; THEN TH008*-1.0 ELSE TH008 END) ASUM,0 AIN, 0 HMOUT, 0 SAOUT FROM v_ALLINOUT WHERE TH020=&#039;Y&#039; AND (TH007=&#039;01&#039; OR (TH001=&#039;1201&#039; AND TH007=&#039;06&#039;)) AND TG003 &amp;lt; 20210401 GROUP BY TH004 UNION ALL SELECT TH004,0 ASUM,SUM(CASE WHEN TH001=&#039;1201&#039; AND TH007=&#039;06&#039; THEN TH008*-1.0 WHEN TH008&amp;gt;=0 THEN TH008 ELSE 0 END) AIN, 0 HMOUT, 0 SAOUT FROM v_ALLINOUT WHERE TH020=&#039;Y&#039; AND (TH001&amp;lt;&amp;gt;&#039;1201&#039; OR (TH001=&#039;1111&#039; AND TH007=&#039;01&#039;) OR (TH001=&#039;1201&#039; AND TH007=&#039;06&#039;)) AND TG003 LIKE &#039;202104%&#039; GROUP BY TH004 UNION ALL SELECT TH004,0 ASUM,0 AIN, 0 HMOUT, SUM(TH008*-1.0) SAOUT FROM v_ALLINOUT WHERE TH020=&#039;Y&#039; AND TH001&amp;lt;&amp;gt;&#039;1201&#039; AND (TH001=&#039;2301&#039; OR TH001=&#039;2401&#039;) AND TG003 LIKE &#039;202104%&#039; GROUP BY TH004 UNION ALL SELECT TH004,0 ASUM,0 AIN, SUM(TH008*-1.0) HMOUT, 0 SAOUT FROM v_ALLINOUT WHERE TH020=&#039;Y&#039; AND TH001=&#039;1201&#039; AND TH007=&#039;06&#039; AND TG003 LIKE &#039;202104%&#039; GROUP BY TH004 )X GROUP BY TH004)Y ON MB001=TH004 AND MB007=&#039;302&#039; WHERE MB001 NOT LIKE&#039;6%&#039; AND MB001 NOT LIKE &#039;2%&#039; AND MB001 NOT LIKE &#039;4%&#039; ORDER BY MB001&lt;/div&gt;&lt;/td&gt;&lt;td class=&quot;diff-marker&quot; data-marker=&quot;+&quot;&gt;&lt;/td&gt;&lt;td style=&quot;color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;&quot;&gt;&lt;div&gt;INSERT INTO CABLEINOUT&lt;/div&gt;&lt;/td&gt;&lt;/tr&gt;
&lt;tr&gt;&lt;td colspan=&quot;2&quot; class=&quot;diff-side-deleted&quot;&gt;&lt;/td&gt;&lt;td class=&quot;diff-marker&quot; data-marker=&quot;+&quot;&gt;&lt;/td&gt;&lt;td style=&quot;color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;&quot;&gt;&lt;div&gt;SELECT RTRIM(MB001) MB001,MB002,LMONTH,THEIN,THEOUT,HMOUT,SOLD,SMC007,&#039;202104&#039; THEMONTH  &lt;/div&gt;&lt;/td&gt;&lt;/tr&gt;
&lt;tr&gt;&lt;td colspan=&quot;2&quot; class=&quot;diff-side-deleted&quot;&gt;&lt;/td&gt;&lt;td class=&quot;diff-marker&quot; data-marker=&quot;+&quot;&gt;&lt;/td&gt;&lt;td style=&quot;color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;&quot;&gt;&lt;div&gt;FROM INVMB  &lt;/div&gt;&lt;/td&gt;&lt;/tr&gt;
&lt;tr&gt;&lt;td colspan=&quot;2&quot; class=&quot;diff-side-deleted&quot;&gt;&lt;/td&gt;&lt;td class=&quot;diff-marker&quot; data-marker=&quot;+&quot;&gt;&lt;/td&gt;&lt;td style=&quot;color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;&quot;&gt;&lt;div&gt;JOIN (  &lt;/div&gt;&lt;/td&gt;&lt;/tr&gt;
&lt;tr&gt;&lt;td colspan=&quot;2&quot; class=&quot;diff-side-deleted&quot;&gt;&lt;/td&gt;&lt;td class=&quot;diff-marker&quot; data-marker=&quot;+&quot;&gt;&lt;/td&gt;&lt;td style=&quot;color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;&quot;&gt;&lt;div&gt;&lt;ins style=&quot;font-weight: bold; text-decoration: none;&quot;&gt;		&lt;/ins&gt;SELECT TH004,SUM(ASUM) LMONTH,SUM(AIN) THEIN,SUM(HMOUT+SAOUT) THEOUT, SUM(HMOUT)HMOUT, SUM(SAOUT) SOLD,SUM(ASUM+AIN-HMOUT-SAOUT) SMC007  &lt;/div&gt;&lt;/td&gt;&lt;/tr&gt;
&lt;tr&gt;&lt;td colspan=&quot;2&quot; class=&quot;diff-side-deleted&quot;&gt;&lt;/td&gt;&lt;td class=&quot;diff-marker&quot; data-marker=&quot;+&quot;&gt;&lt;/td&gt;&lt;td style=&quot;color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;&quot;&gt;&lt;div&gt;&lt;ins style=&quot;font-weight: bold; text-decoration: none;&quot;&gt;		&lt;/ins&gt;FROM(  &lt;/div&gt;&lt;/td&gt;&lt;/tr&gt;
&lt;tr&gt;&lt;td colspan=&quot;2&quot; class=&quot;diff-side-deleted&quot;&gt;&lt;/td&gt;&lt;td class=&quot;diff-marker&quot; data-marker=&quot;+&quot;&gt;&lt;/td&gt;&lt;td style=&quot;color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;&quot;&gt;&lt;div&gt;&lt;ins style=&quot;font-weight: bold; text-decoration: none;&quot;&gt;				&lt;/ins&gt;SELECT TH004,SUM(CASE WHEN TH001=&#039;1201&#039; AND TH007=&#039;06&#039; THEN TH008*-1.0 ELSE TH008 END) ASUM,0 AIN, 0 HMOUT, 0 SAOUT  &lt;/div&gt;&lt;/td&gt;&lt;/tr&gt;
&lt;tr&gt;&lt;td colspan=&quot;2&quot; class=&quot;diff-side-deleted&quot;&gt;&lt;/td&gt;&lt;td class=&quot;diff-marker&quot; data-marker=&quot;+&quot;&gt;&lt;/td&gt;&lt;td style=&quot;color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;&quot;&gt;&lt;div&gt;&lt;ins style=&quot;font-weight: bold; text-decoration: none;&quot;&gt;				&lt;/ins&gt;FROM v_ALLINOUT  &lt;/div&gt;&lt;/td&gt;&lt;/tr&gt;
&lt;tr&gt;&lt;td colspan=&quot;2&quot; class=&quot;diff-side-deleted&quot;&gt;&lt;/td&gt;&lt;td class=&quot;diff-marker&quot; data-marker=&quot;+&quot;&gt;&lt;/td&gt;&lt;td style=&quot;color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;&quot;&gt;&lt;div&gt;&lt;ins style=&quot;font-weight: bold; text-decoration: none;&quot;&gt;				&lt;/ins&gt;WHERE TH020=&#039;Y&#039; AND (TH007=&#039;01&#039; OR (TH001=&#039;1201&#039; AND TH007=&#039;06&#039;))  &lt;/div&gt;&lt;/td&gt;&lt;/tr&gt;
&lt;tr&gt;&lt;td colspan=&quot;2&quot; class=&quot;diff-side-deleted&quot;&gt;&lt;/td&gt;&lt;td class=&quot;diff-marker&quot; data-marker=&quot;+&quot;&gt;&lt;/td&gt;&lt;td style=&quot;color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;&quot;&gt;&lt;div&gt;&lt;ins style=&quot;font-weight: bold; text-decoration: none;&quot;&gt;				&lt;/ins&gt;AND TG003 &amp;lt; 20210401 GROUP BY TH004  &lt;/div&gt;&lt;/td&gt;&lt;/tr&gt;
&lt;tr&gt;&lt;td colspan=&quot;2&quot; class=&quot;diff-side-deleted&quot;&gt;&lt;/td&gt;&lt;td class=&quot;diff-marker&quot; data-marker=&quot;+&quot;&gt;&lt;/td&gt;&lt;td style=&quot;color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;&quot;&gt;&lt;div&gt;&lt;ins style=&quot;font-weight: bold; text-decoration: none;&quot;&gt;				&lt;/ins&gt;&lt;/div&gt;&lt;/td&gt;&lt;/tr&gt;
&lt;tr&gt;&lt;td colspan=&quot;2&quot; class=&quot;diff-side-deleted&quot;&gt;&lt;/td&gt;&lt;td class=&quot;diff-marker&quot; data-marker=&quot;+&quot;&gt;&lt;/td&gt;&lt;td style=&quot;color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;&quot;&gt;&lt;div&gt;&lt;ins style=&quot;font-weight: bold; text-decoration: none;&quot;&gt;				&lt;/ins&gt;UNION ALL  &lt;/div&gt;&lt;/td&gt;&lt;/tr&gt;
&lt;tr&gt;&lt;td colspan=&quot;2&quot; class=&quot;diff-side-deleted&quot;&gt;&lt;/td&gt;&lt;td class=&quot;diff-marker&quot; data-marker=&quot;+&quot;&gt;&lt;/td&gt;&lt;td style=&quot;color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;&quot;&gt;&lt;div&gt;&lt;ins style=&quot;font-weight: bold; text-decoration: none;&quot;&gt;				&lt;/ins&gt;SELECT TH004,0 ASUM,SUM(CASE WHEN TH001=&#039;1201&#039;  &lt;/div&gt;&lt;/td&gt;&lt;/tr&gt;
&lt;tr&gt;&lt;td colspan=&quot;2&quot; class=&quot;diff-side-deleted&quot;&gt;&lt;/td&gt;&lt;td class=&quot;diff-marker&quot; data-marker=&quot;+&quot;&gt;&lt;/td&gt;&lt;td style=&quot;color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;&quot;&gt;&lt;div&gt;&lt;ins style=&quot;font-weight: bold; text-decoration: none;&quot;&gt;				&lt;/ins&gt;AND TH007=&#039;06&#039; THEN TH008*-1.0 WHEN TH008&amp;gt;=0 THEN TH008 ELSE 0 END) AIN, 0 HMOUT, 0 SAOUT  &lt;/div&gt;&lt;/td&gt;&lt;/tr&gt;
&lt;tr&gt;&lt;td colspan=&quot;2&quot; class=&quot;diff-side-deleted&quot;&gt;&lt;/td&gt;&lt;td class=&quot;diff-marker&quot; data-marker=&quot;+&quot;&gt;&lt;/td&gt;&lt;td style=&quot;color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;&quot;&gt;&lt;div&gt;&lt;ins style=&quot;font-weight: bold; text-decoration: none;&quot;&gt;				&lt;/ins&gt;FROM v_ALLINOUT  &lt;/div&gt;&lt;/td&gt;&lt;/tr&gt;
&lt;tr&gt;&lt;td colspan=&quot;2&quot; class=&quot;diff-side-deleted&quot;&gt;&lt;/td&gt;&lt;td class=&quot;diff-marker&quot; data-marker=&quot;+&quot;&gt;&lt;/td&gt;&lt;td style=&quot;color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;&quot;&gt;&lt;div&gt;&lt;ins style=&quot;font-weight: bold; text-decoration: none;&quot;&gt;				&lt;/ins&gt;WHERE TH020=&#039;Y&#039; AND (TH001&amp;lt;&amp;gt;&#039;1201&#039; OR (TH001=&#039;1111&#039; AND TH007=&#039;01&#039;)  &lt;/div&gt;&lt;/td&gt;&lt;/tr&gt;
&lt;tr&gt;&lt;td colspan=&quot;2&quot; class=&quot;diff-side-deleted&quot;&gt;&lt;/td&gt;&lt;td class=&quot;diff-marker&quot; data-marker=&quot;+&quot;&gt;&lt;/td&gt;&lt;td style=&quot;color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;&quot;&gt;&lt;div&gt;&lt;ins style=&quot;font-weight: bold; text-decoration: none;&quot;&gt;				&lt;/ins&gt;OR (TH001=&#039;1201&#039; AND TH007=&#039;06&#039;)) AND TG003 LIKE &#039;202104%&#039; GROUP BY TH004  &lt;/div&gt;&lt;/td&gt;&lt;/tr&gt;
&lt;tr&gt;&lt;td colspan=&quot;2&quot; class=&quot;diff-side-deleted&quot;&gt;&lt;/td&gt;&lt;td class=&quot;diff-marker&quot; data-marker=&quot;+&quot;&gt;&lt;/td&gt;&lt;td style=&quot;color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;&quot;&gt;&lt;div&gt;&lt;ins style=&quot;font-weight: bold; text-decoration: none;&quot;&gt;				&lt;/ins&gt;&lt;/div&gt;&lt;/td&gt;&lt;/tr&gt;
&lt;tr&gt;&lt;td colspan=&quot;2&quot; class=&quot;diff-side-deleted&quot;&gt;&lt;/td&gt;&lt;td class=&quot;diff-marker&quot; data-marker=&quot;+&quot;&gt;&lt;/td&gt;&lt;td style=&quot;color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;&quot;&gt;&lt;div&gt;&lt;ins style=&quot;font-weight: bold; text-decoration: none;&quot;&gt;				&lt;/ins&gt;UNION ALL  &lt;/div&gt;&lt;/td&gt;&lt;/tr&gt;
&lt;tr&gt;&lt;td colspan=&quot;2&quot; class=&quot;diff-side-deleted&quot;&gt;&lt;/td&gt;&lt;td class=&quot;diff-marker&quot; data-marker=&quot;+&quot;&gt;&lt;/td&gt;&lt;td style=&quot;color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;&quot;&gt;&lt;div&gt;&lt;ins style=&quot;font-weight: bold; text-decoration: none;&quot;&gt;				&lt;/ins&gt;SELECT TH004,0 ASUM,0 AIN, 0 HMOUT, SUM(TH008*-1.0) SAOUT  &lt;/div&gt;&lt;/td&gt;&lt;/tr&gt;
&lt;tr&gt;&lt;td colspan=&quot;2&quot; class=&quot;diff-side-deleted&quot;&gt;&lt;/td&gt;&lt;td class=&quot;diff-marker&quot; data-marker=&quot;+&quot;&gt;&lt;/td&gt;&lt;td style=&quot;color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;&quot;&gt;&lt;div&gt;&lt;ins style=&quot;font-weight: bold; text-decoration: none;&quot;&gt;				&lt;/ins&gt;FROM v_ALLINOUT  &lt;/div&gt;&lt;/td&gt;&lt;/tr&gt;
&lt;tr&gt;&lt;td colspan=&quot;2&quot; class=&quot;diff-side-deleted&quot;&gt;&lt;/td&gt;&lt;td class=&quot;diff-marker&quot; data-marker=&quot;+&quot;&gt;&lt;/td&gt;&lt;td style=&quot;color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;&quot;&gt;&lt;div&gt;&lt;ins style=&quot;font-weight: bold; text-decoration: none;&quot;&gt;				&lt;/ins&gt;WHERE TH020=&#039;Y&#039; AND TH001&amp;lt;&amp;gt;&#039;1201&#039; AND (TH001=&#039;2301&#039; OR TH001=&#039;2401&#039;)  &lt;/div&gt;&lt;/td&gt;&lt;/tr&gt;
&lt;tr&gt;&lt;td colspan=&quot;2&quot; class=&quot;diff-side-deleted&quot;&gt;&lt;/td&gt;&lt;td class=&quot;diff-marker&quot; data-marker=&quot;+&quot;&gt;&lt;/td&gt;&lt;td style=&quot;color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;&quot;&gt;&lt;div&gt;&lt;ins style=&quot;font-weight: bold; text-decoration: none;&quot;&gt;				&lt;/ins&gt;AND TG003 LIKE &#039;202104%&#039; GROUP BY TH004  &lt;/div&gt;&lt;/td&gt;&lt;/tr&gt;
&lt;tr&gt;&lt;td colspan=&quot;2&quot; class=&quot;diff-side-deleted&quot;&gt;&lt;/td&gt;&lt;td class=&quot;diff-marker&quot; data-marker=&quot;+&quot;&gt;&lt;/td&gt;&lt;td style=&quot;color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;&quot;&gt;&lt;div&gt;&lt;ins style=&quot;font-weight: bold; text-decoration: none;&quot;&gt;				&lt;/ins&gt;&lt;/div&gt;&lt;/td&gt;&lt;/tr&gt;
&lt;tr&gt;&lt;td colspan=&quot;2&quot; class=&quot;diff-side-deleted&quot;&gt;&lt;/td&gt;&lt;td class=&quot;diff-marker&quot; data-marker=&quot;+&quot;&gt;&lt;/td&gt;&lt;td style=&quot;color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;&quot;&gt;&lt;div&gt;&lt;ins style=&quot;font-weight: bold; text-decoration: none;&quot;&gt;				&lt;/ins&gt;UNION ALL  &lt;/div&gt;&lt;/td&gt;&lt;/tr&gt;
&lt;tr&gt;&lt;td colspan=&quot;2&quot; class=&quot;diff-side-deleted&quot;&gt;&lt;/td&gt;&lt;td class=&quot;diff-marker&quot; data-marker=&quot;+&quot;&gt;&lt;/td&gt;&lt;td style=&quot;color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;&quot;&gt;&lt;div&gt;&lt;ins style=&quot;font-weight: bold; text-decoration: none;&quot;&gt;				&lt;/ins&gt;SELECT TH004,0 ASUM,0 AIN, SUM(TH008*-1.0) HMOUT, 0 SAOUT  &lt;/div&gt;&lt;/td&gt;&lt;/tr&gt;
&lt;tr&gt;&lt;td colspan=&quot;2&quot; class=&quot;diff-side-deleted&quot;&gt;&lt;/td&gt;&lt;td class=&quot;diff-marker&quot; data-marker=&quot;+&quot;&gt;&lt;/td&gt;&lt;td style=&quot;color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;&quot;&gt;&lt;div&gt;&lt;ins style=&quot;font-weight: bold; text-decoration: none;&quot;&gt;				&lt;/ins&gt;FROM v_ALLINOUT  &lt;/div&gt;&lt;/td&gt;&lt;/tr&gt;
&lt;tr&gt;&lt;td colspan=&quot;2&quot; class=&quot;diff-side-deleted&quot;&gt;&lt;/td&gt;&lt;td class=&quot;diff-marker&quot; data-marker=&quot;+&quot;&gt;&lt;/td&gt;&lt;td style=&quot;color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;&quot;&gt;&lt;div&gt;&lt;ins style=&quot;font-weight: bold; text-decoration: none;&quot;&gt;				&lt;/ins&gt;WHERE TH020=&#039;Y&#039; AND TH001=&#039;1201&#039; AND TH007=&#039;06&#039;  &lt;/div&gt;&lt;/td&gt;&lt;/tr&gt;
&lt;tr&gt;&lt;td colspan=&quot;2&quot; class=&quot;diff-side-deleted&quot;&gt;&lt;/td&gt;&lt;td class=&quot;diff-marker&quot; data-marker=&quot;+&quot;&gt;&lt;/td&gt;&lt;td style=&quot;color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;&quot;&gt;&lt;div&gt;&lt;ins style=&quot;font-weight: bold; text-decoration: none;&quot;&gt;				&lt;/ins&gt;AND TG003 LIKE &#039;202104%&#039; GROUP BY TH004  &lt;/div&gt;&lt;/td&gt;&lt;/tr&gt;
&lt;tr&gt;&lt;td colspan=&quot;2&quot; class=&quot;diff-side-deleted&quot;&gt;&lt;/td&gt;&lt;td class=&quot;diff-marker&quot; data-marker=&quot;+&quot;&gt;&lt;/td&gt;&lt;td style=&quot;color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;&quot;&gt;&lt;div&gt;&lt;ins style=&quot;font-weight: bold; text-decoration: none;&quot;&gt;			&lt;/ins&gt;)X  &lt;/div&gt;&lt;/td&gt;&lt;/tr&gt;
&lt;tr&gt;&lt;td colspan=&quot;2&quot; class=&quot;diff-side-deleted&quot;&gt;&lt;/td&gt;&lt;td class=&quot;diff-marker&quot; data-marker=&quot;+&quot;&gt;&lt;/td&gt;&lt;td style=&quot;color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;&quot;&gt;&lt;div&gt;&lt;ins style=&quot;font-weight: bold; text-decoration: none;&quot;&gt;			&lt;/ins&gt;GROUP BY TH004&lt;/div&gt;&lt;/td&gt;&lt;/tr&gt;
&lt;tr&gt;&lt;td colspan=&quot;2&quot; class=&quot;diff-side-deleted&quot;&gt;&lt;/td&gt;&lt;td class=&quot;diff-marker&quot; data-marker=&quot;+&quot;&gt;&lt;/td&gt;&lt;td style=&quot;color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;&quot;&gt;&lt;div&gt;&lt;ins style=&quot;font-weight: bold; text-decoration: none;&quot;&gt;	&lt;/ins&gt;)Y ON MB001=TH004 AND MB007=&#039;302&#039;	&lt;ins style=&quot;font-weight: bold; text-decoration: none;&quot;&gt;	&lt;/ins&gt;&lt;/div&gt;&lt;/td&gt;&lt;/tr&gt;
&lt;tr&gt;&lt;td colspan=&quot;2&quot; class=&quot;diff-side-deleted&quot;&gt;&lt;/td&gt;&lt;td class=&quot;diff-marker&quot; data-marker=&quot;+&quot;&gt;&lt;/td&gt;&lt;td style=&quot;color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;&quot;&gt;&lt;div&gt;&lt;ins style=&quot;font-weight: bold; text-decoration: none;&quot;&gt;	&lt;/ins&gt;WHERE MB001 NOT LIKE&#039;6%&#039; AND MB001 NOT LIKE &#039;2%&#039; AND MB001 NOT LIKE &#039;4%&#039; ORDER BY MB001&lt;/div&gt;&lt;/td&gt;&lt;/tr&gt;
&lt;tr&gt;&lt;td class=&quot;diff-marker&quot;&gt;&lt;/td&gt;&lt;td style=&quot;background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;&quot;&gt;&lt;div&gt;&amp;lt;/sql&amp;gt;&lt;/div&gt;&lt;/td&gt;&lt;td class=&quot;diff-marker&quot;&gt;&lt;/td&gt;&lt;td style=&quot;background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;&quot;&gt;&lt;div&gt;&amp;lt;/sql&amp;gt;&lt;/div&gt;&lt;/td&gt;&lt;/tr&gt;
&lt;/table&gt;</summary>
		<author><name>Unknown user</name></author>
	</entry>
	<entry>
		<id>http://tskds213.synology.me/mediawiki/index.php?title=%E9%9B%BB%E7%B7%9A%E4%BD%BF%E7%94%A8%E6%98%8E%E7%B4%B0&amp;diff=3706&amp;oldid=prev</id>
		<title>Unknown user：​/* 查詢程式碼 */</title>
		<link rel="alternate" type="text/html" href="http://tskds213.synology.me/mediawiki/index.php?title=%E9%9B%BB%E7%B7%9A%E4%BD%BF%E7%94%A8%E6%98%8E%E7%B4%B0&amp;diff=3706&amp;oldid=prev"/>
		<updated>2021-06-09T10:38:00Z</updated>

		<summary type="html">&lt;p&gt;&lt;span class=&quot;autocomment&quot;&gt;查詢程式碼&lt;/span&gt;&lt;/p&gt;
&lt;table style=&quot;background-color: #fff; color: #202122;&quot; data-mw=&quot;interface&quot;&gt;
				&lt;col class=&quot;diff-marker&quot; /&gt;
				&lt;col class=&quot;diff-content&quot; /&gt;
				&lt;col class=&quot;diff-marker&quot; /&gt;
				&lt;col class=&quot;diff-content&quot; /&gt;
				&lt;tr class=&quot;diff-title&quot; lang=&quot;zh-Hant-TW&quot;&gt;
				&lt;td colspan=&quot;2&quot; style=&quot;background-color: #fff; color: #202122; text-align: center;&quot;&gt;←上個修訂&lt;/td&gt;
				&lt;td colspan=&quot;2&quot; style=&quot;background-color: #fff; color: #202122; text-align: center;&quot;&gt;於 2021年6月9日 (三) 18:38 的修訂&lt;/td&gt;
				&lt;/tr&gt;&lt;tr&gt;&lt;td colspan=&quot;2&quot; class=&quot;diff-lineno&quot; id=&quot;mw-diff-left-l2&quot;&gt;第2行：&lt;/td&gt;
&lt;td colspan=&quot;2&quot; class=&quot;diff-lineno&quot;&gt;第2行：&lt;/td&gt;&lt;/tr&gt;
&lt;tr&gt;&lt;td class=&quot;diff-marker&quot;&gt;&lt;/td&gt;&lt;td style=&quot;background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;&quot;&gt;&lt;div&gt;&amp;lt;sql&amp;gt;&lt;/div&gt;&lt;/td&gt;&lt;td class=&quot;diff-marker&quot;&gt;&lt;/td&gt;&lt;td style=&quot;background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;&quot;&gt;&lt;div&gt;&amp;lt;sql&amp;gt;&lt;/div&gt;&lt;/td&gt;&lt;/tr&gt;
&lt;tr&gt;&lt;td class=&quot;diff-marker&quot;&gt;&lt;/td&gt;&lt;td style=&quot;background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;&quot;&gt;&lt;div&gt;SELECT * FROM ( SELECT XX.*,ROUND((A1+A2+A3+A13+A14+A15)/6,0) AS SAVG,SMC007,X.UDF06 AS PRESA,ROUND(UNUSE,0)AS UNUSE,ROUND((SMC007-X.UDF06-UNUSE),0) AS PREALL,QTA, ROUND((SMC007-X.UDF06-UNUSE-(SELECT CASE WHEN QTA&amp;lt;0 THEN QTA ELSE 0 END)),0) AS FAMOUNT, XX.MB001 AS TA006 FROM ( SELECT MB001, ROUND([202012],0) AS A15,ROUND([202101],0) AS A14,ROUND([202102],0) AS A13,[202103] AS A3,[202104] AS A2,[202105] AS A1,[202106] AS A0 FROM ( SELECT RTRIM(MB001) MB001,THEOUT,THEMONTH FROM CABLEINOUT WHERE (THEMONTH BETWEEN &amp;#039;202103&amp;#039; AND &amp;#039;202106&amp;#039; OR THEMONTH BETWEEN &amp;#039;202012&amp;#039; AND &amp;#039;202102&amp;#039; ) AND MB001&amp;lt;&amp;gt;&amp;#039;TSS-089-3C大同&amp;#039; ) AS p PIVOT ( SUM(THEOUT) FOR THEMONTH IN ([202012],[202101],[202102],[202103], [202104],[202105],[202106]) ) AS pt1 ) XX LEFT JOIN v_INVMC01 ON MC001=MB001 JOIN INVMB X ON X.MB001=XX.MB001 LEFT JOIN (SELECT TA006,(SUM(TA017)-SUM(TA015))AS QTA FROM MOCTA WHERE TA011&amp;lt;&amp;gt;&amp;#039;Y&amp;#039; AND TA011&amp;lt;&amp;gt;&amp;#039;y&amp;#039; AND TA013&amp;lt;&amp;gt;&amp;#039;V&amp;#039; GROUP BY TA006)Z ON XX.MB001=TA006 LEFT JOIN (SELECT TB003,SUM(TB004-TB005)AS UNUSE FROM MOCTB JOIN MOCTA ON TA001=TB001 AND TA002=TB002 WHERE TB018=&amp;#039;Y&amp;#039; AND TA011&amp;lt;&amp;gt;&amp;#039;Y&amp;#039; AND TA011&amp;lt;&amp;gt;&amp;#039;y&amp;#039; GROUP BY TB003)ZZ ON XX.MB001=TB003 )YY&lt;/div&gt;&lt;/td&gt;&lt;td class=&quot;diff-marker&quot;&gt;&lt;/td&gt;&lt;td style=&quot;background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;&quot;&gt;&lt;div&gt;SELECT * FROM ( SELECT XX.*,ROUND((A1+A2+A3+A13+A14+A15)/6,0) AS SAVG,SMC007,X.UDF06 AS PRESA,ROUND(UNUSE,0)AS UNUSE,ROUND((SMC007-X.UDF06-UNUSE),0) AS PREALL,QTA, ROUND((SMC007-X.UDF06-UNUSE-(SELECT CASE WHEN QTA&amp;lt;0 THEN QTA ELSE 0 END)),0) AS FAMOUNT, XX.MB001 AS TA006 FROM ( SELECT MB001, ROUND([202012],0) AS A15,ROUND([202101],0) AS A14,ROUND([202102],0) AS A13,[202103] AS A3,[202104] AS A2,[202105] AS A1,[202106] AS A0 FROM ( SELECT RTRIM(MB001) MB001,THEOUT,THEMONTH FROM CABLEINOUT WHERE (THEMONTH BETWEEN &amp;#039;202103&amp;#039; AND &amp;#039;202106&amp;#039; OR THEMONTH BETWEEN &amp;#039;202012&amp;#039; AND &amp;#039;202102&amp;#039; ) AND MB001&amp;lt;&amp;gt;&amp;#039;TSS-089-3C大同&amp;#039; ) AS p PIVOT ( SUM(THEOUT) FOR THEMONTH IN ([202012],[202101],[202102],[202103], [202104],[202105],[202106]) ) AS pt1 ) XX LEFT JOIN v_INVMC01 ON MC001=MB001 JOIN INVMB X ON X.MB001=XX.MB001 LEFT JOIN (SELECT TA006,(SUM(TA017)-SUM(TA015))AS QTA FROM MOCTA WHERE TA011&amp;lt;&amp;gt;&amp;#039;Y&amp;#039; AND TA011&amp;lt;&amp;gt;&amp;#039;y&amp;#039; AND TA013&amp;lt;&amp;gt;&amp;#039;V&amp;#039; GROUP BY TA006)Z ON XX.MB001=TA006 LEFT JOIN (SELECT TB003,SUM(TB004-TB005)AS UNUSE FROM MOCTB JOIN MOCTA ON TA001=TB001 AND TA002=TB002 WHERE TB018=&amp;#039;Y&amp;#039; AND TA011&amp;lt;&amp;gt;&amp;#039;Y&amp;#039; AND TA011&amp;lt;&amp;gt;&amp;#039;y&amp;#039; GROUP BY TB003)ZZ ON XX.MB001=TB003 )YY&lt;/div&gt;&lt;/td&gt;&lt;/tr&gt;
&lt;tr&gt;&lt;td colspan=&quot;2&quot; class=&quot;diff-side-deleted&quot;&gt;&lt;/td&gt;&lt;td class=&quot;diff-marker&quot; data-marker=&quot;+&quot;&gt;&lt;/td&gt;&lt;td style=&quot;color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;&quot;&gt;&lt;div&gt;&lt;ins style=&quot;font-weight: bold; text-decoration: none;&quot;&gt;&amp;lt;/sql&amp;gt;&lt;/ins&gt;&lt;/div&gt;&lt;/td&gt;&lt;/tr&gt;
&lt;tr&gt;&lt;td colspan=&quot;2&quot; class=&quot;diff-side-deleted&quot;&gt;&lt;/td&gt;&lt;td class=&quot;diff-marker&quot; data-marker=&quot;+&quot;&gt;&lt;/td&gt;&lt;td style=&quot;color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;&quot;&gt;&lt;div&gt;&lt;ins style=&quot;font-weight: bold; text-decoration: none;&quot;&gt;==匯入程式碼==&lt;/ins&gt;&lt;/div&gt;&lt;/td&gt;&lt;/tr&gt;
&lt;tr&gt;&lt;td colspan=&quot;2&quot; class=&quot;diff-side-deleted&quot;&gt;&lt;/td&gt;&lt;td class=&quot;diff-marker&quot; data-marker=&quot;+&quot;&gt;&lt;/td&gt;&lt;td style=&quot;color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;&quot;&gt;&lt;div&gt;&lt;ins style=&quot;font-weight: bold; text-decoration: none;&quot;&gt;*網址 php/CABLEINOUT.php?q=202104&lt;/ins&gt;&lt;/div&gt;&lt;/td&gt;&lt;/tr&gt;
&lt;tr&gt;&lt;td colspan=&quot;2&quot; class=&quot;diff-side-deleted&quot;&gt;&lt;/td&gt;&lt;td class=&quot;diff-marker&quot; data-marker=&quot;+&quot;&gt;&lt;/td&gt;&lt;td style=&quot;color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;&quot;&gt;&lt;div&gt;&lt;ins style=&quot;font-weight: bold; text-decoration: none;&quot;&gt;*程式碼&lt;/ins&gt;&lt;/div&gt;&lt;/td&gt;&lt;/tr&gt;
&lt;tr&gt;&lt;td colspan=&quot;2&quot; class=&quot;diff-side-deleted&quot;&gt;&lt;/td&gt;&lt;td class=&quot;diff-marker&quot; data-marker=&quot;+&quot;&gt;&lt;/td&gt;&lt;td style=&quot;color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;&quot;&gt;&lt;div&gt;&lt;ins style=&quot;font-weight: bold; text-decoration: none;&quot;&gt;&amp;lt;sql&amp;gt;&lt;/ins&gt;&lt;/div&gt;&lt;/td&gt;&lt;/tr&gt;
&lt;tr&gt;&lt;td colspan=&quot;2&quot; class=&quot;diff-side-deleted&quot;&gt;&lt;/td&gt;&lt;td class=&quot;diff-marker&quot; data-marker=&quot;+&quot;&gt;&lt;/td&gt;&lt;td style=&quot;color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;&quot;&gt;&lt;div&gt;&lt;ins style=&quot;font-weight: bold; text-decoration: none;&quot;&gt;INSERT INTO CABLEINOUT SELECT RTRIM(MB001) MB001,MB002,LMONTH,THEIN,THEOUT,HMOUT,SOLD,SMC007,&#039;202104&#039; THEMONTH FROM INVMB JOIN ( SELECT TH004,SUM(ASUM) LMONTH,SUM(AIN) THEIN,SUM(HMOUT+SAOUT) THEOUT, SUM(HMOUT)HMOUT, SUM(SAOUT) SOLD,SUM(ASUM+AIN-HMOUT-SAOUT) SMC007 FROM( SELECT TH004,SUM(CASE WHEN TH001=&#039;1201&#039; AND TH007=&#039;06&#039; THEN TH008*-1.0 ELSE TH008 END) ASUM,0 AIN, 0 HMOUT, 0 SAOUT FROM v_ALLINOUT WHERE TH020=&#039;Y&#039; AND (TH007=&#039;01&#039; OR (TH001=&#039;1201&#039; AND TH007=&#039;06&#039;)) AND TG003 &amp;lt; 20210401 GROUP BY TH004 UNION ALL SELECT TH004,0 ASUM,SUM(CASE WHEN TH001=&#039;1201&#039; AND TH007=&#039;06&#039; THEN TH008*-1.0 WHEN TH008&amp;gt;=0 THEN TH008 ELSE 0 END) AIN, 0 HMOUT, 0 SAOUT FROM v_ALLINOUT WHERE TH020=&#039;Y&#039; AND (TH001&amp;lt;&amp;gt;&#039;1201&#039; OR (TH001=&#039;1111&#039; AND TH007=&#039;01&#039;) OR (TH001=&#039;1201&#039; AND TH007=&#039;06&#039;)) AND TG003 LIKE &#039;202104%&#039; GROUP BY TH004 UNION ALL SELECT TH004,0 ASUM,0 AIN, 0 HMOUT, SUM(TH008*-1.0) SAOUT FROM v_ALLINOUT WHERE TH020=&#039;Y&#039; AND TH001&amp;lt;&amp;gt;&#039;1201&#039; AND (TH001=&#039;2301&#039; OR TH001=&#039;2401&#039;) AND TG003 LIKE &#039;202104%&#039; GROUP BY TH004 UNION ALL SELECT TH004,0 ASUM,0 AIN, SUM(TH008*-1.0) HMOUT, 0 SAOUT FROM v_ALLINOUT WHERE TH020=&#039;Y&#039; AND TH001=&#039;1201&#039; AND TH007=&#039;06&#039; AND TG003 LIKE &#039;202104%&#039; GROUP BY TH004 )X GROUP BY TH004)Y ON MB001=TH004 AND MB007=&#039;302&#039; WHERE MB001 NOT LIKE&#039;6%&#039; AND MB001 NOT LIKE &#039;2%&#039; AND MB001 NOT LIKE &#039;4%&#039; ORDER BY MB001&lt;/ins&gt;&lt;/div&gt;&lt;/td&gt;&lt;/tr&gt;
&lt;tr&gt;&lt;td class=&quot;diff-marker&quot;&gt;&lt;/td&gt;&lt;td style=&quot;background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;&quot;&gt;&lt;div&gt;&amp;lt;/sql&amp;gt;&lt;/div&gt;&lt;/td&gt;&lt;td class=&quot;diff-marker&quot;&gt;&lt;/td&gt;&lt;td style=&quot;background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;&quot;&gt;&lt;div&gt;&amp;lt;/sql&amp;gt;&lt;/div&gt;&lt;/td&gt;&lt;/tr&gt;
&lt;/table&gt;</summary>
		<author><name>Unknown user</name></author>
	</entry>
	<entry>
		<id>http://tskds213.synology.me/mediawiki/index.php?title=%E9%9B%BB%E7%B7%9A%E4%BD%BF%E7%94%A8%E6%98%8E%E7%B4%B0&amp;diff=3705&amp;oldid=prev</id>
		<title>Unknown user：​已建立頁面，內容為 &quot;==查詢程式碼== &lt;sql&gt; SELECT * FROM ( SELECT XX.*,ROUND((A1+A2+A3+A13+A14+A15)/6,0) AS SAVG,SMC007,X.UDF06 AS PRESA,ROUND(UNUSE,0)AS UNUSE,ROUND((SMC007-X.UDF06-…&quot;</title>
		<link rel="alternate" type="text/html" href="http://tskds213.synology.me/mediawiki/index.php?title=%E9%9B%BB%E7%B7%9A%E4%BD%BF%E7%94%A8%E6%98%8E%E7%B4%B0&amp;diff=3705&amp;oldid=prev"/>
		<updated>2021-06-09T10:32:20Z</updated>

		<summary type="html">&lt;p&gt;已建立頁面，內容為 &amp;quot;==查詢程式碼== &amp;lt;sql&amp;gt; SELECT * FROM ( SELECT XX.*,ROUND((A1+A2+A3+A13+A14+A15)/6,0) AS SAVG,SMC007,X.UDF06 AS PRESA,ROUND(UNUSE,0)AS UNUSE,ROUND((SMC007-X.UDF06-…&amp;quot;&lt;/p&gt;
&lt;p&gt;&lt;b&gt;新頁面&lt;/b&gt;&lt;/p&gt;&lt;div&gt;==查詢程式碼==&lt;br /&gt;
&amp;lt;sql&amp;gt;&lt;br /&gt;
SELECT * FROM ( SELECT XX.*,ROUND((A1+A2+A3+A13+A14+A15)/6,0) AS SAVG,SMC007,X.UDF06 AS PRESA,ROUND(UNUSE,0)AS UNUSE,ROUND((SMC007-X.UDF06-UNUSE),0) AS PREALL,QTA, ROUND((SMC007-X.UDF06-UNUSE-(SELECT CASE WHEN QTA&amp;lt;0 THEN QTA ELSE 0 END)),0) AS FAMOUNT, XX.MB001 AS TA006 FROM ( SELECT MB001, ROUND([202012],0) AS A15,ROUND([202101],0) AS A14,ROUND([202102],0) AS A13,[202103] AS A3,[202104] AS A2,[202105] AS A1,[202106] AS A0 FROM ( SELECT RTRIM(MB001) MB001,THEOUT,THEMONTH FROM CABLEINOUT WHERE (THEMONTH BETWEEN &amp;#039;202103&amp;#039; AND &amp;#039;202106&amp;#039; OR THEMONTH BETWEEN &amp;#039;202012&amp;#039; AND &amp;#039;202102&amp;#039; ) AND MB001&amp;lt;&amp;gt;&amp;#039;TSS-089-3C大同&amp;#039; ) AS p PIVOT ( SUM(THEOUT) FOR THEMONTH IN ([202012],[202101],[202102],[202103], [202104],[202105],[202106]) ) AS pt1 ) XX LEFT JOIN v_INVMC01 ON MC001=MB001 JOIN INVMB X ON X.MB001=XX.MB001 LEFT JOIN (SELECT TA006,(SUM(TA017)-SUM(TA015))AS QTA FROM MOCTA WHERE TA011&amp;lt;&amp;gt;&amp;#039;Y&amp;#039; AND TA011&amp;lt;&amp;gt;&amp;#039;y&amp;#039; AND TA013&amp;lt;&amp;gt;&amp;#039;V&amp;#039; GROUP BY TA006)Z ON XX.MB001=TA006 LEFT JOIN (SELECT TB003,SUM(TB004-TB005)AS UNUSE FROM MOCTB JOIN MOCTA ON TA001=TB001 AND TA002=TB002 WHERE TB018=&amp;#039;Y&amp;#039; AND TA011&amp;lt;&amp;gt;&amp;#039;Y&amp;#039; AND TA011&amp;lt;&amp;gt;&amp;#039;y&amp;#039; GROUP BY TB003)ZZ ON XX.MB001=TB003 )YY&lt;br /&gt;
&amp;lt;/sql&amp;gt;&lt;/div&gt;</summary>
		<author><name>Unknown user</name></author>
	</entry>
</feed>