<?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=%E5%8F%B8%E6%A9%9F%E5%87%BA%E8%B2%A8%E5%AE%B9%E7%A9%8D%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=%E5%8F%B8%E6%A9%9F%E5%87%BA%E8%B2%A8%E5%AE%B9%E7%A9%8D%E4%BC%B0%E7%AE%97"/>
	<link rel="alternate" type="text/html" href="http://tskds213.synology.me/mediawiki/index.php?title=%E5%8F%B8%E6%A9%9F%E5%87%BA%E8%B2%A8%E5%AE%B9%E7%A9%8D%E4%BC%B0%E7%AE%97&amp;action=history"/>
	<updated>2026-11-17T00:06:11Z</updated>
	<subtitle>本 wiki 上此頁面的修訂紀錄</subtitle>
	<generator>MediaWiki 1.43.5</generator>
	<entry>
		<id>http://tskds213.synology.me/mediawiki/index.php?title=%E5%8F%B8%E6%A9%9F%E5%87%BA%E8%B2%A8%E5%AE%B9%E7%A9%8D%E4%BC%B0%E7%AE%97&amp;diff=3522&amp;oldid=prev</id>
		<title>Stanleyliu：​已建立頁面，內容為 &quot;&lt;SQL&gt; SELECT TA002,MA002,X.*,TA524,TA525,TA526,TA527,TA510,MOCTA.UDF06 AS PST2,ISNULL(ID,&#039;NONE&#039;) ID, ISNULL(BOXREMARK,&#039;NONE&#039;) BOXREMARK,ISNULL(V,0) V, (SELECT CASE W…&quot;</title>
		<link rel="alternate" type="text/html" href="http://tskds213.synology.me/mediawiki/index.php?title=%E5%8F%B8%E6%A9%9F%E5%87%BA%E8%B2%A8%E5%AE%B9%E7%A9%8D%E4%BC%B0%E7%AE%97&amp;diff=3522&amp;oldid=prev"/>
		<updated>2020-02-14T08:00:22Z</updated>

		<summary type="html">&lt;p&gt;已建立頁面，內容為 &amp;quot;&amp;lt;SQL&amp;gt; SELECT TA002,MA002,X.*,TA524,TA525,TA526,TA527,TA510,MOCTA.UDF06 AS PST2,ISNULL(ID,&amp;#039;NONE&amp;#039;) ID, ISNULL(BOXREMARK,&amp;#039;NONE&amp;#039;) BOXREMARK,ISNULL(V,0) V, (SELECT CASE W…&amp;quot;&lt;/p&gt;
&lt;p&gt;&lt;b&gt;新頁面&lt;/b&gt;&lt;/p&gt;&lt;div&gt;&amp;lt;SQL&amp;gt;&lt;br /&gt;
SELECT TA002,MA002,X.*,TA524,TA525,TA526,TA527,TA510,MOCTA.UDF06 AS PST2,ISNULL(ID,&amp;#039;NONE&amp;#039;) ID,&lt;br /&gt;
ISNULL(BOXREMARK,&amp;#039;NONE&amp;#039;) BOXREMARK,ISNULL(V,0) V,&lt;br /&gt;
(SELECT CASE WHEN X.UDF06 &amp;gt;&amp;#039;0&amp;#039; THEN &amp;#039;&amp;#039; ELSE &amp;#039;+&amp;#039; END) AS PST &lt;br /&gt;
FROM (SELECT TG003,TD001,TG004,TH008,TH009,TD013,TH004,TH005,TH006,TH019,COPTH.UDF03,TD002,TD003,TG002,TH003,COPTH.UDF06 &lt;br /&gt;
FROM COPTH &lt;br /&gt;
JOIN COPTG ON TG001=TH001 AND TG002=TH002 &lt;br /&gt;
JOIN COPTD ON TH014=TD001 AND TH015=TD002 AND TH016=TD003 &lt;br /&gt;
WHERE TG003 &amp;gt;&amp;#039;20151115&amp;#039; AND TD021=&amp;#039;Y&amp;#039; AND TH020=&amp;#039;N&amp;#039;)X &lt;br /&gt;
LEFT JOIN MOCTA ON TA026=TD001 AND TA027=TD002 AND TA028=TD003 &lt;br /&gt;
LEFT JOIN v_BOXSIZE ON CONTENT=TA002&lt;br /&gt;
JOIN COPMA ON MA001=TG004 &lt;br /&gt;
JOIN INVMB ON MB001=TH004 &lt;br /&gt;
WHERE TA013=&amp;#039;Y&amp;#039; AND (MB007=&amp;#039;301&amp;#039; OR TD001=&amp;#039;2202&amp;#039;) AND TG003=&amp;#039;20200214&amp;#039; ORDER BY X.UDF06,MA002,X.UDF03,TA002&lt;br /&gt;
&amp;lt;/SQL&amp;gt;&lt;/div&gt;</summary>
		<author><name>Stanleyliu</name></author>
	</entry>
</feed>