<?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%A0%90%E8%A8%88%E5%85%83%E4%BB%B6%E7%94%A8%E9%87%8F%E4%BC%B0%E7%AE%97</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%A0%90%E8%A8%88%E5%85%83%E4%BB%B6%E7%94%A8%E9%87%8F%E4%BC%B0%E7%AE%97"/>
	<link rel="alternate" type="text/html" href="http://tskds213.synology.me/mediawiki/index.php?title=%E9%A0%90%E8%A8%88%E5%85%83%E4%BB%B6%E7%94%A8%E9%87%8F%E4%BC%B0%E7%AE%97&amp;action=history"/>
	<updated>2026-11-16T23:43:46Z</updated>
	<subtitle>本 wiki 上此頁面的修訂紀錄</subtitle>
	<generator>MediaWiki 1.43.5</generator>
	<entry>
		<id>http://tskds213.synology.me/mediawiki/index.php?title=%E9%A0%90%E8%A8%88%E5%85%83%E4%BB%B6%E7%94%A8%E9%87%8F%E4%BC%B0%E7%AE%97&amp;diff=1568&amp;oldid=prev</id>
		<title>Root：​新頁面: ==程式碼== &lt;SQL&gt; SELECT TD004,MB002,MB003,AMOUNT*-1 AS AMOUNT,SMC007,SMC007+AMOUNT AS DIFF  FROM(SELECT TD004,SUM(TD008) AS AMOUNT FROM (SELECT A.* FROM v_PREINOUT A JOIN (SELECT MD...</title>
		<link rel="alternate" type="text/html" href="http://tskds213.synology.me/mediawiki/index.php?title=%E9%A0%90%E8%A8%88%E5%85%83%E4%BB%B6%E7%94%A8%E9%87%8F%E4%BC%B0%E7%AE%97&amp;diff=1568&amp;oldid=prev"/>
		<updated>2015-12-15T07:19:51Z</updated>

		<summary type="html">&lt;p&gt;新頁面: ==程式碼== &amp;lt;SQL&amp;gt; SELECT TD004,MB002,MB003,AMOUNT*-1 AS AMOUNT,SMC007,SMC007+AMOUNT AS DIFF  FROM(SELECT TD004,SUM(TD008) AS AMOUNT FROM (SELECT A.* FROM v_PREINOUT A JOIN (SELECT MD...&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 TD004,MB002,MB003,AMOUNT*-1 AS AMOUNT,SMC007,SMC007+AMOUNT AS DIFF &lt;br /&gt;
FROM(SELECT TD004,SUM(TD008) AS AMOUNT FROM (SELECT A.* FROM v_PREINOUT A JOIN (SELECT MD003 FROM INVMB &lt;br /&gt;
JOIN cars ON MB002=A01 &lt;br /&gt;
JOIN BOMMD ON MD001=MB001&lt;br /&gt;
WHERE (MB031&amp;lt;&amp;#039;20151215&amp;#039; OR MB031=&amp;#039;&amp;#039;) AND MD017&amp;lt;&amp;gt;&amp;#039;4&amp;#039; GROUP BY MD003&lt;br /&gt;
 )X&lt;br /&gt;
ON TD004=MD003 WHERE TD003 BETWEEN &amp;#039;20151215&amp;#039; AND &amp;#039;20160215&amp;#039;&lt;br /&gt;
UNION ALL&lt;br /&gt;
SELECT &amp;#039;0000&amp;#039; AS TD001,&amp;#039;1234&amp;#039; AS TD002,&amp;#039;0000&amp;#039; AS TD003, MD003,(MD006/MD007*A02)*-1 AS AMOUNT,&lt;br /&gt;
&amp;#039;N&amp;#039; AS TD016,&amp;#039;20151215&amp;#039; AS TD013&lt;br /&gt;
FROM INVMB &lt;br /&gt;
JOIN cars ON MB002=A01 &lt;br /&gt;
JOIN BOMMD ON MD001=MB001&lt;br /&gt;
WHERE (MB031&amp;lt;&amp;#039;20151215&amp;#039; OR MB031=&amp;#039;&amp;#039;) AND MD017&amp;lt;&amp;gt;&amp;#039;4&amp;#039;)Y&lt;br /&gt;
GROUP BY TD004)Z&lt;br /&gt;
JOIN v_INVMC ON TD004=MC001&lt;br /&gt;
JOIN INVMB ON MB001=TD004&lt;br /&gt;
&amp;lt;/SQL&amp;gt;&lt;/div&gt;</summary>
		<author><name>Root</name></author>
	</entry>
</feed>