<?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=SQL%E8%A8%88%E7%AE%97%E5%91%A8%E8%B5%B7%E8%BF%84%E6%97%A5</id>
	<title>SQL計算周起迄日 - 修訂紀錄</title>
	<link rel="self" type="application/atom+xml" href="http://tskds213.synology.me/mediawiki/index.php?action=history&amp;feed=atom&amp;title=SQL%E8%A8%88%E7%AE%97%E5%91%A8%E8%B5%B7%E8%BF%84%E6%97%A5"/>
	<link rel="alternate" type="text/html" href="http://tskds213.synology.me/mediawiki/index.php?title=SQL%E8%A8%88%E7%AE%97%E5%91%A8%E8%B5%B7%E8%BF%84%E6%97%A5&amp;action=history"/>
	<updated>2026-11-16T22:12:32Z</updated>
	<subtitle>本 wiki 上此頁面的修訂紀錄</subtitle>
	<generator>MediaWiki 1.43.5</generator>
	<entry>
		<id>http://tskds213.synology.me/mediawiki/index.php?title=SQL%E8%A8%88%E7%AE%97%E5%91%A8%E8%B5%B7%E8%BF%84%E6%97%A5&amp;diff=3518&amp;oldid=prev</id>
		<title>Stanleyliu：​已建立頁面，內容為 &quot;==BOXSIZE KEY入箱號大小== &lt;sql&gt; SELECT * FROM (SELECT DATEPART( wk, C_TIME) WEEK, CONVERT(VARCHAR,DATEADD(WEEK, DATEDIFF(WEEK,0, GETDATE()) - (DATEPART(WEEK, GE…&quot;</title>
		<link rel="alternate" type="text/html" href="http://tskds213.synology.me/mediawiki/index.php?title=SQL%E8%A8%88%E7%AE%97%E5%91%A8%E8%B5%B7%E8%BF%84%E6%97%A5&amp;diff=3518&amp;oldid=prev"/>
		<updated>2019-12-28T04:42:02Z</updated>

		<summary type="html">&lt;p&gt;已建立頁面，內容為 &amp;quot;==BOXSIZE KEY入箱號大小== &amp;lt;sql&amp;gt; SELECT * FROM (SELECT DATEPART( wk, C_TIME) WEEK, CONVERT(VARCHAR,DATEADD(WEEK, DATEDIFF(WEEK,0, GETDATE()) - (DATEPART(WEEK, GE…&amp;quot;&lt;/p&gt;
&lt;p&gt;&lt;b&gt;新頁面&lt;/b&gt;&lt;/p&gt;&lt;div&gt;==BOXSIZE KEY入箱號大小==&lt;br /&gt;
&amp;lt;sql&amp;gt;&lt;br /&gt;
SELECT * FROM (SELECT DATEPART( wk, C_TIME) WEEK,&lt;br /&gt;
CONVERT(VARCHAR,DATEADD(WEEK, DATEDIFF(WEEK,0, GETDATE()) - (DATEPART(WEEK, GETDATE()) - DATEPART( wk, C_TIME)), 0),112) ST,&lt;br /&gt;
CONVERT(VARCHAR,DATEADD(WEEK, DATEDIFF(WEEK,0, GETDATE()) - (DATEPART(WEEK, GETDATE()) - DATEPART( wk, C_TIME)), 4),112) ED,&lt;br /&gt;
count(BTA002) AMOUNT&lt;br /&gt;
FROM  BOXSIZE GROUP BY DATEPART( wk, C_TIME) )X ORDER BY WEEK&lt;br /&gt;
&amp;lt;/sql&amp;gt;&lt;/div&gt;</summary>
		<author><name>Stanleyliu</name></author>
	</entry>
</feed>