<?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%8A%A0%E5%B7%A5%E8%A3%BD%E7%A8%8B%E6%94%B9%E5%96%84%E8%A8%88%E5%8A%83</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%8A%A0%E5%B7%A5%E8%A3%BD%E7%A8%8B%E6%94%B9%E5%96%84%E8%A8%88%E5%8A%83"/>
	<link rel="alternate" type="text/html" href="http://tskds213.synology.me/mediawiki/index.php?title=%E5%8A%A0%E5%B7%A5%E8%A3%BD%E7%A8%8B%E6%94%B9%E5%96%84%E8%A8%88%E5%8A%83&amp;action=history"/>
	<updated>2026-11-17T02:41:34Z</updated>
	<subtitle>本 wiki 上此頁面的修訂紀錄</subtitle>
	<generator>MediaWiki 1.43.5</generator>
	<entry>
		<id>http://tskds213.synology.me/mediawiki/index.php?title=%E5%8A%A0%E5%B7%A5%E8%A3%BD%E7%A8%8B%E6%94%B9%E5%96%84%E8%A8%88%E5%8A%83&amp;diff=3035&amp;oldid=prev</id>
		<title>Root：​新頁面: ==製程停滯製令金額== &lt;SQL&gt; SELECT TA002,UDF06,TA520,TA521,TA522,TA523,TA524,TA525,TA526,TA527  ,(SELECT CASE WHEN UDF06=1 THEN CONVERT(VARCHAR,GETDATE(),111) 			 WHEN UDF06=2	A...</title>
		<link rel="alternate" type="text/html" href="http://tskds213.synology.me/mediawiki/index.php?title=%E5%8A%A0%E5%B7%A5%E8%A3%BD%E7%A8%8B%E6%94%B9%E5%96%84%E8%A8%88%E5%8A%83&amp;diff=3035&amp;oldid=prev"/>
		<updated>2018-05-30T08:47:12Z</updated>

		<summary type="html">&lt;p&gt;新頁面: ==製程停滯製令金額== &amp;lt;SQL&amp;gt; SELECT TA002,UDF06,TA520,TA521,TA522,TA523,TA524,TA525,TA526,TA527  ,(SELECT CASE WHEN UDF06=1 THEN CONVERT(VARCHAR,GETDATE(),111) 			 WHEN UDF06=2	A...&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 TA002,UDF06,TA520,TA521,TA522,TA523,TA524,TA525,TA526,TA527 &lt;br /&gt;
,(SELECT CASE WHEN UDF06=1 THEN CONVERT(VARCHAR,GETDATE(),111)&lt;br /&gt;
			 WHEN UDF06=2	AND CHARINDEX(&amp;#039;外發&amp;#039;, TA510)&amp;gt;0 THEN &amp;#039;&amp;#039;	&lt;br /&gt;
       WHEN UDF06=2 AND TA521=&amp;#039;&amp;#039; THEN CONVERT(VARCHAR,GETDATE(),111) &lt;br /&gt;
       WHEN UDF06=2 AND TA521&amp;lt;&amp;gt;&amp;#039;&amp;#039; THEN TA521 &lt;br /&gt;
       WHEN UDF06=3 AND TA523=&amp;#039;&amp;#039; THEN TA521&lt;br /&gt;
       WHEN UDF06=3 AND TA523&amp;lt;&amp;gt;&amp;#039;&amp;#039; THEN TA523&lt;br /&gt;
       WHEN UDF06=4 AND TA025=&amp;#039;&amp;#039; THEN TA523&lt;br /&gt;
       WHEN UDF06=4 AND TA025&amp;lt;&amp;gt;&amp;#039;&amp;#039; THEN TA525             &lt;br /&gt;
END)ST,&lt;br /&gt;
(SELECT CASE WHEN UDF06=1 AND TA520 &amp;lt; CONVERT(VARCHAR,GETDATE(),111) THEN CONVERT(VARCHAR,GETDATE(),111) &lt;br /&gt;
       WHEN UDF06=1 THEN TA520&lt;br /&gt;
       WHEN UDF06=2	AND CHARINDEX(&amp;#039;外發&amp;#039;, TA510)&amp;gt;0 THEN &amp;#039;&amp;#039;	       &lt;br /&gt;
       WHEN UDF06=2 AND TA522 &amp;lt; CONVERT(VARCHAR,GETDATE(),111) THEN CONVERT(VARCHAR,GETDATE(),111) &lt;br /&gt;
       WHEN UDF06=2 THEN TA522 &lt;br /&gt;
       WHEN UDF06=3 AND TA524 &amp;lt; CONVERT(VARCHAR,GETDATE(),111) THEN CONVERT(VARCHAR,GETDATE(),111) &lt;br /&gt;
       WHEN UDF06=3 THEN TA524&lt;br /&gt;
       WHEN UDF06=4 AND TA526 &amp;lt; CONVERT(VARCHAR,GETDATE(),111) THEN CONVERT(VARCHAR,GETDATE(),111) &lt;br /&gt;
       WHEN UDF06=4 AND TA026&amp;lt;&amp;gt;&amp;#039;&amp;#039; THEN TA525             &lt;br /&gt;
END)ED&lt;br /&gt;
&lt;br /&gt;
FROM MOCTA &lt;br /&gt;
WHERE TA013=&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; AND TA001=&amp;#039;5102&amp;#039; AND UDF06 BETWEEN 1 AND 4&lt;br /&gt;
&amp;lt;/SQL&amp;gt;&lt;/div&gt;</summary>
		<author><name>Root</name></author>
	</entry>
</feed>