<?xml version="1.0" encoding="UTF-8"?><rss xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:content="http://purl.org/rss/1.0/modules/content/" xmlns:atom="http://www.w3.org/2005/Atom" version="2.0" xmlns:cc="http://cyber.law.harvard.edu/rss/creativeCommonsRssModule.html">
    <channel>
        <title><![CDATA[Stories by DeronChen on Medium]]></title>
        <description><![CDATA[Stories by DeronChen on Medium]]></description>
        <link>https://medium.com/@harrychen1471?source=rss-28d4c335fd94------2</link>
        <image>
            <url>https://cdn-images-1.medium.com/fit/c/150/150/0*N0SzKG0sAoR8CzvR</url>
            <title>Stories by DeronChen on Medium</title>
            <link>https://medium.com/@harrychen1471?source=rss-28d4c335fd94------2</link>
        </image>
        <generator>Medium</generator>
        <lastBuildDate>Fri, 20 Nov 2026 17:24:59 GMT</lastBuildDate>
        <atom:link href="https://medium.com/@harrychen1471/feed" rel="self" type="application/rss+xml"/>
        <webMaster><![CDATA[yourfriends@medium.com]]></webMaster>
        <atom:link href="http://medium.superfeedr.com/" rel="hub"/>
        <item>
            <title><![CDATA[Intranet Route Setting]]></title>
            <link>https://medium.com/@harrychen1471/intranet-route-setting-8ccb8eece213?source=rss-28d4c335fd94------2</link>
            <guid isPermaLink="false">https://medium.com/p/8ccb8eece213</guid>
            <dc:creator><![CDATA[DeronChen]]></dc:creator>
            <pubDate>Fri, 17 Jan 2025 03:01:32 GMT</pubDate>
            <atom:updated>2025-01-17T03:01:32.990Z</atom:updated>
            <content:encoded><![CDATA[<p>When going to the client, usually need to connect to the other party&#39;s intranet, and after plugging into the intranet, you cannot use your own wifi to call the external network, and a warning will be issued. In this case, we hope to direct the route of the intranet to the test environment only, and connect Always use your own wifi when accessing external networks</p><p>Example:</p><ul><li>plugging Intranet line</li><li>use admin mode，open command line</li><li>route print</li></ul><figure><img alt="" src="https://cdn-images-1.medium.com/max/800/1*Kpt1LjqtDSqY-l5Es7z92w.png" /><figcaption>picture 1</figcaption></figure><ul><li>delete 0.0.0.0 default route，[if] is Intranet use network adapter(ref picture 1)</li></ul><figure><img alt="" src="https://cdn-images-1.medium.com/max/978/1*PtFBD_tof5YDP38ZXb5jcg.png" /><figcaption>picture 2</figcaption></figure><ul><li>Add route settings Intranet need</li></ul><p>IP:10.8.210.0</p><p>Mask:255.255.255.0</p><p>Gateway:10.8.62.128</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/978/1*PtFBD_tof5YDP38ZXb5jcg.png" /><figcaption>picture 3</figcaption></figure><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=8ccb8eece213" width="1" height="1" alt="">]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[C# string vs StringBuilder performance issue]]></title>
            <link>https://medium.com/@harrychen1471/c-string-vs-stringbuilder-performance-issue-2000d651c955?source=rss-28d4c335fd94------2</link>
            <guid isPermaLink="false">https://medium.com/p/2000d651c955</guid>
            <dc:creator><![CDATA[DeronChen]]></dc:creator>
            <pubDate>Tue, 10 Dec 2024 02:19:41 GMT</pubDate>
            <atom:updated>2024-12-23T06:16:43.553Z</atom:updated>
            <content:encoded><![CDATA[<p>I have a project which need to export a large .txt file. When I was programming. I found a performance issue.</p><p>Then I continue to trace.I found that company’s underlying logic has a bug. They used string to stroe the result, and it would be modified frequently. It is the reason why low performance.</p><pre>private string ParseBlock(Type type, object model, string separator, string frontRearChar, out string errorMessage)<br> {<br>     errorMessage = &quot;&quot;;<br><br>     foreach (var property in props)<br>     {<br>         var genErrorMessage = &quot;&quot;;<br>         result += ParseBlock(genType, genData, attr.Separator, attr.FrontRearChar, out genErrorMessage);<br>         errorMessage += genErrorMessage;<br>     }<br><br>     return result;<br> }</pre><p>After found the issue, I change the variable to StringBuilder. Then performance up up.I don’t remember the actually difference times. But I vaguely remember the difference between hours and minutes.</p><pre>  private string ParseBlock(Type type, object model, string separator, string frontRearChar, out string errorMessage)<br>  {<br>      errorMessage = &quot;&quot;;<br>      StringBuilder resultBuilder = new StringBuilder();<br><br>      foreach (var property in props)<br>      {<br>           var genErrorMessage = &quot;&quot;;<br>            resultBuilder.Append(ParseBlock(genType, genData, attr.Separator, attr.FrontRearChar, out genErrorMessage));<br>            errorMessage += genErrorMessage;<br>      }<br><br>      return resultBuilder.ToString();<br>  }</pre><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=2000d651c955" width="1" height="1" alt="">]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[IBM MQ Error Code 2195]]></title>
            <link>https://medium.com/@harrychen1471/ibm-mq-error-code-2195-e35825d8cfc3?source=rss-28d4c335fd94------2</link>
            <guid isPermaLink="false">https://medium.com/p/e35825d8cfc3</guid>
            <dc:creator><![CDATA[DeronChen]]></dc:creator>
            <pubDate>Mon, 09 Dec 2024 03:28:18 GMT</pubDate>
            <atom:updated>2024-12-23T02:52:52.024Z</atom:updated>
            <content:encoded><![CDATA[<p>I have a request for EOS .net framework to .net core. There is a important part inside for connection with server and client use IBM MQ.</p><blockquote>Envirment:</blockquote><blockquote>Client: .Net core, and MQ client version was 9.4.3 and not install IBM MQ client.</blockquote><blockquote>Server: IBM MQ 9.0.3</blockquote><p>When I request to IBM MQ server. I got error as picture below. There are no answers on the internet about error code 2195, and the official document states 2195 that is an unexpected error.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/585/1*mgEDyS8D2LMlc-Gue9eWbQ.png" /></figure><p>I guess that maybe server version can’t lower than clent, so I was using an lower IBM MQ client version(9.0.3). Got the same error code!! Then I tried to use old project which in production is working now to try to establish a connection. Old project use IBM MQ client 1.0.4. Got the same error code!!</p><p>With a ‘desperate times call for desperate measures’ mindset, I decided to install the IBM MQ client exe (<a href="https://www.ibm.com/docs/zh-tw/ibm-mq/9.2?topic=windows-installing-mq-client">https://www.ibm.com/docs/zh-tw/ibm-mq/9.2?topic=windows-installing-mq-client</a>). Then it was work!</p><p>But the official document says that after version 8.0 can run with no full client install(<a href="https://www.ibm.com/docs/en/ibm-mq/9.0?topic=overview-redistributable-clients">Redistributable clients — IBM Documentation</a>).</p><p>Finally I revert project to .net framework 4.8 and IBM MQ 9.0.3 and install IBM MQ client exe 9.3, it is working now.</p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=e35825d8cfc3" width="1" height="1" alt="">]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[Revolution 
Experience]]></title>
            <link>https://medium.com/@harrychen1471/revolution-experience-d1ad373c79f3?source=rss-28d4c335fd94------2</link>
            <guid isPermaLink="false">https://medium.com/p/d1ad373c79f3</guid>
            <dc:creator><![CDATA[DeronChen]]></dc:creator>
            <pubDate>Fri, 15 Nov 2024 02:05:13 GMT</pubDate>
            <atom:updated>2024-11-15T02:05:13.896Z</atom:updated>
            <content:encoded><![CDATA[<h3>Revolution Experience</h3><p>I am just a senior engineer, but I still have lots of ideas for the future of the company. When I share what I hope the department will do in the meeting. Other employee usually show lack out of interest.</p><p>So I know if the company is a train. Not everyone is a locomotive. Most people are carriages, but they still important. Locomotive can lead everyone to action. Carriage can carry more people. Just different responsibilities.</p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=d1ad373c79f3" width="1" height="1" alt="">]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[Data is getting truncated when using SqlCommand in C#]]></title>
            <link>https://medium.com/@harrychen1471/data-is-getting-truncated-when-using-sqlcommand-in-c-f47014160e7e?source=rss-28d4c335fd94------2</link>
            <guid isPermaLink="false">https://medium.com/p/f47014160e7e</guid>
            <dc:creator><![CDATA[DeronChen]]></dc:creator>
            <pubDate>Tue, 29 Oct 2024 09:15:45 GMT</pubDate>
            <atom:updated>2024-10-29T09:16:23.670Z</atom:updated>
            <content:encoded><![CDATA[<p>I received a request to convert all the stored procedures into SQL command text. At the beginning, it was done quickly because I just found the stored procedures in SSMS and pasted them into C#. However, when I started testing, I encountered a problem.</p><p>Code is like that</p><pre>public DataSet getQueryPayment(string para1, string para2, string para3, string para4, string para5)<br>{<br>    SqlParameter[] parameters = <br>        {<br>            new SqlParameter(&quot;@para1&quot;, SqlDbType.NVarChar),<br>            new SqlParameter(&quot;@para2&quot;, SqlDbType.NVarChar),<br>            new SqlParameter(&quot;@para3&quot;, SqlDbType.NVarChar),<br>            new SqlParameter(&quot;@para4&quot;, SqlDbType.NVarChar),<br>            new SqlParameter(&quot;@para5&quot;, SqlDbType.NVarChar),<br>        };<br>    parameters[0].Value = para1;<br>    parameters[1].Value = para2;<br>    parameters[2].Value = para3;<br>    parameters[3].Value = para4;<br>    parameters[4].Value = para5;<br><br>    var sqlText = @&quot;VERY LONG WORD VERY LONG WORD VERY LONG WORD &#39;&#39;&#39; + @para1+ &#39;&#39;&#39; And A.para1= &#39;&#39;&#39; + @para1+ &#39;&#39;&#39; <br>                   And A.para1= &#39;&#39;&#39; + @para1+ &#39;&#39;&#39; And A.para1= &#39;&#39;&#39; + @para1+ &#39;&#39;&#39;<br>                   VERY LONG WORD<br>                    &#39;<br><br>                    exec sp_executesql @strSQL<br>                    &quot;;<br><br>    return RunCommandText(sqlText, parameters);<br>}</pre><p>There was an error, and the error message indicated that the data was truncated.</p><p>But it works successfully in the stored procedure.</p><p>So first, I retrieved the SQL text from the stored procedure and tried to run it, and it was still successful.</p><p>And then, I print the SQL text and compare with my code in C#, it’s still the same again.</p><p>So I felt confused; there shouldn’t be two different results for the same piece of code. However, I later found this article: <a href="https://stackoverflow.com/questions/55415146/when-is-nvarcharmax-nvarchar4000">https://stackoverflow.com/questions/55415146/when-is-nvarcharmax-nvarchar4000</a>.</p><p>When concatenating strings, if NVarchar(max) is combined with a non-MAX type or varchar, the final type becomes NVarchar(4000). So I looked further into the code from this perspective. When C# passes the parameters, they are already converted to a type. Therefore, the original</p><pre>&#39;VERYLONG WORD &#39;&#39;&#39; + @para1 + &#39;&#39;&#39;&#39;</pre><p>has been converted to</p><pre>&#39;VERYLONGWORD &#39;&#39;&#39; + &#39;XXX&#39; + &#39;&#39;&#39;&#39;</pre><p>, and this ‘XXX’ is definitely not NVarchar(max).</p><p>The solution I ultimately adopted was add CAST(@para,NVARCHAR(MAX)) to every parameter.</p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=f47014160e7e" width="1" height="1" alt="">]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[FTP、FTPS、SFTP]]></title>
            <link>https://medium.com/@harrychen1471/ftp-ftps-sftp-9f39d09b57fe?source=rss-28d4c335fd94------2</link>
            <guid isPermaLink="false">https://medium.com/p/9f39d09b57fe</guid>
            <dc:creator><![CDATA[DeronChen]]></dc:creator>
            <pubDate>Mon, 28 Oct 2024 07:40:52 GMT</pubDate>
            <atom:updated>2024-10-28T07:40:52.901Z</atom:updated>
            <content:encoded><![CDATA[<p>When developing FTP, do you often encounter the following problems?</p><blockquote>Which port should FTP use? 21? Or are there others?</blockquote><blockquote>Which port should FTPS use?</blockquote><blockquote>Which port should SFTP use?</blockquote><blockquote>Which type of transmission is the most secure? Which type of transmission is the fastest?</blockquote><h3>FTP</h3><p>FTP has the following two modes:</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/984/1*azep93vSA8wt86unFROV5Q.png" /></figure><p><strong>Active Mode:</strong></p><ol><li>Client informs the Server which Data Port to use.</li><li>Server acknowledges (Ack).</li><li>Server actively connects to the Client using the specified port.</li><li>Client acknowledges (Ack).</li></ol><p><strong>Passive Mode (PASV):</strong></p><ol><li>Client informs the Server that it is using Passive Mode.</li><li>Server informs the Client of the Data Port.</li><li>Client connects to the Server using the specified Data Port.</li><li>Server acknowledges (Ack).</li></ol><figure><img alt="" src="https://cdn-images-1.medium.com/max/971/1*ynknDF4YEDZgLr6AJjwjIg.png" /></figure><h3><strong>FTPS（FTP Secure）</strong></h3><p>1. A variant of the traditional FTP protocol that adds a layer of security (SSL/TLS) for encrypting data transmission and authentication.<br>2. It uses either implicit or explicit SSL/TLS connections.<br> Implicit FTP encrypts the connection immediately upon establishment.<br> Explicit FTP initially uses an unencrypted connection, requiring the client to explicitly request a secure connection by sending the AUTH TLS or AUTH SSL command before sending user credentials. This requests the server to switch the command channel to an SSL-encrypted channel. Once the channel is successfully established, the user credentials are sent to the FTP server, ensuring that any commands during the session are automatically encrypted via the SSL channel.<br>3. The Command Port is 990, and in PASV mode, the server must set a port range.<br>4. IIS FTP Service can be used to set up FTPS, but it’s important to confirm the limit on the number of simultaneous connections.</p><h3>SFTP</h3><p>A subprotocol based on the SSH protocol, used for secure file transfer. It provides encryption and authentication for data.<br>The Command Port is 22.<br>It is considered one of the most secure file transfer protocols.</p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=9f39d09b57fe" width="1" height="1" alt="">]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[PartitionTable Implementation]]></title>
            <link>https://medium.com/@harrychen1471/partitiontable-implementation-5d8a2995c01c?source=rss-28d4c335fd94------2</link>
            <guid isPermaLink="false">https://medium.com/p/5d8a2995c01c</guid>
            <dc:creator><![CDATA[DeronChen]]></dc:creator>
            <pubDate>Wed, 23 Oct 2024 04:16:28 GMT</pubDate>
            <atom:updated>2024-10-23T05:41:27.790Z</atom:updated>
            <content:encoded><![CDATA[<h3>Partition Table Implementation</h3><p>Partition Table 雖然能增進效能，但還是有一些限制，例如Table需要一開始就定義為Partition、若超過定義的年限會較麻煩，較常見的作法是將切割的方法改為用除法，每10年一個循環。</p><p>這邊提供另一種做法，可以動態擴增partition Table的切割區，若已熟悉如何建立可以直接跳到最後一段。</p><p>新增 FileGroup, ndfFile</p><pre>CREATE DATABASE [TESTDB_History] ON<br>PRIMARY ( NAME = N&#39;TESTDB_History&#39;, FILENAME = N&#39;C:\Users\Harry\TESTDB_History.mdf&#39; , SIZE = 5120KB , MAXSIZE = UNLIMITED, FILEGROWTH = 1024KB ),<br>FILEGROUP [FG1] ( NAME = N&#39;TESTDB_History2010&#39;, FILENAME = N&#39;C:\Users\Harry\TESTDB_History2010.ndf&#39; , SIZE = 5120KB , MAXSIZE = UNLIMITED, FILEGROWTH = 1024KB ),<br>FILEGROUP [FG2] ( NAME = N&#39;TESTDB_History2011&#39;, FILENAME = N&#39;C:\Users\Harry\TESTDB_History2011.ndf&#39; , SIZE = 5120KB , MAXSIZE = UNLIMITED, FILEGROWTH = 1024KB ),<br>FILEGROUP [FG3] ( NAME = N&#39;TESTDB_History2012&#39;, FILENAME = N&#39;C:\Users\Harry\TESTDB_History2012.ndf&#39; , SIZE = 5120KB , MAXSIZE = UNLIMITED, FILEGROWTH = 1024KB ),<br>FILEGROUP [FG4] ( NAME = N&#39;TESTDB_History2013&#39;, FILENAME = N&#39;C:\Users\Harry\TESTDB_History2013.ndf&#39; , SIZE = 5120KB , MAXSIZE = UNLIMITED, FILEGROWTH = 1024KB )<br>LOG ON ( NAME = N&#39;TESTDB_History_log&#39;, FILENAME = N&#39;C:\Users\Harry\TESTDB_History_log.ldf&#39; , SIZE = 1024KB , MAXSIZE = UNLIMITED , FILEGROWTH = 10%)<br>GO<br><br>ALTER DATABASE [TESTDB_History] <br>ADD FILEGROUP [TESTDB_History_FG2019] <br><br>ALTER DATABASE TESTDB_History <br>ADD FILE <br>(<br>    NAME = N&#39;TESTDB_History2019&#39;,<br>    FILENAME = &#39;C:\Users\Harry\TESTDB_History2019.ndf&#39;,<br>    SIZE = 5120KB,<br>    MAXSIZE = UNLIMITED,<br>    FILEGROWTH = 1024KB<br>  <br>)<br>TO FILEGROUP [TESTDB_History_FG2019];<br>GO<br><br>ALTER DATABASE [TESTDB_History] <br>ADD FILEGROUP [TESTDB_History_FG2020] <br><br>ALTER DATABASE TESTDB_History <br>ADD FILE <br>(<br>    NAME = N&#39;TESTDB_History2020&#39;,<br>    FILENAME = &#39;C:\Users\Harry\TESTDB_History2020.ndf&#39;,<br>    SIZE = 5120KB,<br>    MAXSIZE = UNLIMITED,<br>    FILEGROWTH = 1024KB<br>  <br>)<br>TO FILEGROUP [TESTDB_History_FG2020];<br>GO<br><br>ALTER DATABASE [TESTDB_History] <br>ADD FILEGROUP [TESTDB_History_FG2021] <br><br>ALTER DATABASE TESTDB_History <br>ADD FILE <br>(<br>    NAME = N&#39;TESTDB_History2021&#39;,<br>    FILENAME = &#39;C:\Users\Harry\TESTDB_History2021.ndf&#39;,<br>    SIZE = 5120KB,<br>    MAXSIZE = UNLIMITED,<br>    FILEGROWTH = 1024KB<br>  <br>)<br>TO FILEGROUP [TESTDB_History_FG2021];<br>GO<br><br>use TESTDB_History<br><br>CREATE PARTITION FUNCTION P_Func(datetime2(7))<br>AS RANGE RIGHT<br>FOR VALUES (&#39;2020/01/01&#39;, &#39;2021/01/01&#39;);<br>GO<br>/*<br>這個範例使用三個 datetime 型別的值來間隔分割區。<br>       2020/1/1    2021/1/1    2022/1/1 <br>   r1     ↓    r2    ↓    r3    ↓    r4<br>----------。----------。----------。----------<br>RIGHT 數字表示間隔值本身包含在右邊區間，所以四個區間的範圍如下：<br>  <br>PartitionNumber Partition Range<br>=============== ===================================<br>1                              range1 &lt; 2011/01/01<br>2               2011/01/01 &lt;=  range2 &lt; 2012/01/01<br>3               2012/01/01 &lt;=  range3 &lt; 2013/01/01<br>4               2013/01/01 &lt;=  range4 <br>*/<br><br><br>-- 四個分割都使用不同的檔案群組 <br>CREATE PARTITION SCHEME P_Scheme<br>AS PARTITION P_Func TO (TESTDB_History_FG2019, TESTDB_History_FG2020, TESTDB_History_FG2021);<br>GO</pre><p>新增查看group function</p><pre>DROP FUNCTION PartitionInfo<br>GO<br> <br>CREATE FUNCTION PartitionInfo( @tablename sysname ) RETURNS table<br>AS RETURN<br> SELECT<br> OBJECT_NAME(p.object_id) as TableName<br> ,p.partition_number as PartitionNumber<br> ,prv_left.value as LowerBoundary<br> ,prv_right.value as  UpperBoundary<br> ,ps.name as PartitionScheme<br> ,pf.name as PartitionFunction<br> ,fg.name as FileGroupName<br> ,CAST(p.used_page_count * 8.0 / 1024 AS NUMERIC(18,2)) AS UsedPages_MB<br> ,p.row_count as Rows<br> FROM  sys.dm_db_partition_stats p<br> INNER JOIN sys.indexes i ON i.object_id = p.object_id AND i.index_id = p.index_id<br> INNER JOIN sys.partition_schemes ps ON ps.data_space_id = i.data_space_id<br> INNER JOIN sys.partition_functions pf ON ps.function_id = pf.function_id<br> INNER JOIN sys.destination_data_spaces dds ON dds.partition_scheme_id = ps.data_space_id AND dds.destination_id = p.partition_number<br> INNER JOIN sys.filegroups fg ON fg.data_space_id = dds.data_space_id<br> LEFT  JOIN sys.partition_range_values prv_right ON prv_right.function_id = ps.function_id AND prv_right.boundary_id = p.partition_number<br> LEFT  JOIN sys.partition_range_values prv_left  ON prv_left.function_id = ps.function_id AND prv_left.boundary_id = p.partition_number - 1<br> WHERE<br> p.object_id = OBJECT_ID(@tablename) <br>GO</pre><p>新增 Table Index指向對應的 Function</p><pre>-- Orders<br>IF OBJECT_ID(&#39;TransactionCHTs&#39;, &#39;U&#39;) IS NOT NULL<br>BEGIN<br>    DROP TABLE TransactionCHTs<br>END<br>GO<br><br>CREATE TABLE [dbo].[TransactionCHTs](<br> [SerialId] [bigint] ,<br> [DueDate] [datetime2](7) NOT NULL,<br> [PID] [nvarchar](10) NULL,<br> [OfficeCode] [nvarchar](4) NULL,<br> [TelNo] [nvarchar](20) NULL,<br> [IDOld] [nvarchar](1) NULL,<br> [OfficeCodeOld] [nvarchar](4) NULL,<br> [TelNoOld] [nvarchar](20) NULL,<br> [BillId] [nvarchar](5) NULL,<br> [BillYearMonth] [nvarchar](5) NOT NULL,<br> [CheckCode] [nvarchar](2) NULL,<br> [CompanyCode] [nvarchar](3) NULL,<br> [AdminisOffice] [nvarchar](1) NULL,<br> [System] [nvarchar](1) NULL,<br> [CreateUserId] [int] NULL,<br> [CreateUser] [nvarchar](50) NULL,<br> [CreateDate] [datetime2](7) NULL,<br> [ModiUserId] [int] NULL,<br> [ModiDate] [datetime2](7) NULL,<br> [ModiUser] [nvarchar](50) NULL,<br> [ImportBatchNo] [nvarchar](30) NOT NULL,<br> [RawData] [nvarchar](max) NOT NULL,<br> [Hostenum] [int] NOT NULL,<br> [PayDate] [datetime2](7) NULL,<br> [ReturnCode] [nvarchar](5) NULL,<br> [MainControlSetId] [bigint] NOT NULL,<br> [SplitSubControlSetId] [bigint] NULL,<br> [Status] [nvarchar](5) NULL,<br> [AccountNo] [nvarchar](35) NOT NULL,<br> [Amount] [decimal](18, 4) NOT NULL,<br> [CurrentAccountNo] [nvarchar](35) NOT NULL,<br> [TradeStatus] [int] NOT NULL,<br> [ECStatus] [int] NOT NULL,<br> [TradeTypeenum] [int] NOT NULL,<br> [AAAAccountNo] [nvarchar](16) NULL,<br> [SortKey] [int] NOT NULL,<br> [AuthorizeStatus] [int] NOT NULL,<br> [ChargeFee] [decimal](18, 4) NOT NULL,<br> [MergeSubControlSetId] [bigint] NULL,<br> [BranchCode] [nvarchar](5) NULL,<br> [FISCBranchCode] [nvarchar](5) NULL,<br> [TradeBranchCode] [nvarchar](5) NULL,<br> [AccountingSubject] [nvarchar](3) NULL,<br> [ExpectedPayDate] [datetime2](7) NOT NULL,<br> [TransDate] [datetime2](7) NULL,<br> [ChiefBranchCode] [nvarchar](5) NULL,<br> [AccountNoId] [nvarchar](1) NULL,<br> [ErrorMessage] [nvarchar](40) NULL,<br> [Filler] [nvarchar](76) NULL,<br> [CMIBUSI1] [nvarchar](35) NULL,<br> [CMIBUSI2] [nvarchar](35) NULL,<br> [AccountType] [int] NULL,<br> [IsChangeAccountNo] [bit] NOT NULL,<br> CONSTRAINT [PK_TransactionCHTs] PRIMARY KEY CLUSTERED <br>(<br> [SerialId] ASC<br> ,[DueDate]<br>)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]<br>) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]<br>GO<br> <br> -- Partitioned Non-Clustered INDEX, 欄位與 PKEY 相同, 主要是在驗證其所在的 FileGroup<br>CREATE UNIQUE NONCLUSTERED INDEX [UK_TransactionCHTs_ON_P_Scheme] <br>ON [TransactionCHTs] ( [SerialId],[DueDate]  ) <br>ON [P_Scheme]([DueDate])<br>GO</pre><p>嘗試寫入資料</p><pre>SELECT * FROM PartitionInfo(&#39;TransactionCHTs&#39;);<br><br>delete from TransactionCHTs<br><br>select * from TransactionCHTs<br><br><br>INSERT [dbo].[TransactionCHTs] ([SerialId], [DueDate], [PID], [OfficeCode], [TelNo], [IDOld], [OfficeCodeOld], [TelNoOld], [BillId], [BillYearMonth], [CheckCode], [CompanyCode], [AdminisOffice], [System], [CreateUserId], [CreateUser], [CreateDate], [ModiUserId], [ModiDate], [ModiUser], [ImportBatchNo], [RawData], [Hostenum], [PayDate], [ReturnCode], [MainControlSetId], [SplitSubControlSetId], [Status], [AccountNo], [Amount], [CurrentAccountNo], [TradeStatus], [ECStatus], [TradeTypeenum], [AAAAccountNo], [SortKey], [AuthorizeStatus], [ChargeFee], [MergeSubControlSetId], [BranchCode], [FISCBranchCode], [TradeBranchCode], [AccountingSubject], [ExpectedPayDate], [TransDate], [ChiefBranchCode], [AccountNoId], [ErrorMessage], [Filler], [AccountType], [CMIBUSI1], [CMIBUSI2], [IsChangeAccountNo]) VALUES (43, CAST(N&#39;2020-01-01 00:00:00.000&#39; AS DateTime2), N&#39;K100791177&#39;, N&#39;35&#39;, N&#39;1530383&#39;, N&#39;&#39;, N&#39;&#39;, N&#39;&#39;, N&#39;&#39;, N&#39;11110&#39;, N&#39;&#39;, N&#39;&#39;, N&#39;N&#39;, N&#39;G&#39;, -1, N&#39;System&#39;, CAST(N&#39;2022-11-25T11:09:57.4515794&#39; AS DateTime2), -1, CAST(N&#39;2022-11-25T17:36:15.3267443&#39; AS DateTime2), N&#39;System&#39;, N&#39;PU202211250000001&#39;, N&#39;2100200662777  00000012035               1530383K1007911771                                      11110  1122   NG       &#39;, 1, CAST(N&#39;2023-10-02T15:13:34.6900000&#39; AS DateTime2), N&#39;0000&#39;, 355, 356, N&#39;98&#39;, N&#39;100200662777&#39;, CAST(120.0000 AS Decimal(18, 4)), N&#39;100200662777&#39;, 1, 0, 0, N&#39;&#39;, 0, 0, CAST(10.0000 AS Decimal(18, 4)), NULL, N&#39;100&#39;, NULL, NULL, N&#39;220&#39;, CAST(N&#39;2022-11-25T11:09:57.3210704&#39; AS DateTime2), NULL, N&#39;1000&#39;, N&#39;1&#39;, N&#39;&#39;, N&#39;&#39;, NULL, NULL, NULL, 0)<br>GO<br>INSERT [dbo].[TransactionCHTs] ([SerialId], [DueDate], [PID], [OfficeCode], [TelNo], [IDOld], [OfficeCodeOld], [TelNoOld], [BillId], [BillYearMonth], [CheckCode], [CompanyCode], [AdminisOffice], [System], [CreateUserId], [CreateUser], [CreateDate], [ModiUserId], [ModiDate], [ModiUser], [ImportBatchNo], [RawData], [Hostenum], [PayDate], [ReturnCode], [MainControlSetId], [SplitSubControlSetId], [Status], [AccountNo], [Amount], [CurrentAccountNo], [TradeStatus], [ECStatus], [TradeTypeenum], [AAAAccountNo], [SortKey], [AuthorizeStatus], [ChargeFee], [MergeSubControlSetId], [BranchCode], [FISCBranchCode], [TradeBranchCode], [AccountingSubject], [ExpectedPayDate], [TransDate], [ChiefBranchCode], [AccountNoId], [ErrorMessage], [Filler], [AccountType], [CMIBUSI1], [CMIBUSI2], [IsChangeAccountNo]) VALUES (44, CAST(N&#39;2022-11-12T00:00:00.0000000&#39; AS DateTime2), N&#39;J102815713&#39;, N&#39;35&#39;, N&#39;1584316&#39;, N&#39;&#39;, N&#39;&#39;, N&#39;&#39;, N&#39;&#39;, N&#39;11110&#39;, N&#39;&#39;, N&#39;&#39;, N&#39;N&#39;, N&#39;G&#39;, -1, N&#39;System&#39;, CAST(N&#39;2022-11-25T11:09:57.4515815&#39; AS DateTime2), -1, CAST(N&#39;2022-11-25T17:36:15.3267469&#39; AS DateTime2), N&#39;System&#39;, N&#39;PU202211250000001&#39;, N&#39;2100200662777  00000024035               1584316J1028157131                                      11110  1122   NG       &#39;, 1, CAST(N&#39;2023-10-02T15:13:34.6900000&#39; AS DateTime2), N&#39;0002&#39;, 355, 356, N&#39;98&#39;, N&#39;100200662777&#39;, CAST(240.0000 AS Decimal(18, 4)), N&#39;100200662777&#39;, 2, 0, 0, N&#39;&#39;, 1, 0, CAST(10.0000 AS Decimal(18, 4)), NULL, N&#39;100&#39;, NULL, NULL, N&#39;220&#39;, CAST(N&#39;2022-11-25T11:09:57.3211416&#39; AS DateTime2), NULL, N&#39;1000&#39;, N&#39;1&#39;, N&#39;帳號ＩＤ有誤&#39;, N&#39;&#39;, NULL, NULL, NULL, 0)<br>GO<br>INSERT [dbo].[TransactionCHTs] ([SerialId], [DueDate], [PID], [OfficeCode], [TelNo], [IDOld], [OfficeCodeOld], [TelNoOld], [BillId], [BillYearMonth], [CheckCode], [CompanyCode], [AdminisOffice], [System], [CreateUserId], [CreateUser], [CreateDate], [ModiUserId], [ModiDate], [ModiUser], [ImportBatchNo], [RawData], [Hostenum], [PayDate], [ReturnCode], [MainControlSetId], [SplitSubControlSetId], [Status], [AccountNo], [Amount], [CurrentAccountNo], [TradeStatus], [ECStatus], [TradeTypeenum], [AAAAccountNo], [SortKey], [AuthorizeStatus], [ChargeFee], [MergeSubControlSetId], [BranchCode], [FISCBranchCode], [TradeBranchCode], [AccountingSubject], [ExpectedPayDate], [TransDate], [ChiefBranchCode], [AccountNoId], [ErrorMessage], [Filler], [AccountType], [CMIBUSI1], [CMIBUSI2], [IsChangeAccountNo]) VALUES (45, CAST(N&#39;2021-11-12T00:00:00.0000000&#39; AS DateTime2), N&#39;J102849915&#39;, N&#39;35&#39;, N&#39;1585302&#39;, N&#39;&#39;, N&#39;&#39;, N&#39;&#39;, N&#39;&#39;, N&#39;11110&#39;, N&#39;&#39;, N&#39;&#39;, N&#39;N&#39;, N&#39;G&#39;, -1, N&#39;System&#39;, CAST(N&#39;2022-11-25T11:09:57.4515817&#39; AS DateTime2), -1, CAST(N&#39;2022-11-25T17:36:15.3267470&#39; AS DateTime2), N&#39;System&#39;, N&#39;PU202211250000001&#39;, N&#39;2301200392321  00000032135               1585302J1028499151                                      11110  1122   NG       &#39;, 1, CAST(N&#39;2023-10-02T15:13:34.6900000&#39; AS DateTime2), N&#39;0010&#39;, 355, 356, N&#39;98&#39;, N&#39;301200392321&#39;, CAST(321.0000 AS Decimal(18, 4)), N&#39;301200392321&#39;, 2, 0, 0, N&#39;&#39;, 2, 0, CAST(10.0000 AS Decimal(18, 4)), NULL, N&#39;301&#39;, NULL, NULL, N&#39;220&#39;, CAST(N&#39;2022-11-25T11:09:57.3211516&#39; AS DateTime2), NULL, N&#39;3010&#39;, N&#39;1&#39;, N&#39;無此帳戶&#39;, N&#39;&#39;, NULL, NULL, NULL, 0)<br>GO<br>INSERT [dbo].[TransactionCHTs] ([SerialId], [DueDate], [PID], [OfficeCode], [TelNo], [IDOld], [OfficeCodeOld], [TelNoOld], [BillId], [BillYearMonth], [CheckCode], [CompanyCode], [AdminisOffice], [System], [CreateUserId], [CreateUser], [CreateDate], [ModiUserId], [ModiDate], [ModiUser], [ImportBatchNo], [RawData], [Hostenum], [PayDate], [ReturnCode], [MainControlSetId], [SplitSubControlSetId], [Status], [AccountNo], [Amount], [CurrentAccountNo], [TradeStatus], [ECStatus], [TradeTypeenum], [AAAAccountNo], [SortKey], [AuthorizeStatus], [ChargeFee], [MergeSubControlSetId], [BranchCode], [FISCBranchCode], [TradeBranchCode], [AccountingSubject], [ExpectedPayDate], [TransDate], [ChiefBranchCode], [AccountNoId], [ErrorMessage], [Filler], [AccountType], [CMIBUSI1], [CMIBUSI2], [IsChangeAccountNo]) VALUES (49, CAST(N&#39;2019-11-12T00:00:00.0000000&#39; AS DateTime2), N&#39;&#39;, N&#39;292&#39;, N&#39;22437821&#39;, N&#39;&#39;, N&#39;&#39;, N&#39;&#39;, N&#39;&#39;, N&#39;11110&#39;, N&#39;31&#39;, N&#39;200&#39;, N&#39;N&#39;, N&#39;&#39;, -1, N&#39;System&#39;, CAST(N&#39;2022-11-28T14:35:14.8895416&#39; AS DateTime2), -1, CAST(N&#39;2022-11-28T14:35:15.1852413&#39; AS DateTime2), N&#39;System&#39;, N&#39;PU202211280000002&#39;, N&#39;210000100020928000000070292             22437821                                                 11110311122200N        &#39;, 1, CAST(N&#39;2023-10-02T15:13:34.6900000&#39; AS DateTime2), NULL, 378, 379, NULL, N&#39;10000100020928&#39;, CAST(70.0000 AS Decimal(18, 4)), N&#39;000100020928&#39;, 0, 0, 0, NULL, 0, 0, CAST(10.0000 AS Decimal(18, 4)), NULL, N&#39;000&#39;, NULL, NULL, N&#39;200&#39;, CAST(N&#39;2022-11-28T14:35:14.7501532&#39; AS DateTime2), NULL, N&#39;1000&#39;, N&#39;&#39;, NULL, NULL, NULL, NULL, NULL, 0)<br>GO<br>INSERT [dbo].[TransactionCHTs] ([SerialId], [DueDate], [PID], [OfficeCode], [TelNo], [IDOld], [OfficeCodeOld], [TelNoOld], [BillId], [BillYearMonth], [CheckCode], [CompanyCode], [AdminisOffice], [System], [CreateUserId], [CreateUser], [CreateDate], [ModiUserId], [ModiDate], [ModiUser], [ImportBatchNo], [RawData], [Hostenum], [PayDate], [ReturnCode], [MainControlSetId], [SplitSubControlSetId], [Status], [AccountNo], [Amount], [CurrentAccountNo], [TradeStatus], [ECStatus], [TradeTypeenum], [AAAAccountNo], [SortKey], [AuthorizeStatus], [ChargeFee], [MergeSubControlSetId], [BranchCode], [FISCBranchCode], [TradeBranchCode], [AccountingSubject], [ExpectedPayDate], [TransDate], [ChiefBranchCode], [AccountNoId], [ErrorMessage], [Filler], [AccountType], [CMIBUSI1], [CMIBUSI2], [IsChangeAccountNo]) VALUES (50, CAST(N&#39;2018-11-12T00:00:00.0000000&#39; AS DateTime2), N&#39;&#39;, N&#39;223&#39;, N&#39;23310552&#39;, N&#39;&#39;, N&#39;&#39;, N&#39;&#39;, N&#39;&#39;, N&#39;11110&#39;, N&#39;32&#39;, N&#39;200&#39;, N&#39;N&#39;, N&#39;&#39;, -1, N&#39;System&#39;, CAST(N&#39;2022-11-28T14:35:14.8895437&#39; AS DateTime2), -1, CAST(N&#39;2022-11-28T14:35:15.1852426&#39; AS DateTime2), N&#39;System&#39;, N&#39;PU202211280000002&#39;, N&#39;210000200662777000000030223             23310552                                                 11110321122200N        &#39;, 1, CAST(N&#39;2023-10-02T15:13:34.6900000&#39; AS DateTime2), NULL, 378, 379, NULL, N&#39;10000200662777&#39;, CAST(30.0000 AS Decimal(18, 4)), N&#39;000200662777&#39;, 0, 0, 0, NULL, 1, 0, CAST(10.0000 AS Decimal(18, 4)), NULL, N&#39;000&#39;, NULL, NULL, N&#39;200&#39;, CAST(N&#39;2022-11-28T14:35:14.7502333&#39; AS DateTime2), NULL, N&#39;1000&#39;, N&#39;&#39;, NULL, NULL, NULL, NULL, NULL, 0)<br>GO<br>INSERT [dbo].[TransactionCHTs] ([SerialId], [DueDate], [PID], [OfficeCode], [TelNo], [IDOld], [OfficeCodeOld], [TelNoOld], [BillId], [BillYearMonth], [CheckCode], [CompanyCode], [AdminisOffice], [System], [CreateUserId], [CreateUser], [CreateDate], [ModiUserId], [ModiDate], [ModiUser], [ImportBatchNo], [RawData], [Hostenum], [PayDate], [ReturnCode], [MainControlSetId], [SplitSubControlSetId], [Status], [AccountNo], [Amount], [CurrentAccountNo], [TradeStatus], [ECStatus], [TradeTypeenum], [AAAAccountNo], [SortKey], [AuthorizeStatus], [ChargeFee], [MergeSubControlSetId], [BranchCode], [FISCBranchCode], [TradeBranchCode], [AccountingSubject], [ExpectedPayDate], [TransDate], [ChiefBranchCode], [AccountNoId], [ErrorMessage], [Filler], [AccountType], [CMIBUSI1], [CMIBUSI2], [IsChangeAccountNo]) VALUES (51, CAST(N&#39;2023-11-12T00:00:00.0000000&#39; AS DateTime2), N&#39;&#39;, N&#39;223&#39;, N&#39;0916136073&#39;, N&#39;&#39;, N&#39;&#39;, N&#39;&#39;, N&#39;G8&#39;, N&#39;11110&#39;, N&#39;65&#39;, N&#39;200&#39;, N&#39;N&#39;, N&#39;&#39;, -1, N&#39;System&#39;, CAST(N&#39;2022-11-28T14:35:14.8895439&#39; AS DateTime2), -1, CAST(N&#39;2022-11-28T14:35:15.1852428&#39; AS DateTime2), N&#39;System&#39;, N&#39;PU202211280000002&#39;, N&#39;210000200662777000000101223           0916136073                                               G811110651122200N        &#39;, 1, CAST(N&#39;2023-10-02T15:13:34.6900000&#39; AS DateTime2), NULL, 378, 379, NULL, N&#39;10000200662777&#39;, CAST(101.0000 AS Decimal(18, 4)), N&#39;000200662777&#39;, 0, 0, 0, NULL, 2, 0, CAST(10.0000 AS Decimal(18, 4)), NULL, N&#39;000&#39;, NULL, NULL, N&#39;200&#39;, CAST(N&#39;2022-11-28T14:35:14.7502370&#39; AS DateTime2), NULL, N&#39;1000&#39;, N&#39;&#39;, NULL, NULL, NULL, NULL, NULL, 0)<br>GO<br>INSERT [dbo].[TransactionCHTs] ([SerialId], [DueDate], [PID], [OfficeCode], [TelNo], [IDOld], [OfficeCodeOld], [TelNoOld], [BillId], [BillYearMonth], [CheckCode], [CompanyCode], [AdminisOffice], [System], [CreateUserId], [CreateUser], [CreateDate], [ModiUserId], [ModiDate], [ModiUser], [ImportBatchNo], [RawData], [Hostenum], [PayDate], [ReturnCode], [MainControlSetId], [SplitSubControlSetId], [Status], [AccountNo], [Amount], [CurrentAccountNo], [TradeStatus], [ECStatus], [TradeTypeenum], [AAAAccountNo], [SortKey], [AuthorizeStatus], [ChargeFee], [MergeSubControlSetId], [BranchCode], [FISCBranchCode], [TradeBranchCode], [AccountingSubject], [ExpectedPayDate], [TransDate], [ChiefBranchCode], [AccountNoId], [ErrorMessage], [Filler], [AccountType], [CMIBUSI1], [CMIBUSI2], [IsChangeAccountNo]) VALUES (64, CAST(N&#39;2021-11-12T00:00:00.0000000&#39; AS DateTime2), N&#39;K100791177&#39;, N&#39;35&#39;, N&#39;1530383&#39;, N&#39;&#39;, N&#39;&#39;, N&#39;&#39;, N&#39;&#39;, N&#39;11110&#39;, N&#39;&#39;, N&#39;&#39;, N&#39;N&#39;, N&#39;G&#39;, -1, N&#39;System&#39;, CAST(N&#39;2022-11-28T17:42:57.0200372&#39; AS DateTime2), -1, CAST(N&#39;2022-11-29T16:43:25.3661321&#39; AS DateTime2), N&#39;System&#39;, N&#39;PU202211280000007&#39;, N&#39;2100200662777  00000012035               1530383K1007911771                                      11110  1122   NG       &#39;, 1, CAST(N&#39;2023-10-02T15:13:34.6900000&#39; AS DateTime2), N&#39;0000&#39;, 388, 389, N&#39;98&#39;, N&#39;100200662777&#39;, CAST(120.0000 AS Decimal(18, 4)), N&#39;100200662777&#39;, 1, 0, 0, N&#39;&#39;, 0, 0, CAST(10.0000 AS Decimal(18, 4)), NULL, N&#39;100&#39;, NULL, NULL, N&#39;220&#39;, CAST(N&#39;2022-11-28T17:42:56.8807500&#39; AS DateTime2), NULL, N&#39;1000&#39;, N&#39;1&#39;, N&#39;&#39;, N&#39;&#39;, NULL, NULL, NULL, 0)<br>GO<br>INSERT [dbo].[TransactionCHTs] ([SerialId], [DueDate], [PID], [OfficeCode], [TelNo], [IDOld], [OfficeCodeOld], [TelNoOld], [BillId], [BillYearMonth], [CheckCode], [CompanyCode], [AdminisOffice], [System], [CreateUserId], [CreateUser], [CreateDate], [ModiUserId], [ModiDate], [ModiUser], [ImportBatchNo], [RawData], [Hostenum], [PayDate], [ReturnCode], [MainControlSetId], [SplitSubControlSetId], [Status], [AccountNo], [Amount], [CurrentAccountNo], [TradeStatus], [ECStatus], [TradeTypeenum], [AAAAccountNo], [SortKey], [AuthorizeStatus], [ChargeFee], [MergeSubControlSetId], [BranchCode], [FISCBranchCode], [TradeBranchCode], [AccountingSubject], [ExpectedPayDate], [TransDate], [ChiefBranchCode], [AccountNoId], [ErrorMessage], [Filler], [AccountType], [CMIBUSI1], [CMIBUSI2], [IsChangeAccountNo]) VALUES (65, CAST(N&#39;2021-11-12T00:00:00.0000000&#39; AS DateTime2), N&#39;J102815713&#39;, N&#39;35&#39;, N&#39;1584316&#39;, N&#39;&#39;, N&#39;&#39;, N&#39;&#39;, N&#39;&#39;, N&#39;11110&#39;, N&#39;&#39;, N&#39;&#39;, N&#39;N&#39;, N&#39;G&#39;, -1, N&#39;System&#39;, CAST(N&#39;2022-11-28T17:42:57.0200397&#39; AS DateTime2), -1, CAST(N&#39;2022-11-29T16:43:25.3661335&#39; AS DateTime2), N&#39;System&#39;, N&#39;PU202211280000007&#39;, N&#39;2100200662777  00000024035               1584316J1028157131                                      11110  1122   NG       &#39;, 1, CAST(N&#39;2023-10-02T15:13:34.6900000&#39; AS DateTime2), N&#39;0002&#39;, 388, 389, N&#39;98&#39;, N&#39;100200662777&#39;, CAST(240.0000 AS Decimal(18, 4)), N&#39;100200662777&#39;, 2, 0, 0, N&#39;&#39;, 1, 0, CAST(10.0000 AS Decimal(18, 4)), NULL, N&#39;100&#39;, NULL, NULL, N&#39;220&#39;, CAST(N&#39;2022-11-28T17:42:56.8808104&#39; AS DateTime2), NULL, N&#39;1000&#39;, N&#39;1&#39;, N&#39;帳號ＩＤ有誤&#39;, N&#39;&#39;, NULL, NULL, NULL, 0)<br>GO<br>INSERT [dbo].[TransactionCHTs] ([SerialId], [DueDate], [PID], [OfficeCode], [TelNo], [IDOld], [OfficeCodeOld], [TelNoOld], [BillId], [BillYearMonth], [CheckCode], [CompanyCode], [AdminisOffice], [System], [CreateUserId], [CreateUser], [CreateDate], [ModiUserId], [ModiDate], [ModiUser], [ImportBatchNo], [RawData], [Hostenum], [PayDate], [ReturnCode], [MainControlSetId], [SplitSubControlSetId], [Status], [AccountNo], [Amount], [CurrentAccountNo], [TradeStatus], [ECStatus], [TradeTypeenum], [AAAAccountNo], [SortKey], [AuthorizeStatus], [ChargeFee], [MergeSubControlSetId], [BranchCode], [FISCBranchCode], [TradeBranchCode], [AccountingSubject], [ExpectedPayDate], [TransDate], [ChiefBranchCode], [AccountNoId], [ErrorMessage], [Filler], [AccountType], [CMIBUSI1], [CMIBUSI2], [IsChangeAccountNo]) VALUES (66, CAST(N&#39;2021-11-12T00:00:00.0000000&#39; AS DateTime2), N&#39;J102849915&#39;, N&#39;35&#39;, N&#39;1585302&#39;, N&#39;&#39;, N&#39;&#39;, N&#39;&#39;, N&#39;&#39;, N&#39;11110&#39;, N&#39;&#39;, N&#39;&#39;, N&#39;N&#39;, N&#39;G&#39;, -1, N&#39;System&#39;, CAST(N&#39;2022-11-28T17:42:57.0200400&#39; AS DateTime2), -1, CAST(N&#39;2022-11-29T16:43:25.3661338&#39; AS DateTime2), N&#39;System&#39;, N&#39;PU202211280000007&#39;, N&#39;2301200392321  00000032135               1585302J1028499151                                      11110  1122   NG       &#39;, 1, CAST(N&#39;2023-10-02T15:13:34.6900000&#39; AS DateTime2), N&#39;0010&#39;, 388, 389, N&#39;98&#39;, N&#39;301200392321&#39;, CAST(321.0000 AS Decimal(18, 4)), N&#39;301200392321&#39;, 2, 0, 0, N&#39;&#39;, 2, 0, CAST(10.0000 AS Decimal(18, 4)), NULL, N&#39;301&#39;, NULL, NULL, N&#39;220&#39;, CAST(N&#39;2022-11-28T17:42:56.8808137&#39; AS DateTime2), NULL, N&#39;3010&#39;, N&#39;1&#39;, N&#39;無此帳戶&#39;, N&#39;&#39;, NULL, NULL, NULL, 0)<br>GO<br>INSERT [dbo].[TransactionCHTs] ([SerialId], [DueDate], [PID], [OfficeCode], [TelNo], [IDOld], [OfficeCodeOld], [TelNoOld], [BillId], [BillYearMonth], [CheckCode], [CompanyCode], [AdminisOffice], [System], [CreateUserId], [CreateUser], [CreateDate], [ModiUserId], [ModiDate], [ModiUser], [ImportBatchNo], [RawData], [Hostenum], [PayDate], [ReturnCode], [MainControlSetId], [SplitSubControlSetId], [Status], [AccountNo], [Amount], [CurrentAccountNo], [TradeStatus], [ECStatus], [TradeTypeenum], [AAAAccountNo], [SortKey], [AuthorizeStatus], [ChargeFee], [MergeSubControlSetId], [BranchCode], [FISCBranchCode], [TradeBranchCode], [AccountingSubject], [ExpectedPayDate], [TransDate], [ChiefBranchCode], [AccountNoId], [ErrorMessage], [Filler], [AccountType], [CMIBUSI1], [CMIBUSI2], [IsChangeAccountNo]) VALUES (67, CAST(N&#39;2022-11-30T00:00:00.0000000&#39; AS DateTime2), N&#39;&#39;, N&#39;022&#39;, N&#39;0912000123&#39;, N&#39;&#39;, N&#39;&#39;, N&#39;&#39;, N&#39;1&#39;, N&#39;11105&#39;, N&#39;01&#39;, N&#39;200&#39;, N&#39;N&#39;, N&#39;&#39;, -1, N&#39;System&#39;, CAST(N&#39;2022-12-01T11:24:01.8073790&#39; AS DateTime2), -1, CAST(N&#39;2022-12-01T11:24:01.8073810&#39; AS DateTime2), N&#39;System&#39;, N&#39;PU202212010000006&#39;, N&#39;2084079777999190 000000070022 0912000123                                                          111105011130200N      &#39;, 2, CAST(N&#39;2023-10-02T15:13:34.6900000&#39; AS DateTime2), NULL, 414, NULL, NULL, N&#39;084079777999190&#39;, CAST(70.0000 AS Decimal(18, 4)), N&#39;079777999190&#39;, 0, 0, 0, NULL, 0, 0, CAST(10.0000 AS Decimal(18, 4)), NULL, N&#39;079&#39;, NULL, NULL, N&#39;207&#39;, CAST(N&#39;2022-12-01T11:23:56.9814186&#39; AS DateTime2), NULL, N&#39;0840&#39;, NULL, NULL, N&#39;&#39;, NULL, NULL, NULL, 0)<br>GO<br>INSERT [dbo].[TransactionCHTs] ([SerialId], [DueDate], [PID], [OfficeCode], [TelNo], [IDOld], [OfficeCodeOld], [TelNoOld], [BillId], [BillYearMonth], [CheckCode], [CompanyCode], [AdminisOffice], [System], [CreateUserId], [CreateUser], [CreateDate], [ModiUserId], [ModiDate], [ModiUser], [ImportBatchNo], [RawData], [Hostenum], [PayDate], [ReturnCode], [MainControlSetId], [SplitSubControlSetId], [Status], [AccountNo], [Amount], [CurrentAccountNo], [TradeStatus], [ECStatus], [TradeTypeenum], [AAAAccountNo], [SortKey], [AuthorizeStatus], [ChargeFee], [MergeSubControlSetId], [BranchCode], [FISCBranchCode], [TradeBranchCode], [AccountingSubject], [ExpectedPayDate], [TransDate], [ChiefBranchCode], [AccountNoId], [ErrorMessage], [Filler], [AccountType], [CMIBUSI1], [CMIBUSI2], [IsChangeAccountNo]) VALUES (68, CAST(N&#39;2022-11-30T00:00:00.0000000&#39; AS DateTime2), N&#39;&#39;, N&#39;023&#39;, N&#39;0400001001116&#39;, N&#39;&#39;, N&#39;&#39;, N&#39;&#39;, N&#39;1&#39;, N&#39;11105&#39;, N&#39;01&#39;, N&#39;200&#39;, N&#39;N&#39;, N&#39;&#39;, -1, N&#39;System&#39;, CAST(N&#39;2022-12-01T11:24:01.8073812&#39; AS DateTime2), -1, CAST(N&#39;2022-12-01T11:24:01.8073812&#39; AS DateTime2), N&#39;System&#39;, N&#39;PU202212010000006&#39;, N&#39;2084010999991510 000000130023 0400001001116                                                       111105011130200N      &#39;, 2, CAST(N&#39;2023-10-02T15:13:34.6900000&#39; AS DateTime2), NULL, 414, NULL, NULL, N&#39;084010999991510&#39;, CAST(130.0000 AS Decimal(18, 4)), N&#39;010999991510&#39;, 0, 0, 0, NULL, 1, 0, CAST(10.0000 AS Decimal(18, 4)), NULL, N&#39;010&#39;, NULL, NULL, N&#39;201&#39;, CAST(N&#39;2022-12-01T11:23:56.9822482&#39; AS DateTime2), NULL, N&#39;0840&#39;, NULL, NULL, N&#39;&#39;, NULL, NULL, NULL, 0)<br>GO<br>INSERT [dbo].[TransactionCHTs] ([SerialId], [DueDate], [PID], [OfficeCode], [TelNo], [IDOld], [OfficeCodeOld], [TelNoOld], [BillId], [BillYearMonth], [CheckCode], [CompanyCode], [AdminisOffice], [System], [CreateUserId], [CreateUser], [CreateDate], [ModiUserId], [ModiDate], [ModiUser], [ImportBatchNo], [RawData], [Hostenum], [PayDate], [ReturnCode], [MainControlSetId], [SplitSubControlSetId], [Status], [AccountNo], [Amount], [CurrentAccountNo], [TradeStatus], [ECStatus], [TradeTypeenum], [AAAAccountNo], [SortKey], [AuthorizeStatus], [ChargeFee], [MergeSubControlSetId], [BranchCode], [FISCBranchCode], [TradeBranchCode], [AccountingSubject], [ExpectedPayDate], [TransDate], [ChiefBranchCode], [AccountNoId], [ErrorMessage], [Filler], [AccountType], [CMIBUSI1], [CMIBUSI2], [IsChangeAccountNo]) VALUES (69, CAST(N&#39;2022-11-30T00:00:00.0000000&#39; AS DateTime2), N&#39;&#39;, N&#39;220&#39;, N&#39;0912000001&#39;, N&#39;&#39;, N&#39;&#39;, N&#39;&#39;, N&#39;1&#39;, N&#39;11105&#39;, N&#39;01&#39;, N&#39;200&#39;, N&#39;N&#39;, N&#39;&#39;, -1, N&#39;System&#39;, CAST(N&#39;2022-12-01T11:24:01.8073814&#39; AS DateTime2), -1, CAST(N&#39;2022-12-01T11:24:01.8073815&#39; AS DateTime2), N&#39;System&#39;, N&#39;PU202212010000006&#39;, N&#39;2084009001000210 000000200220 0912000001                                                          111105011130200N      &#39;, 2, CAST(N&#39;2023-10-02T15:13:34.6900000&#39; AS DateTime2), NULL, 414, NULL, NULL, N&#39;084009001000210&#39;, CAST(200.0000 AS Decimal(18, 4)), N&#39;009001000210&#39;, 0, 0, 0, NULL, 2, 0, CAST(10.0000 AS Decimal(18, 4)), NULL, N&#39;009&#39;, NULL, NULL, N&#39;200&#39;, CAST(N&#39;2022-12-01T11:23:56.9822584&#39; AS DateTime2), NULL, N&#39;0840&#39;, NULL, NULL, N&#39;&#39;, NULL, NULL, NULL, 0)<br>GO<br>INSERT [dbo].[TransactionCHTs] ([SerialId], [DueDate], [PID], [OfficeCode], [TelNo], [IDOld], [OfficeCodeOld], [TelNoOld], [BillId], [BillYearMonth], [CheckCode], [CompanyCode], [AdminisOffice], [System], [CreateUserId], [CreateUser], [CreateDate], [ModiUserId], [ModiDate], [ModiUser], [ImportBatchNo], [RawData], [Hostenum], [PayDate], [ReturnCode], [MainControlSetId], [SplitSubControlSetId], [Status], [AccountNo], [Amount], [CurrentAccountNo], [TradeStatus], [ECStatus], [TradeTypeenum], [AAAAccountNo], [SortKey], [AuthorizeStatus], [ChargeFee], [MergeSubControlSetId], [BranchCode], [FISCBranchCode], [TradeBranchCode], [AccountingSubject], [ExpectedPayDate], [TransDate], [ChiefBranchCode], [AccountNoId], [ErrorMessage], [Filler], [AccountType], [CMIBUSI1], [CMIBUSI2], [IsChangeAccountNo]) VALUES (70, CAST(N&#39;2022-11-30T00:00:00.0000000&#39; AS DateTime2), N&#39;&#39;, N&#39;220&#39;, N&#39;0912000002&#39;, N&#39;&#39;, N&#39;&#39;, N&#39;&#39;, N&#39;1&#39;, N&#39;11105&#39;, N&#39;01&#39;, N&#39;200&#39;, N&#39;N&#39;, N&#39;&#39;, -1, N&#39;System&#39;, CAST(N&#39;2022-12-01T11:24:01.8073816&#39; AS DateTime2), -1, CAST(N&#39;2022-12-01T11:24:01.8073816&#39; AS DateTime2), N&#39;System&#39;, N&#39;PU202212010000006&#39;, N&#39;2084009001000320 000000600220 0912000002                                                          111105011130200N      &#39;, 2, CAST(N&#39;2023-10-02T15:13:34.6900000&#39; AS DateTime2), NULL, 414, NULL, NULL, N&#39;084009001000320&#39;, CAST(600.0000 AS Decimal(18, 4)), N&#39;009001000320&#39;, 0, 0, 0, NULL, 3, 0, CAST(10.0000 AS Decimal(18, 4)), NULL, N&#39;009&#39;, NULL, NULL, N&#39;200&#39;, CAST(N&#39;2022-12-01T11:23:56.9822620&#39; AS DateTime2), NULL, N&#39;0840&#39;, NULL, NULL, N&#39;&#39;, NULL, NULL, NULL, 0)<br>GO<br>INSERT [dbo].[TransactionCHTs] ([SerialId], [DueDate], [PID], [OfficeCode], [TelNo], [IDOld], [OfficeCodeOld], [TelNoOld], [BillId], [BillYearMonth], [CheckCode], [CompanyCode], [AdminisOffice], [System], [CreateUserId], [CreateUser], [CreateDate], [ModiUserId], [ModiDate], [ModiUser], [ImportBatchNo], [RawData], [Hostenum], [PayDate], [ReturnCode], [MainControlSetId], [SplitSubControlSetId], [Status], [AccountNo], [Amount], [CurrentAccountNo], [TradeStatus], [ECStatus], [TradeTypeenum], [AAAAccountNo], [SortKey], [AuthorizeStatus], [ChargeFee], [MergeSubControlSetId], [BranchCode], [FISCBranchCode], [TradeBranchCode], [AccountingSubject], [ExpectedPayDate], [TransDate], [ChiefBranchCode], [AccountNoId], [ErrorMessage], [Filler], [AccountType], [CMIBUSI1], [CMIBUSI2], [IsChangeAccountNo]) VALUES (71, CAST(N&#39;2022-11-30T00:00:00.0000000&#39; AS DateTime2), N&#39;&#39;, N&#39;220&#39;, N&#39;0912000004&#39;, N&#39;&#39;, N&#39;&#39;, N&#39;&#39;, N&#39;1&#39;, N&#39;11105&#39;, N&#39;01&#39;, N&#39;200&#39;, N&#39;N&#39;, N&#39;&#39;, -1, N&#39;System&#39;, CAST(N&#39;2022-12-01T11:24:01.8073817&#39; AS DateTime2), -1, CAST(N&#39;2022-12-01T11:24:01.8073818&#39; AS DateTime2), N&#39;System&#39;, N&#39;PU202212010000006&#39;, N&#39;2084021001000380 000000050220 0912000004                                                          111105011130200N      &#39;, 2, CAST(N&#39;2023-10-02T15:13:34.6900000&#39; AS DateTime2), NULL, 414, NULL, NULL, N&#39;084021001000380&#39;, CAST(50.0000 AS Decimal(18, 4)), N&#39;021001000380&#39;, 0, 0, 0, NULL, 4, 0, CAST(10.0000 AS Decimal(18, 4)), NULL, N&#39;021&#39;, NULL, NULL, N&#39;202&#39;, CAST(N&#39;2022-12-01T11:23:56.9822642&#39; AS DateTime2), NULL, N&#39;0840&#39;, NULL, NULL, N&#39;&#39;, NULL, NULL, NULL, 0)<br>GO<br>INSERT [dbo].[TransactionCHTs] ([SerialId], [DueDate], [PID], [OfficeCode], [TelNo], [IDOld], [OfficeCodeOld], [TelNoOld], [BillId], [BillYearMonth], [CheckCode], [CompanyCode], [AdminisOffice], [System], [CreateUserId], [CreateUser], [CreateDate], [ModiUserId], [ModiDate], [ModiUser], [ImportBatchNo], [RawData], [Hostenum], [PayDate], [ReturnCode], [MainControlSetId], [SplitSubControlSetId], [Status], [AccountNo], [Amount], [CurrentAccountNo], [TradeStatus], [ECStatus], [TradeTypeenum], [AAAAccountNo], [SortKey], [AuthorizeStatus], [ChargeFee], [MergeSubControlSetId], [BranchCode], [FISCBranchCode], [TradeBranchCode], [AccountingSubject], [ExpectedPayDate], [TransDate], [ChiefBranchCode], [AccountNoId], [ErrorMessage], [Filler], [AccountType], [CMIBUSI1], [CMIBUSI2], [IsChangeAccountNo]) VALUES (72, CAST(N&#39;2022-11-30T00:00:00.0000000&#39; AS DateTime2), N&#39;&#39;, N&#39;022&#39;, N&#39;0912000123&#39;, N&#39;&#39;, N&#39;&#39;, N&#39;&#39;, N&#39;1&#39;, N&#39;11105&#39;, N&#39;01&#39;, N&#39;200&#39;, N&#39;N&#39;, N&#39;&#39;, -1, N&#39;System&#39;, CAST(N&#39;2022-12-01T11:25:18.3411267&#39; AS DateTime2), -1, CAST(N&#39;2022-12-01T11:25:18.3411296&#39; AS DateTime2), N&#39;System&#39;, N&#39;PU202212010000007&#39;, N&#39;2084079777999190 000000070022 0912000123                                                          111105011130200N      &#39;, 2, CAST(N&#39;2023-10-02T15:13:34.6900000&#39; AS DateTime2), NULL, 415, NULL, NULL, N&#39;084079777999190&#39;, CAST(70.0000 AS Decimal(18, 4)), N&#39;079777999190&#39;, 0, 0, 0, NULL, 0, 0, CAST(10.0000 AS Decimal(18, 4)), NULL, N&#39;079&#39;, NULL, NULL, N&#39;207&#39;, CAST(N&#39;2022-12-01T11:25:17.0122378&#39; AS DateTime2), NULL, N&#39;0840&#39;, NULL, NULL, N&#39;&#39;, NULL, NULL, NULL, 0)<br>GO<br>INSERT [dbo].[TransactionCHTs] ([SerialId], [DueDate], [PID], [OfficeCode], [TelNo], [IDOld], [OfficeCodeOld], [TelNoOld], [BillId], [BillYearMonth], [CheckCode], [CompanyCode], [AdminisOffice], [System], [CreateUserId], [CreateUser], [CreateDate], [ModiUserId], [ModiDate], [ModiUser], [ImportBatchNo], [RawData], [Hostenum], [PayDate], [ReturnCode], [MainControlSetId], [SplitSubControlSetId], [Status], [AccountNo], [Amount], [CurrentAccountNo], [TradeStatus], [ECStatus], [TradeTypeenum], [AAAAccountNo], [SortKey], [AuthorizeStatus], [ChargeFee], [MergeSubControlSetId], [BranchCode], [FISCBranchCode], [TradeBranchCode], [AccountingSubject], [ExpectedPayDate], [TransDate], [ChiefBranchCode], [AccountNoId], [ErrorMessage], [Filler], [AccountType], [CMIBUSI1], [CMIBUSI2], [IsChangeAccountNo]) VALUES (73, CAST(N&#39;2022-11-30T00:00:00.0000000&#39; AS DateTime2), N&#39;&#39;, N&#39;023&#39;, N&#39;0400001001116&#39;, N&#39;&#39;, N&#39;&#39;, N&#39;&#39;, N&#39;1&#39;, N&#39;11105&#39;, N&#39;01&#39;, N&#39;200&#39;, N&#39;N&#39;, N&#39;&#39;, -1, N&#39;System&#39;, CAST(N&#39;2022-12-01T11:25:18.3411380&#39; AS DateTime2), -1, CAST(N&#39;2022-12-01T11:25:18.3411382&#39; AS DateTime2), N&#39;System&#39;, N&#39;PU202212010000007&#39;, N&#39;2084010999991510 000000130023 0400001001116                                                       111105011130200N      &#39;, 2, CAST(N&#39;2023-10-02T15:13:34.6900000&#39; AS DateTime2), NULL, 415, NULL, NULL, N&#39;084010999991510&#39;, CAST(130.0000 AS Decimal(18, 4)), N&#39;010999991510&#39;, 0, 0, 0, NULL, 1, 0, CAST(10.0000 AS Decimal(18, 4)), NULL, N&#39;010&#39;, NULL, NULL, N&#39;201&#39;, CAST(N&#39;2022-12-01T11:25:17.0137254&#39; AS DateTime2), NULL, N&#39;0840&#39;, NULL, NULL, N&#39;&#39;, NULL, NULL, NULL, 0)<br>GO<br>INSERT [dbo].[TransactionCHTs] ([SerialId], [DueDate], [PID], [OfficeCode], [TelNo], [IDOld], [OfficeCodeOld], [TelNoOld], [BillId], [BillYearMonth], [CheckCode], [CompanyCode], [AdminisOffice], [System], [CreateUserId], [CreateUser], [CreateDate], [ModiUserId], [ModiDate], [ModiUser], [ImportBatchNo], [RawData], [Hostenum], [PayDate], [ReturnCode], [MainControlSetId], [SplitSubControlSetId], [Status], [AccountNo], [Amount], [CurrentAccountNo], [TradeStatus], [ECStatus], [TradeTypeenum], [AAAAccountNo], [SortKey], [AuthorizeStatus], [ChargeFee], [MergeSubControlSetId], [BranchCode], [FISCBranchCode], [TradeBranchCode], [AccountingSubject], [ExpectedPayDate], [TransDate], [ChiefBranchCode], [AccountNoId], [ErrorMessage], [Filler], [AccountType], [CMIBUSI1], [CMIBUSI2], [IsChangeAccountNo]) VALUES (74, CAST(N&#39;2022-11-30T00:00:00.0000000&#39; AS DateTime2), N&#39;&#39;, N&#39;220&#39;, N&#39;0912000001&#39;, N&#39;&#39;, N&#39;&#39;, N&#39;&#39;, N&#39;1&#39;, N&#39;11105&#39;, N&#39;01&#39;, N&#39;200&#39;, N&#39;N&#39;, N&#39;&#39;, -1, N&#39;System&#39;, CAST(N&#39;2022-12-01T11:25:18.3411389&#39; AS DateTime2), -1, CAST(N&#39;2022-12-01T11:25:18.3411391&#39; AS DateTime2), N&#39;System&#39;, N&#39;PU202212010000007&#39;, N&#39;2084009001000210 000000200220 0912000001                                                          111105011130200N      &#39;, 2, CAST(N&#39;2023-10-02T15:13:34.6900000&#39; AS DateTime2), NULL, 415, NULL, NULL, N&#39;084009001000210&#39;, CAST(200.0000 AS Decimal(18, 4)), N&#39;009001000210&#39;, 0, 0, 0, NULL, 2, 0, CAST(10.0000 AS Decimal(18, 4)), NULL, N&#39;009&#39;, NULL, NULL, N&#39;200&#39;, CAST(N&#39;2022-12-01T11:25:17.0137438&#39; AS DateTime2), NULL, N&#39;0840&#39;, NULL, NULL, N&#39;&#39;, NULL, NULL, NULL, 0)<br>GO<br>INSERT [dbo].[TransactionCHTs] ([SerialId], [DueDate], [PID], [OfficeCode], [TelNo], [IDOld], [OfficeCodeOld], [TelNoOld], [BillId], [BillYearMonth], [CheckCode], [CompanyCode], [AdminisOffice], [System], [CreateUserId], [CreateUser], [CreateDate], [ModiUserId], [ModiDate], [ModiUser], [ImportBatchNo], [RawData], [Hostenum], [PayDate], [ReturnCode], [MainControlSetId], [SplitSubControlSetId], [Status], [AccountNo], [Amount], [CurrentAccountNo], [TradeStatus], [ECStatus], [TradeTypeenum], [AAAAccountNo], [SortKey], [AuthorizeStatus], [ChargeFee], [MergeSubControlSetId], [BranchCode], [FISCBranchCode], [TradeBranchCode], [AccountingSubject], [ExpectedPayDate], [TransDate], [ChiefBranchCode], [AccountNoId], [ErrorMessage], [Filler], [AccountType], [CMIBUSI1], [CMIBUSI2], [IsChangeAccountNo]) VALUES (75, CAST(N&#39;2022-11-30T00:00:00.0000000&#39; AS DateTime2), N&#39;&#39;, N&#39;220&#39;, N&#39;0912000002&#39;, N&#39;&#39;, N&#39;&#39;, N&#39;&#39;, N&#39;1&#39;, N&#39;11105&#39;, N&#39;01&#39;, N&#39;200&#39;, N&#39;N&#39;, N&#39;&#39;, -1, N&#39;System&#39;, CAST(N&#39;2022-12-01T11:25:18.3411397&#39; AS DateTime2), -1, CAST(N&#39;2022-12-01T11:25:18.3411399&#39; AS DateTime2), N&#39;System&#39;, N&#39;PU202212010000007&#39;, N&#39;2084009001000320 000000600220 0912000002                                                          111105011130200N      &#39;, 2, CAST(N&#39;2023-10-02T15:13:34.6900000&#39; AS DateTime2), NULL, 415, NULL, NULL, N&#39;084009001000320&#39;, CAST(600.0000 AS Decimal(18, 4)), N&#39;009001000320&#39;, 0, 0, 0, NULL, 3, 0, CAST(10.0000 AS Decimal(18, 4)), NULL, N&#39;009&#39;, NULL, NULL, N&#39;200&#39;, CAST(N&#39;2022-12-01T11:25:17.0137491&#39; AS DateTime2), NULL, N&#39;0840&#39;, NULL, NULL, N&#39;&#39;, NULL, NULL, NULL, 0)<br>GO<br>INSERT [dbo].[TransactionCHTs] ([SerialId], [DueDate], [PID], [OfficeCode], [TelNo], [IDOld], [OfficeCodeOld], [TelNoOld], [BillId], [BillYearMonth], [CheckCode], [CompanyCode], [AdminisOffice], [System], [CreateUserId], [CreateUser], [CreateDate], [ModiUserId], [ModiDate], [ModiUser], [ImportBatchNo], [RawData], [Hostenum], [PayDate], [ReturnCode], [MainControlSetId], [SplitSubControlSetId], [Status], [AccountNo], [Amount], [CurrentAccountNo], [TradeStatus], [ECStatus], [TradeTypeenum], [AAAAccountNo], [SortKey], [AuthorizeStatus], [ChargeFee], [MergeSubControlSetId], [BranchCode], [FISCBranchCode], [TradeBranchCode], [AccountingSubject], [ExpectedPayDate], [TransDate], [ChiefBranchCode], [AccountNoId], [ErrorMessage], [Filler], [AccountType], [CMIBUSI1], [CMIBUSI2], [IsChangeAccountNo]) VALUES (76, CAST(N&#39;2022-11-30T00:00:00.0000000&#39; AS DateTime2), N&#39;&#39;, N&#39;220&#39;, N&#39;0912000004&#39;, N&#39;&#39;, N&#39;&#39;, N&#39;&#39;, N&#39;1&#39;, N&#39;11105&#39;, N&#39;01&#39;, N&#39;200&#39;, N&#39;N&#39;, N&#39;&#39;, -1, N&#39;System&#39;, CAST(N&#39;2022-12-01T11:25:18.3411405&#39; AS DateTime2), -1, CAST(N&#39;2022-12-01T11:25:18.3411407&#39; AS DateTime2), N&#39;System&#39;, N&#39;PU202212010000007&#39;, N&#39;2084021001000380 000000050220 0912000004                                                          111105011130200N      &#39;, 2, CAST(N&#39;2023-10-02T15:13:34.6900000&#39; AS DateTime2), NULL, 415, NULL, NULL, N&#39;084021001000380&#39;, CAST(50.0000 AS Decimal(18, 4)), N&#39;021001000380&#39;, 0, 0, 0, NULL, 4, 0, CAST(10.0000 AS Decimal(18, 4)), NULL, N&#39;021&#39;, NULL, NULL, N&#39;202&#39;, CAST(N&#39;2022-12-01T11:25:17.0137558&#39; AS DateTime2), NULL, N&#39;0840&#39;, NULL, NULL, N&#39;&#39;, NULL, NULL, NULL, 0)<br>GO<br>INSERT [dbo].[TransactionCHTs] ([SerialId], [DueDate], [PID], [OfficeCode], [TelNo], [IDOld], [OfficeCodeOld], [TelNoOld], [BillId], [BillYearMonth], [CheckCode], [CompanyCode], [AdminisOffice], [System], [CreateUserId], [CreateUser], [CreateDate], [ModiUserId], [ModiDate], [ModiUser], [ImportBatchNo], [RawData], [Hostenum], [PayDate], [ReturnCode], [MainControlSetId], [SplitSubControlSetId], [Status], [AccountNo], [Amount], [CurrentAccountNo], [TradeStatus], [ECStatus], [TradeTypeenum], [AAAAccountNo], [SortKey], [AuthorizeStatus], [ChargeFee], [MergeSubControlSetId], [BranchCode], [FISCBranchCode], [TradeBranchCode], [AccountingSubject], [ExpectedPayDate], [TransDate], [ChiefBranchCode], [AccountNoId], [ErrorMessage], [Filler], [AccountType], [CMIBUSI1], [CMIBUSI2], [IsChangeAccountNo]) VALUES (77, CAST(N&#39;2022-11-30T00:00:00.0000000&#39; AS DateTime2), N&#39;&#39;, N&#39;022&#39;, N&#39;0912000123&#39;, N&#39;&#39;, N&#39;&#39;, N&#39;&#39;, N&#39;1&#39;, N&#39;11105&#39;, N&#39;01&#39;, N&#39;200&#39;, N&#39;N&#39;, N&#39;&#39;, -1, N&#39;System&#39;, CAST(N&#39;2022-12-01T11:32:36.2023868&#39; AS DateTime2), -1, CAST(N&#39;2022-12-01T11:32:36.2023902&#39; AS DateTime2), N&#39;System&#39;, N&#39;PU202212010000008&#39;, N&#39;2084079777999190 000000070022 0912000123                                                          111105011130200N      &#39;, 2, CAST(N&#39;2023-10-02T15:13:34.6900000&#39; AS DateTime2), NULL, 416, NULL, NULL, N&#39;084079777999190&#39;, CAST(70.0000 AS Decimal(18, 4)), N&#39;079777999190&#39;, 0, 0, 0, NULL, 0, 0, CAST(10.0000 AS Decimal(18, 4)), NULL, N&#39;079&#39;, NULL, NULL, N&#39;207&#39;, CAST(N&#39;2022-12-01T11:32:32.5823105&#39; AS DateTime2), NULL, N&#39;0840&#39;, NULL, NULL, N&#39;&#39;, NULL, NULL, NULL, 0)<br>GO<br>INSERT [dbo].[TransactionCHTs] ([SerialId], [DueDate], [PID], [OfficeCode], [TelNo], [IDOld], [OfficeCodeOld], [TelNoOld], [BillId], [BillYearMonth], [CheckCode], [CompanyCode], [AdminisOffice], [System], [CreateUserId], [CreateUser], [CreateDate], [ModiUserId], [ModiDate], [ModiUser], [ImportBatchNo], [RawData], [Hostenum], [PayDate], [ReturnCode], [MainControlSetId], [SplitSubControlSetId], [Status], [AccountNo], [Amount], [CurrentAccountNo], [TradeStatus], [ECStatus], [TradeTypeenum], [AAAAccountNo], [SortKey], [AuthorizeStatus], [ChargeFee], [MergeSubControlSetId], [BranchCode], [FISCBranchCode], [TradeBranchCode], [AccountingSubject], [ExpectedPayDate], [TransDate], [ChiefBranchCode], [AccountNoId], [ErrorMessage], [Filler], [AccountType], [CMIBUSI1], [CMIBUSI2], [IsChangeAccountNo]) VALUES (78, CAST(N&#39;2022-11-30T00:00:00.0000000&#39; AS DateTime2), N&#39;&#39;, N&#39;023&#39;, N&#39;0400001001116&#39;, N&#39;&#39;, N&#39;&#39;, N&#39;&#39;, N&#39;1&#39;, N&#39;11105&#39;, N&#39;01&#39;, N&#39;200&#39;, N&#39;N&#39;, N&#39;&#39;, -1, N&#39;System&#39;, CAST(N&#39;2022-12-01T11:32:36.2023913&#39; AS DateTime2), -1, CAST(N&#39;2022-12-01T11:32:36.2023915&#39; AS DateTime2), N&#39;System&#39;, N&#39;PU202212010000008&#39;, N&#39;2084010999991510 000000130023 0400001001116                                                       111105011130200N      &#39;, 2, CAST(N&#39;2023-10-02T15:13:34.6900000&#39; AS DateTime2), NULL, 416, NULL, NULL, N&#39;084010999991510&#39;, CAST(130.0000 AS Decimal(18, 4)), N&#39;010999991510&#39;, 0, 0, 0, NULL, 1, 0, CAST(10.0000 AS Decimal(18, 4)), NULL, N&#39;010&#39;, NULL, NULL, N&#39;201&#39;, CAST(N&#39;2022-12-01T11:32:32.5831487&#39; AS DateTime2), NULL, N&#39;0840&#39;, NULL, NULL, N&#39;&#39;, NULL, NULL, NULL, 0)<br>GO<br>INSERT [dbo].[TransactionCHTs] ([SerialId], [DueDate], [PID], [OfficeCode], [TelNo], [IDOld], [OfficeCodeOld], [TelNoOld], [BillId], [BillYearMonth], [CheckCode], [CompanyCode], [AdminisOffice], [System], [CreateUserId], [CreateUser], [CreateDate], [ModiUserId], [ModiDate], [ModiUser], [ImportBatchNo], [RawData], [Hostenum], [PayDate], [ReturnCode], [MainControlSetId], [SplitSubControlSetId], [Status], [AccountNo], [Amount], [CurrentAccountNo], [TradeStatus], [ECStatus], [TradeTypeenum], [AAAAccountNo], [SortKey], [AuthorizeStatus], [ChargeFee], [MergeSubControlSetId], [BranchCode], [FISCBranchCode], [TradeBranchCode], [AccountingSubject], [ExpectedPayDate], [TransDate], [ChiefBranchCode], [AccountNoId], [ErrorMessage], [Filler], [AccountType], [CMIBUSI1], [CMIBUSI2], [IsChangeAccountNo]) VALUES (79, CAST(N&#39;2022-11-30T00:00:00.0000000&#39; AS DateTime2), N&#39;&#39;, N&#39;220&#39;, N&#39;0912000001&#39;, N&#39;&#39;, N&#39;&#39;, N&#39;&#39;, N&#39;1&#39;, N&#39;11105&#39;, N&#39;01&#39;, N&#39;200&#39;, N&#39;N&#39;, N&#39;&#39;, -1, N&#39;System&#39;, CAST(N&#39;2022-12-01T11:32:36.2023921&#39; AS DateTime2), -1, CAST(N&#39;2022-12-01T11:32:36.2023924&#39; AS DateTime2), N&#39;System&#39;, N&#39;PU202212010000008&#39;, N&#39;2084009001000210 000000200220 0912000001                                                          111105011130200N      &#39;, 2, CAST(N&#39;2023-10-02T15:13:34.6900000&#39; AS DateTime2), NULL, 416, NULL, NULL, N&#39;084009001000210&#39;, CAST(200.0000 AS Decimal(18, 4)), N&#39;009001000210&#39;, 0, 0, 0, NULL, 2, 0, CAST(10.0000 AS Decimal(18, 4)), NULL, N&#39;009&#39;, NULL, NULL, N&#39;200&#39;, CAST(N&#39;2022-12-01T11:32:32.5831742&#39; AS DateTime2), NULL, N&#39;0840&#39;, NULL, NULL, N&#39;&#39;, NULL, NULL, NULL, 0)<br>GO<br>INSERT [dbo].[TransactionCHTs] ([SerialId], [DueDate], [PID], [OfficeCode], [TelNo], [IDOld], [OfficeCodeOld], [TelNoOld], [BillId], [BillYearMonth], [CheckCode], [CompanyCode], [AdminisOffice], [System], [CreateUserId], [CreateUser], [CreateDate], [ModiUserId], [ModiDate], [ModiUser], [ImportBatchNo], [RawData], [Hostenum], [PayDate], [ReturnCode], [MainControlSetId], [SplitSubControlSetId], [Status], [AccountNo], [Amount], [CurrentAccountNo], [TradeStatus], [ECStatus], [TradeTypeenum], [AAAAccountNo], [SortKey], [AuthorizeStatus], [ChargeFee], [MergeSubControlSetId], [BranchCode], [FISCBranchCode], [TradeBranchCode], [AccountingSubject], [ExpectedPayDate], [TransDate], [ChiefBranchCode], [AccountNoId], [ErrorMessage], [Filler], [AccountType], [CMIBUSI1], [CMIBUSI2], [IsChangeAccountNo]) VALUES (80, CAST(N&#39;2022-11-30T00:00:00.0000000&#39; AS DateTime2), N&#39;&#39;, N&#39;220&#39;, N&#39;0912000002&#39;, N&#39;&#39;, N&#39;&#39;, N&#39;&#39;, N&#39;1&#39;, N&#39;11105&#39;, N&#39;01&#39;, N&#39;200&#39;, N&#39;N&#39;, N&#39;&#39;, -1, N&#39;System&#39;, CAST(N&#39;2022-12-01T11:32:36.2023930&#39; AS DateTime2), -1, CAST(N&#39;2022-12-01T11:32:36.2023932&#39; AS DateTime2), N&#39;System&#39;, N&#39;PU202212010000008&#39;, N&#39;2084009001000320 000000600220 0912000002                                                          111105011130200N      &#39;, 2, CAST(N&#39;2023-10-02T15:13:34.6900000&#39; AS DateTime2), NULL, 416, NULL, NULL, N&#39;084009001000320&#39;, CAST(600.0000 AS Decimal(18, 4)), N&#39;009001000320&#39;, 0, 0, 0, NULL, 3, 0, CAST(10.0000 AS Decimal(18, 4)), NULL, N&#39;009&#39;, NULL, NULL, N&#39;200&#39;, CAST(N&#39;2022-12-01T11:32:32.5831765&#39; AS DateTime2), NULL, N&#39;0840&#39;, NULL, NULL, N&#39;&#39;, NULL, NULL, NULL, 0)<br>GO<br>INSERT [dbo].[TransactionCHTs] ([SerialId], [DueDate], [PID], [OfficeCode], [TelNo], [IDOld], [OfficeCodeOld], [TelNoOld], [BillId], [BillYearMonth], [CheckCode], [CompanyCode], [AdminisOffice], [System], [CreateUserId], [CreateUser], [CreateDate], [ModiUserId], [ModiDate], [ModiUser], [ImportBatchNo], [RawData], [Hostenum], [PayDate], [ReturnCode], [MainControlSetId], [SplitSubControlSetId], [Status], [AccountNo], [Amount], [CurrentAccountNo], [TradeStatus], [ECStatus], [TradeTypeenum], [AAAAccountNo], [SortKey], [AuthorizeStatus], [ChargeFee], [MergeSubControlSetId], [BranchCode], [FISCBranchCode], [TradeBranchCode], [AccountingSubject], [ExpectedPayDate], [TransDate], [ChiefBranchCode], [AccountNoId], [ErrorMessage], [Filler], [AccountType], [CMIBUSI1], [CMIBUSI2], [IsChangeAccountNo]) VALUES (81, CAST(N&#39;2022-11-30T00:00:00.0000000&#39; AS DateTime2), N&#39;&#39;, N&#39;220&#39;, N&#39;0912000004&#39;, N&#39;&#39;, N&#39;&#39;, N&#39;&#39;, N&#39;1&#39;, N&#39;11105&#39;, N&#39;01&#39;, N&#39;200&#39;, N&#39;N&#39;, N&#39;&#39;, -1, N&#39;System&#39;, CAST(N&#39;2022-12-01T11:32:36.2023938&#39; AS DateTime2), -1, CAST(N&#39;2022-12-01T11:32:36.2023941&#39; AS DateTime2), N&#39;System&#39;, N&#39;PU202212010000008&#39;, N&#39;2084021001000380 000000050220 0912000004                                                          111105011130200N      &#39;, 2, CAST(N&#39;2023-10-02T15:13:34.6900000&#39; AS DateTime2), NULL, 416, NULL, NULL, N&#39;084021001000380&#39;, CAST(50.0000 AS Decimal(18, 4)), N&#39;021001000380&#39;, 0, 0, 0, NULL, 4, 0, CAST(10.0000 AS Decimal(18, 4)), NULL, N&#39;021&#39;, NULL, NULL, N&#39;202&#39;, CAST(N&#39;2022-12-01T11:32:32.5831796&#39; AS DateTime2), NULL, N&#39;0840&#39;, NULL, NULL, N&#39;&#39;, NULL, NULL, NULL, 0)<br>GO<br>INSERT [dbo].[TransactionCHTs] ([SerialId], [DueDate], [PID], [OfficeCode], [TelNo], [IDOld], [OfficeCodeOld], [TelNoOld], [BillId], [BillYearMonth], [CheckCode], [CompanyCode], [AdminisOffice], [System], [CreateUserId], [CreateUser], [CreateDate], [ModiUserId], [ModiDate], [ModiUser], [ImportBatchNo], [RawData], [Hostenum], [PayDate], [ReturnCode], [MainControlSetId], [SplitSubControlSetId], [Status], [AccountNo], [Amount], [CurrentAccountNo], [TradeStatus], [ECStatus], [TradeTypeenum], [AAAAccountNo], [SortKey], [AuthorizeStatus], [ChargeFee], [MergeSubControlSetId], [BranchCode], [FISCBranchCode], [TradeBranchCode], [AccountingSubject], [ExpectedPayDate], [TransDate], [ChiefBranchCode], [AccountNoId], [ErrorMessage], [Filler], [AccountType], [CMIBUSI1], [CMIBUSI2], [IsChangeAccountNo]) VALUES (82, CAST(N&#39;2022-11-30T00:00:00.0000000&#39; AS DateTime2), N&#39;&#39;, N&#39;022&#39;, N&#39;0912000123&#39;, N&#39;&#39;, N&#39;&#39;, N&#39;&#39;, N&#39;1&#39;, N&#39;11105&#39;, N&#39;01&#39;, N&#39;200&#39;, N&#39;N&#39;, N&#39;&#39;, -1, N&#39;System&#39;, CAST(N&#39;2022-12-01T11:40:31.9665262&#39; AS DateTime2), -1, CAST(N&#39;2022-12-01T11:40:31.9665279&#39; AS DateTime2), N&#39;System&#39;, N&#39;PU202212010000009&#39;, N&#39;2084079777999190 000000070022 0912000123                                                          111105011130200N      &#39;, 2, CAST(N&#39;2023-10-02T15:13:34.6900000&#39; AS DateTime2), NULL, 417, NULL, NULL, N&#39;084079777999190&#39;, CAST(70.0000 AS Decimal(18, 4)), N&#39;079777999190&#39;, 0, 0, 0, NULL, 0, 0, CAST(10.0000 AS Decimal(18, 4)), NULL, N&#39;079&#39;, NULL, NULL, N&#39;207&#39;, CAST(N&#39;2022-12-01T11:40:31.6959978&#39; AS DateTime2), NULL, N&#39;0840&#39;, NULL, NULL, N&#39;&#39;, NULL, NULL, NULL, 0)<br>GO<br>INSERT [dbo].[TransactionCHTs] ([SerialId], [DueDate], [PID], [OfficeCode], [TelNo], [IDOld], [OfficeCodeOld], [TelNoOld], [BillId], [BillYearMonth], [CheckCode], [CompanyCode], [AdminisOffice], [System], [CreateUserId], [CreateUser], [CreateDate], [ModiUserId], [ModiDate], [ModiUser], [ImportBatchNo], [RawData], [Hostenum], [PayDate], [ReturnCode], [MainControlSetId], [SplitSubControlSetId], [Status], [AccountNo], [Amount], [CurrentAccountNo], [TradeStatus], [ECStatus], [TradeTypeenum], [AAAAccountNo], [SortKey], [AuthorizeStatus], [ChargeFee], [MergeSubControlSetId], [BranchCode], [FISCBranchCode], [TradeBranchCode], [AccountingSubject], [ExpectedPayDate], [TransDate], [ChiefBranchCode], [AccountNoId], [ErrorMessage], [Filler], [AccountType], [CMIBUSI1], [CMIBUSI2], [IsChangeAccountNo]) VALUES (83, CAST(N&#39;2022-11-30T00:00:00.0000000&#39; AS DateTime2), N&#39;&#39;, N&#39;023&#39;, N&#39;0400001001116&#39;, N&#39;&#39;, N&#39;&#39;, N&#39;&#39;, N&#39;1&#39;, N&#39;11105&#39;, N&#39;01&#39;, N&#39;200&#39;, N&#39;N&#39;, N&#39;&#39;, -1, N&#39;System&#39;, CAST(N&#39;2022-12-01T11:40:31.9665281&#39; AS DateTime2), -1, CAST(N&#39;2022-12-01T11:40:31.9665282&#39; AS DateTime2), N&#39;System&#39;, N&#39;PU202212010000009&#39;, N&#39;2084010999991510 000000130023 0400001001116                                                       111105011130200N      &#39;, 2, CAST(N&#39;2023-10-02T15:13:34.6900000&#39; AS DateTime2), NULL, 417, NULL, NULL, N&#39;084010999991510&#39;, CAST(130.0000 AS Decimal(18, 4)), N&#39;010999991510&#39;, 0, 0, 0, NULL, 1, 0, CAST(10.0000 AS Decimal(18, 4)), NULL, N&#39;010&#39;, NULL, NULL, N&#39;201&#39;, CAST(N&#39;2022-12-01T11:40:31.6969598&#39; AS DateTime2), NULL, N&#39;0840&#39;, NULL, NULL, N&#39;&#39;, NULL, NULL, NULL, 0)<br>GO<br>INSERT [dbo].[TransactionCHTs] ([SerialId], [DueDate], [PID], [OfficeCode], [TelNo], [IDOld], [OfficeCodeOld], [TelNoOld], [BillId], [BillYearMonth], [CheckCode], [CompanyCode], [AdminisOffice], [System], [CreateUserId], [CreateUser], [CreateDate], [ModiUserId], [ModiDate], [ModiUser], [ImportBatchNo], [RawData], [Hostenum], [PayDate], [ReturnCode], [MainControlSetId], [SplitSubControlSetId], [Status], [AccountNo], [Amount], [CurrentAccountNo], [TradeStatus], [ECStatus], [TradeTypeenum], [AAAAccountNo], [SortKey], [AuthorizeStatus], [ChargeFee], [MergeSubControlSetId], [BranchCode], [FISCBranchCode], [TradeBranchCode], [AccountingSubject], [ExpectedPayDate], [TransDate], [ChiefBranchCode], [AccountNoId], [ErrorMessage], [Filler], [AccountType], [CMIBUSI1], [CMIBUSI2], [IsChangeAccountNo]) VALUES (84, CAST(N&#39;2022-11-30T00:00:00.0000000&#39; AS DateTime2), N&#39;&#39;, N&#39;220&#39;, N&#39;0912000001&#39;, N&#39;&#39;, N&#39;&#39;, N&#39;&#39;, N&#39;1&#39;, N&#39;11105&#39;, N&#39;01&#39;, N&#39;200&#39;, N&#39;N&#39;, N&#39;&#39;, -1, N&#39;System&#39;, CAST(N&#39;2022-12-01T11:40:31.9665283&#39; AS DateTime2), -1, CAST(N&#39;2022-12-01T11:40:31.9665284&#39; AS DateTime2), N&#39;System&#39;, N&#39;PU202212010000009&#39;, N&#39;2084009001000210 000000200220 0912000001                                                          111105011130200N      &#39;, 2, CAST(N&#39;2023-10-02T15:13:34.6900000&#39; AS DateTime2), NULL, 417, NULL, NULL, N&#39;084009001000210&#39;, CAST(200.0000 AS Decimal(18, 4)), N&#39;009001000210&#39;, 0, 0, 0, NULL, 2, 0, CAST(10.0000 AS Decimal(18, 4)), NULL, N&#39;009&#39;, NULL, NULL, N&#39;200&#39;, CAST(N&#39;2022-12-01T11:40:31.6969686&#39; AS DateTime2), NULL, N&#39;0840&#39;, NULL, NULL, N&#39;&#39;, NULL, NULL, NULL, 0)<br>GO<br>INSERT [dbo].[TransactionCHTs] ([SerialId], [DueDate], [PID], [OfficeCode], [TelNo], [IDOld], [OfficeCodeOld], [TelNoOld], [BillId], [BillYearMonth], [CheckCode], [CompanyCode], [AdminisOffice], [System], [CreateUserId], [CreateUser], [CreateDate], [ModiUserId], [ModiDate], [ModiUser], [ImportBatchNo], [RawData], [Hostenum], [PayDate], [ReturnCode], [MainControlSetId], [SplitSubControlSetId], [Status], [AccountNo], [Amount], [CurrentAccountNo], [TradeStatus], [ECStatus], [TradeTypeenum], [AAAAccountNo], [SortKey], [AuthorizeStatus], [ChargeFee], [MergeSubControlSetId], [BranchCode], [FISCBranchCode], [TradeBranchCode], [AccountingSubject], [ExpectedPayDate], [TransDate], [ChiefBranchCode], [AccountNoId], [ErrorMessage], [Filler], [AccountType], [CMIBUSI1], [CMIBUSI2], [IsChangeAccountNo]) VALUES (85, CAST(N&#39;2022-11-30T00:00:00.0000000&#39; AS DateTime2), N&#39;&#39;, N&#39;220&#39;, N&#39;0912000002&#39;, N&#39;&#39;, N&#39;&#39;, N&#39;&#39;, N&#39;1&#39;, N&#39;11105&#39;, N&#39;01&#39;, N&#39;200&#39;, N&#39;N&#39;, N&#39;&#39;, -1, N&#39;System&#39;, CAST(N&#39;2022-12-01T11:40:31.9665285&#39; AS DateTime2), -1, CAST(N&#39;2022-12-01T11:40:31.9665285&#39; AS DateTime2), N&#39;System&#39;, N&#39;PU202212010000009&#39;, N&#39;2084009001000320 000000600220 0912000002                                                          111105011130200N      &#39;, 2, CAST(N&#39;2023-10-02T15:13:34.6900000&#39; AS DateTime2), NULL, 417, NULL, NULL, N&#39;084009001000320&#39;, CAST(600.0000 AS Decimal(18, 4)), N&#39;009001000320&#39;, 0, 0, 0, NULL, 3, 0, CAST(10.0000 AS Decimal(18, 4)), NULL, N&#39;009&#39;, NULL, NULL, N&#39;200&#39;, CAST(N&#39;2022-12-01T11:40:31.6969715&#39; AS DateTime2), NULL, N&#39;0840&#39;, NULL, NULL, N&#39;&#39;, NULL, NULL, NULL, 0)<br>GO<br>INSERT [dbo].[TransactionCHTs] ([SerialId], [DueDate], [PID], [OfficeCode], [TelNo], [IDOld], [OfficeCodeOld], [TelNoOld], [BillId], [BillYearMonth], [CheckCode], [CompanyCode], [AdminisOffice], [System], [CreateUserId], [CreateUser], [CreateDate], [ModiUserId], [ModiDate], [ModiUser], [ImportBatchNo], [RawData], [Hostenum], [PayDate], [ReturnCode], [MainControlSetId], [SplitSubControlSetId], [Status], [AccountNo], [Amount], [CurrentAccountNo], [TradeStatus], [ECStatus], [TradeTypeenum], [AAAAccountNo], [SortKey], [AuthorizeStatus], [ChargeFee], [MergeSubControlSetId], [BranchCode], [FISCBranchCode], [TradeBranchCode], [AccountingSubject], [ExpectedPayDate], [TransDate], [ChiefBranchCode], [AccountNoId], [ErrorMessage], [Filler], [AccountType], [CMIBUSI1], [CMIBUSI2], [IsChangeAccountNo]) VALUES (86, CAST(N&#39;2022-11-30T00:00:00.0000000&#39; AS DateTime2), N&#39;&#39;, N&#39;220&#39;, N&#39;0912000004&#39;, N&#39;&#39;, N&#39;&#39;, N&#39;&#39;, N&#39;1&#39;, N&#39;11105&#39;, N&#39;01&#39;, N&#39;200&#39;, N&#39;N&#39;, N&#39;&#39;, -1, N&#39;System&#39;, CAST(N&#39;2022-12-01T11:40:31.9665286&#39; AS DateTime2), -1, CAST(N&#39;2022-12-01T11:40:31.9665287&#39; AS DateTime2), N&#39;System&#39;, N&#39;PU202212010000009&#39;, N&#39;2084021001000380 000000050220 0912000004                                                          111105011130200N      &#39;, 2, CAST(N&#39;2023-10-02T15:13:34.6900000&#39; AS DateTime2), NULL, 417, NULL, NULL, N&#39;084021001000380&#39;, CAST(50.0000 AS Decimal(18, 4)), N&#39;021001000380&#39;, 0, 0, 0, NULL, 4, 0, CAST(10.0000 AS Decimal(18, 4)), NULL, N&#39;021&#39;, NULL, NULL, N&#39;202&#39;, CAST(N&#39;2022-12-01T11:40:31.6969736&#39; AS DateTime2), NULL, N&#39;0840&#39;, NULL, NULL, N&#39;&#39;, NULL, NULL, NULL, 0)<br>GO<br>INSERT [dbo].[TransactionCHTs] ([SerialId], [DueDate], [PID], [OfficeCode], [TelNo], [IDOld], [OfficeCodeOld], [TelNoOld], [BillId], [BillYearMonth], [CheckCode], [CompanyCode], [AdminisOffice], [System], [CreateUserId], [CreateUser], [CreateDate], [ModiUserId], [ModiDate], [ModiUser], [ImportBatchNo], [RawData], [Hostenum], [PayDate], [ReturnCode], [MainControlSetId], [SplitSubControlSetId], [Status], [AccountNo], [Amount], [CurrentAccountNo], [TradeStatus], [ECStatus], [TradeTypeenum], [AAAAccountNo], [SortKey], [AuthorizeStatus], [ChargeFee], [MergeSubControlSetId], [BranchCode], [FISCBranchCode], [TradeBranchCode], [AccountingSubject], [ExpectedPayDate], [TransDate], [ChiefBranchCode], [AccountNoId], [ErrorMessage], [Filler], [AccountType], [CMIBUSI1], [CMIBUSI2], [IsChangeAccountNo]) VALUES (87, CAST(N&#39;2022-11-30T00:00:00.0000000&#39; AS DateTime2), N&#39;&#39;, N&#39;022&#39;, N&#39;0912000123&#39;, N&#39;&#39;, N&#39;&#39;, N&#39;&#39;, N&#39;1&#39;, N&#39;11105&#39;, N&#39;01&#39;, N&#39;200&#39;, N&#39;N&#39;, N&#39;&#39;, -1, N&#39;System&#39;, CAST(N&#39;2022-12-01T11:42:46.6841365&#39; AS DateTime2), -1, CAST(N&#39;2022-12-01T11:43:36.1750211&#39; AS DateTime2), N&#39;System&#39;, N&#39;PU202212010000010&#39;, N&#39;2084079777999190 000000070022 0912000123                                                          111105011130200N      &#39;, 2, CAST(N&#39;2023-10-02T15:13:34.6900000&#39; AS DateTime2), NULL, 418, 419, NULL, N&#39;084079777999190&#39;, CAST(70.0000 AS Decimal(18, 4)), N&#39;079777999190&#39;, 0, 0, 0, NULL, 0, 0, CAST(10.0000 AS Decimal(18, 4)), NULL, N&#39;079&#39;, NULL, NULL, N&#39;207&#39;, CAST(N&#39;2022-12-01T11:42:46.3543895&#39; AS DateTime2), NULL, N&#39;0840&#39;, NULL, NULL, N&#39;&#39;, NULL, NULL, NULL, 0)<br>GO<br>INSERT [dbo].[TransactionCHTs] ([SerialId], [DueDate], [PID], [OfficeCode], [TelNo], [IDOld], [OfficeCodeOld], [TelNoOld], [BillId], [BillYearMonth], [CheckCode], [CompanyCode], [AdminisOffice], [System], [CreateUserId], [CreateUser], [CreateDate], [ModiUserId], [ModiDate], [ModiUser], [ImportBatchNo], [RawData], [Hostenum], [PayDate], [ReturnCode], [MainControlSetId], [SplitSubControlSetId], [Status], [AccountNo], [Amount], [CurrentAccountNo], [TradeStatus], [ECStatus], [TradeTypeenum], [AAAAccountNo], [SortKey], [AuthorizeStatus], [ChargeFee], [MergeSubControlSetId], [BranchCode], [FISCBranchCode], [TradeBranchCode], [AccountingSubject], [ExpectedPayDate], [TransDate], [ChiefBranchCode], [AccountNoId], [ErrorMessage], [Filler], [AccountType], [CMIBUSI1], [CMIBUSI2], [IsChangeAccountNo]) VALUES (88, CAST(N&#39;2022-11-30T00:00:00.0000000&#39; AS DateTime2), N&#39;&#39;, N&#39;023&#39;, N&#39;0400001001116&#39;, N&#39;&#39;, N&#39;&#39;, N&#39;&#39;, N&#39;1&#39;, N&#39;11105&#39;, N&#39;01&#39;, N&#39;200&#39;, N&#39;N&#39;, N&#39;&#39;, -1, N&#39;System&#39;, CAST(N&#39;2022-12-01T11:42:46.6841394&#39; AS DateTime2), -1, CAST(N&#39;2022-12-01T11:43:36.1750222&#39; AS DateTime2), N&#39;System&#39;, N&#39;PU202212010000010&#39;, N&#39;2084010999991510 000000130023 0400001001116                                                       111105011130200N      &#39;, 2, CAST(N&#39;2023-10-02T15:13:34.6900000&#39; AS DateTime2), NULL, 418, 419, NULL, N&#39;084010999991510&#39;, CAST(130.0000 AS Decimal(18, 4)), N&#39;010999991510&#39;, 0, 0, 0, NULL, 1, 0, CAST(10.0000 AS Decimal(18, 4)), NULL, N&#39;010&#39;, NULL, NULL, N&#39;201&#39;, CAST(N&#39;2022-12-01T11:42:46.3552328&#39; AS DateTime2), NULL, N&#39;0840&#39;, NULL, NULL, N&#39;&#39;, NULL, NULL, NULL, 0)<br>GO<br>INSERT [dbo].[TransactionCHTs] ([SerialId], [DueDate], [PID], [OfficeCode], [TelNo], [IDOld], [OfficeCodeOld], [TelNoOld], [BillId], [BillYearMonth], [CheckCode], [CompanyCode], [AdminisOffice], [System], [CreateUserId], [CreateUser], [CreateDate], [ModiUserId], [ModiDate], [ModiUser], [ImportBatchNo], [RawData], [Hostenum], [PayDate], [ReturnCode], [MainControlSetId], [SplitSubControlSetId], [Status], [AccountNo], [Amount], [CurrentAccountNo], [TradeStatus], [ECStatus], [TradeTypeenum], [AAAAccountNo], [SortKey], [AuthorizeStatus], [ChargeFee], [MergeSubControlSetId], [BranchCode], [FISCBranchCode], [TradeBranchCode], [AccountingSubject], [ExpectedPayDate], [TransDate], [ChiefBranchCode], [AccountNoId], [ErrorMessage], [Filler], [AccountType], [CMIBUSI1], [CMIBUSI2], [IsChangeAccountNo]) VALUES (89, CAST(N&#39;2022-11-30T00:00:00.0000000&#39; AS DateTime2), N&#39;&#39;, N&#39;220&#39;, N&#39;0912000001&#39;, N&#39;&#39;, N&#39;&#39;, N&#39;&#39;, N&#39;1&#39;, N&#39;11105&#39;, N&#39;01&#39;, N&#39;200&#39;, N&#39;N&#39;, N&#39;&#39;, -1, N&#39;System&#39;, CAST(N&#39;2022-12-01T11:42:46.6841400&#39; AS DateTime2), -1, CAST(N&#39;2022-12-01T11:43:36.1750223&#39; AS DateTime2), N&#39;System&#39;, N&#39;PU202212010000010&#39;, N&#39;2084009001000210 000000200220 0912000001                                                          111105011130200N      &#39;, 2, CAST(N&#39;2023-10-02T15:13:34.6900000&#39; AS DateTime2), NULL, 418, 419, NULL, N&#39;084009001000210&#39;, CAST(200.0000 AS Decimal(18, 4)), N&#39;009001000210&#39;, 0, 0, 0, NULL, 2, 0, CAST(10.0000 AS Decimal(18, 4)), NULL, N&#39;009&#39;, NULL, NULL, N&#39;200&#39;, CAST(N&#39;2022-12-01T11:42:46.3552414&#39; AS DateTime2), NULL, N&#39;0840&#39;, NULL, NULL, N&#39;&#39;, NULL, NULL, NULL, 0)<br>GO<br>INSERT [dbo].[TransactionCHTs] ([SerialId], [DueDate], [PID], [OfficeCode], [TelNo], [IDOld], [OfficeCodeOld], [TelNoOld], [BillId], [BillYearMonth], [CheckCode], [CompanyCode], [AdminisOffice], [System], [CreateUserId], [CreateUser], [CreateDate], [ModiUserId], [ModiDate], [ModiUser], [ImportBatchNo], [RawData], [Hostenum], [PayDate], [ReturnCode], [MainControlSetId], [SplitSubControlSetId], [Status], [AccountNo], [Amount], [CurrentAccountNo], [TradeStatus], [ECStatus], [TradeTypeenum], [AAAAccountNo], [SortKey], [AuthorizeStatus], [ChargeFee], [MergeSubControlSetId], [BranchCode], [FISCBranchCode], [TradeBranchCode], [AccountingSubject], [ExpectedPayDate], [TransDate], [ChiefBranchCode], [AccountNoId], [ErrorMessage], [Filler], [AccountType], [CMIBUSI1], [CMIBUSI2], [IsChangeAccountNo]) VALUES (90, CAST(N&#39;2022-11-30T00:00:00.0000000&#39; AS DateTime2), N&#39;&#39;, N&#39;220&#39;, N&#39;0912000002&#39;, N&#39;&#39;, N&#39;&#39;, N&#39;&#39;, N&#39;1&#39;, N&#39;11105&#39;, N&#39;01&#39;, N&#39;200&#39;, N&#39;N&#39;, N&#39;&#39;, -1, N&#39;System&#39;, CAST(N&#39;2022-12-01T11:42:46.6841405&#39; AS DateTime2), -1, CAST(N&#39;2022-12-01T11:43:36.1750225&#39; AS DateTime2), N&#39;System&#39;, N&#39;PU202212010000010&#39;, N&#39;2084009001000320 000000600220 0912000002                                                          111105011130200N      &#39;, 2, CAST(N&#39;2023-10-02T15:13:34.6900000&#39; AS DateTime2), NULL, 418, 419, NULL, N&#39;084009001000320&#39;, CAST(600.0000 AS Decimal(18, 4)), N&#39;009001000320&#39;, 0, 0, 0, NULL, 3, 0, CAST(10.0000 AS Decimal(18, 4)), NULL, N&#39;009&#39;, NULL, NULL, N&#39;200&#39;, CAST(N&#39;2022-12-01T11:42:46.3552435&#39; AS DateTime2), NULL, N&#39;0840&#39;, NULL, NULL, N&#39;&#39;, NULL, NULL, NULL, 0)<br>GO<br>INSERT [dbo].[TransactionCHTs] ([SerialId], [DueDate], [PID], [OfficeCode], [TelNo], [IDOld], [OfficeCodeOld], [TelNoOld], [BillId], [BillYearMonth], [CheckCode], [CompanyCode], [AdminisOffice], [System], [CreateUserId], [CreateUser], [CreateDate], [ModiUserId], [ModiDate], [ModiUser], [ImportBatchNo], [RawData], [Hostenum], [PayDate], [ReturnCode], [MainControlSetId], [SplitSubControlSetId], [Status], [AccountNo], [Amount], [CurrentAccountNo], [TradeStatus], [ECStatus], [TradeTypeenum], [AAAAccountNo], [SortKey], [AuthorizeStatus], [ChargeFee], [MergeSubControlSetId], [BranchCode], [FISCBranchCode], [TradeBranchCode], [AccountingSubject], [ExpectedPayDate], [TransDate], [ChiefBranchCode], [AccountNoId], [ErrorMessage], [Filler], [AccountType], [CMIBUSI1], [CMIBUSI2], [IsChangeAccountNo]) VALUES (91, CAST(N&#39;2022-11-30T00:00:00.0000000&#39; AS DateTime2), N&#39;&#39;, N&#39;220&#39;, N&#39;0912000004&#39;, N&#39;&#39;, N&#39;&#39;, N&#39;&#39;, N&#39;1&#39;, N&#39;11105&#39;, N&#39;01&#39;, N&#39;200&#39;, N&#39;N&#39;, N&#39;&#39;, -1, N&#39;System&#39;, CAST(N&#39;2022-12-01T11:42:46.6841410&#39; AS DateTime2), -1, CAST(N&#39;2022-12-01T11:43:36.1750226&#39; AS DateTime2), N&#39;System&#39;, N&#39;PU202212010000010&#39;, N&#39;2084021001000380 000000050220 0912000004                                                          111105011130200N      &#39;, 2, CAST(N&#39;2023-10-02T15:13:34.6900000&#39; AS DateTime2), NULL, 418, 419, NULL, N&#39;084021001000380&#39;, CAST(50.0000 AS Decimal(18, 4)), N&#39;021001000380&#39;, 0, 0, 0, NULL, 4, 0, CAST(10.0000 AS Decimal(18, 4)), NULL, N&#39;021&#39;, NULL, NULL, N&#39;202&#39;, CAST(N&#39;2022-12-01T11:42:46.3552464&#39; AS DateTime2), NULL, N&#39;0840&#39;, NULL, NULL, N&#39;&#39;, NULL, NULL, NULL, 0)<br>GO<br>INSERT [dbo].[TransactionCHTs] ([SerialId], [DueDate], [PID], [OfficeCode], [TelNo], [IDOld], [OfficeCodeOld], [TelNoOld], [BillId], [BillYearMonth], [CheckCode], [CompanyCode], [AdminisOffice], [System], [CreateUserId], [CreateUser], [CreateDate], [ModiUserId], [ModiDate], [ModiUser], [ImportBatchNo], [RawData], [Hostenum], [PayDate], [ReturnCode], [MainControlSetId], [SplitSubControlSetId], [Status], [AccountNo], [Amount], [CurrentAccountNo], [TradeStatus], [ECStatus], [TradeTypeenum], [AAAAccountNo], [SortKey], [AuthorizeStatus], [ChargeFee], [MergeSubControlSetId], [BranchCode], [FISCBranchCode], [TradeBranchCode], [AccountingSubject], [ExpectedPayDate], [TransDate], [ChiefBranchCode], [AccountNoId], [ErrorMessage], [Filler], [AccountType], [CMIBUSI1], [CMIBUSI2], [IsChangeAccountNo]) VALUES (92, CAST(N&#39;2022-11-30T00:00:00.0000000&#39; AS DateTime2), N&#39;&#39;, N&#39;022&#39;, N&#39;0912000123&#39;, N&#39;&#39;, N&#39;&#39;, N&#39;&#39;, N&#39;1&#39;, N&#39;11105&#39;, N&#39;01&#39;, N&#39;200&#39;, N&#39;N&#39;, N&#39;&#39;, -1, N&#39;System&#39;, CAST(N&#39;2022-12-01T11:47:06.6222981&#39; AS DateTime2), -1, CAST(N&#39;2022-12-01T11:47:54.8527667&#39; AS DateTime2), N&#39;System&#39;, N&#39;PU202212010000014&#39;, N&#39;2084079777999190 000000070022 0912000123                                                          111105011130200N      &#39;, 2, CAST(N&#39;2023-10-02T15:13:34.6900000&#39; AS DateTime2), NULL, 423, 424, NULL, N&#39;084079777999190&#39;, CAST(70.0000 AS Decimal(18, 4)), N&#39;079777999190&#39;, 0, 0, 0, NULL, 0, 0, CAST(10.0000 AS Decimal(18, 4)), NULL, N&#39;079&#39;, NULL, NULL, N&#39;207&#39;, CAST(N&#39;2022-12-01T11:47:06.0942726&#39; AS DateTime2), NULL, N&#39;0840&#39;, NULL, NULL, N&#39;&#39;, NULL, NULL, NULL, 0)<br>GO<br>INSERT [dbo].[TransactionCHTs] ([SerialId], [DueDate], [PID], [OfficeCode], [TelNo], [IDOld], [OfficeCodeOld], [TelNoOld], [BillId], [BillYearMonth], [CheckCode], [CompanyCode], [AdminisOffice], [System], [CreateUserId], [CreateUser], [CreateDate], [ModiUserId], [ModiDate], [ModiUser], [ImportBatchNo], [RawData], [Hostenum], [PayDate], [ReturnCode], [MainControlSetId], [SplitSubControlSetId], [Status], [AccountNo], [Amount], [CurrentAccountNo], [TradeStatus], [ECStatus], [TradeTypeenum], [AAAAccountNo], [SortKey], [AuthorizeStatus], [ChargeFee], [MergeSubControlSetId], [BranchCode], [FISCBranchCode], [TradeBranchCode], [AccountingSubject], [ExpectedPayDate], [TransDate], [ChiefBranchCode], [AccountNoId], [ErrorMessage], [Filler], [AccountType], [CMIBUSI1], [CMIBUSI2], [IsChangeAccountNo]) VALUES (93, CAST(N&#39;2022-11-30T00:00:00.0000000&#39; AS DateTime2), N&#39;&#39;, N&#39;023&#39;, N&#39;0400001001116&#39;, N&#39;&#39;, N&#39;&#39;, N&#39;&#39;, N&#39;1&#39;, N&#39;11105&#39;, N&#39;01&#39;, N&#39;200&#39;, N&#39;N&#39;, N&#39;&#39;, -1, N&#39;System&#39;, CAST(N&#39;2022-12-01T11:47:06.6223001&#39; AS DateTime2), -1, CAST(N&#39;2022-12-01T11:47:54.8527680&#39; AS DateTime2), N&#39;System&#39;, N&#39;PU202212010000014&#39;, N&#39;2084010999991510 000000130023 0400001001116                                                       111105011130200N      &#39;, 2, CAST(N&#39;2023-10-02T15:13:34.6900000&#39; AS DateTime2), NULL, 423, 424, NULL, N&#39;084010999991510&#39;, CAST(130.0000 AS Decimal(18, 4)), N&#39;010999991510&#39;, 0, 0, 0, NULL, 1, 0, CAST(10.0000 AS Decimal(18, 4)), NULL, N&#39;010&#39;, NULL, NULL, N&#39;201&#39;, CAST(N&#39;2022-12-01T11:47:06.0955039&#39; AS DateTime2), NULL, N&#39;0840&#39;, NULL, NULL, N&#39;&#39;, NULL, NULL, NULL, 0)<br>GO<br>INSERT [dbo].[TransactionCHTs] ([SerialId], [DueDate], [PID], [OfficeCode], [TelNo], [IDOld], [OfficeCodeOld], [TelNoOld], [BillId], [BillYearMonth], [CheckCode], [CompanyCode], [AdminisOffice], [System], [CreateUserId], [CreateUser], [CreateDate], [ModiUserId], [ModiDate], [ModiUser], [ImportBatchNo], [RawData], [Hostenum], [PayDate], [ReturnCode], [MainControlSetId], [SplitSubControlSetId], [Status], [AccountNo], [Amount], [CurrentAccountNo], [TradeStatus], [ECStatus], [TradeTypeenum], [AAAAccountNo], [SortKey], [AuthorizeStatus], [ChargeFee], [MergeSubControlSetId], [BranchCode], [FISCBranchCode], [TradeBranchCode], [AccountingSubject], [ExpectedPayDate], [TransDate], [ChiefBranchCode], [AccountNoId], [ErrorMessage], [Filler], [AccountType], [CMIBUSI1], [CMIBUSI2], [IsChangeAccountNo]) VALUES (94, CAST(N&#39;2022-11-30T00:00:00.0000000&#39; AS DateTime2), N&#39;&#39;, N&#39;220&#39;, N&#39;0912000001&#39;, N&#39;&#39;, N&#39;&#39;, N&#39;&#39;, N&#39;1&#39;, N&#39;11105&#39;, N&#39;01&#39;, N&#39;200&#39;, N&#39;N&#39;, N&#39;&#39;, -1, N&#39;System&#39;, CAST(N&#39;2022-12-01T11:47:06.6223003&#39; AS DateTime2), -1, CAST(N&#39;2022-12-01T11:47:54.8527684&#39; AS DateTime2), N&#39;System&#39;, N&#39;PU202212010000014&#39;, N&#39;2084009001000210 000000200220 0912000001                                                          111105011130200N      &#39;, 2, CAST(N&#39;2023-10-02T15:13:34.6900000&#39; AS DateTime2), NULL, 423, 424, NULL, N&#39;084009001000210&#39;, CAST(200.0000 AS Decimal(18, 4)), N&#39;009001000210&#39;, 0, 0, 0, NULL, 2, 0, CAST(10.0000 AS Decimal(18, 4)), NULL, N&#39;009&#39;, NULL, NULL, N&#39;200&#39;, CAST(N&#39;2022-12-01T11:47:06.0955182&#39; AS DateTime2), NULL, N&#39;0840&#39;, NULL, NULL, N&#39;&#39;, NULL, NULL, NULL, 0)<br>GO<br>INSERT [dbo].[TransactionCHTs] ([SerialId], [DueDate], [PID], [OfficeCode], [TelNo], [IDOld], [OfficeCodeOld], [TelNoOld], [BillId], [BillYearMonth], [CheckCode], [CompanyCode], [AdminisOffice], [System], [CreateUserId], [CreateUser], [CreateDate], [ModiUserId], [ModiDate], [ModiUser], [ImportBatchNo], [RawData], [Hostenum], [PayDate], [ReturnCode], [MainControlSetId], [SplitSubControlSetId], [Status], [AccountNo], [Amount], [CurrentAccountNo], [TradeStatus], [ECStatus], [TradeTypeenum], [AAAAccountNo], [SortKey], [AuthorizeStatus], [ChargeFee], [MergeSubControlSetId], [BranchCode], [FISCBranchCode], [TradeBranchCode], [AccountingSubject], [ExpectedPayDate], [TransDate], [ChiefBranchCode], [AccountNoId], [ErrorMessage], [Filler], [AccountType], [CMIBUSI1], [CMIBUSI2], [IsChangeAccountNo]) VALUES (95, CAST(N&#39;2022-11-30T00:00:00.0000000&#39; AS DateTime2), N&#39;&#39;, N&#39;220&#39;, N&#39;0912000002&#39;, N&#39;&#39;, N&#39;&#39;, N&#39;&#39;, N&#39;1&#39;, N&#39;11105&#39;, N&#39;01&#39;, N&#39;200&#39;, N&#39;N&#39;, N&#39;&#39;, -1, N&#39;System&#39;, CAST(N&#39;2022-12-01T11:47:06.6223006&#39; AS DateTime2), -1, CAST(N&#39;2022-12-01T11:47:54.8527685&#39; AS DateTime2), N&#39;System&#39;, N&#39;PU202212010000014&#39;, N&#39;2084009001000320 000000600220 0912000002                                                          111105011130200N      &#39;, 2, CAST(N&#39;2023-10-02T15:13:34.6900000&#39; AS DateTime2), NULL, 423, 424, NULL, N&#39;084009001000320&#39;, CAST(600.0000 AS Decimal(18, 4)), N&#39;009001000320&#39;, 0, 0, 0, NULL, 3, 0, CAST(10.0000 AS Decimal(18, 4)), NULL, N&#39;009&#39;, NULL, NULL, N&#39;200&#39;, CAST(N&#39;2022-12-01T11:47:06.0955221&#39; AS DateTime2), NULL, N&#39;0840&#39;, NULL, NULL, N&#39;&#39;, NULL, NULL, NULL, 0)<br>GO<br>INSERT [dbo].[TransactionCHTs] ([SerialId], [DueDate], [PID], [OfficeCode], [TelNo], [IDOld], [OfficeCodeOld], [TelNoOld], [BillId], [BillYearMonth], [CheckCode], [CompanyCode], [AdminisOffice], [System], [CreateUserId], [CreateUser], [CreateDate], [ModiUserId], [ModiDate], [ModiUser], [ImportBatchNo], [RawData], [Hostenum], [PayDate], [ReturnCode], [MainControlSetId], [SplitSubControlSetId], [Status], [AccountNo], [Amount], [CurrentAccountNo], [TradeStatus], [ECStatus], [TradeTypeenum], [AAAAccountNo], [SortKey], [AuthorizeStatus], [ChargeFee], [MergeSubControlSetId], [BranchCode], [FISCBranchCode], [TradeBranchCode], [AccountingSubject], [ExpectedPayDate], [TransDate], [ChiefBranchCode], [AccountNoId], [ErrorMessage], [Filler], [AccountType], [CMIBUSI1], [CMIBUSI2], [IsChangeAccountNo]) VALUES (96, CAST(N&#39;2022-11-30T00:00:00.0000000&#39; AS DateTime2), N&#39;&#39;, N&#39;220&#39;, N&#39;0912000004&#39;, N&#39;&#39;, N&#39;&#39;, N&#39;&#39;, N&#39;1&#39;, N&#39;11105&#39;, N&#39;01&#39;, N&#39;200&#39;, N&#39;N&#39;, N&#39;&#39;, -1, N&#39;System&#39;, CAST(N&#39;2022-12-01T11:47:06.6223008&#39; AS DateTime2), -1, CAST(N&#39;2022-12-01T11:47:54.8527686&#39; AS DateTime2), N&#39;System&#39;, N&#39;PU202212010000014&#39;, N&#39;2084021001000380 000000050220 0912000004                                                          111105011130200N      &#39;, 2, CAST(N&#39;2023-10-02T15:13:34.6900000&#39; AS DateTime2), NULL, 423, 424, NULL, N&#39;084021001000380&#39;, CAST(50.0000 AS Decimal(18, 4)), N&#39;021001000380&#39;, 0, 0, 0, NULL, 4, 0, CAST(10.0000 AS Decimal(18, 4)), NULL, N&#39;021&#39;, NULL, NULL, N&#39;202&#39;, CAST(N&#39;2022-12-01T11:47:06.0955253&#39; AS DateTime2), NULL, N&#39;0840&#39;, NULL, NULL, N&#39;&#39;, NULL, NULL, NULL, 0)<br>GO<br>INSERT [dbo].[TransactionCHTs] ([SerialId], [DueDate], [PID], [OfficeCode], [TelNo], [IDOld], [OfficeCodeOld], [TelNoOld], [BillId], [BillYearMonth], [CheckCode], [CompanyCode], [AdminisOffice], [System], [CreateUserId], [CreateUser], [CreateDate], [ModiUserId], [ModiDate], [ModiUser], [ImportBatchNo], [RawData], [Hostenum], [PayDate], [ReturnCode], [MainControlSetId], [SplitSubControlSetId], [Status], [AccountNo], [Amount], [CurrentAccountNo], [TradeStatus], [ECStatus], [TradeTypeenum], [AAAAccountNo], [SortKey], [AuthorizeStatus], [ChargeFee], [MergeSubControlSetId], [BranchCode], [FISCBranchCode], [TradeBranchCode], [AccountingSubject], [ExpectedPayDate], [TransDate], [ChiefBranchCode], [AccountNoId], [ErrorMessage], [Filler], [AccountType], [CMIBUSI1], [CMIBUSI2], [IsChangeAccountNo]) VALUES (97, CAST(N&#39;2022-11-30T00:00:00.0000000&#39; AS DateTime2), N&#39;&#39;, N&#39;022&#39;, N&#39;0912000123&#39;, N&#39;&#39;, N&#39;&#39;, N&#39;&#39;, N&#39;1&#39;, N&#39;11105&#39;, N&#39;01&#39;, N&#39;200&#39;, N&#39;N&#39;, N&#39;&#39;, -1, N&#39;System&#39;, CAST(N&#39;2022-12-01T11:54:34.5204688&#39; AS DateTime2), -1, CAST(N&#39;2022-12-01T11:55:13.0686650&#39; AS DateTime2), N&#39;System&#39;, N&#39;PU202212010000016&#39;, N&#39;2084079777999190 000000070022 0912000123                                                          111105011130200N      &#39;, 2, CAST(N&#39;2023-10-02T15:13:34.6900000&#39; AS DateTime2), NULL, 426, 427, NULL, N&#39;084079777999190&#39;, CAST(70.0000 AS Decimal(18, 4)), N&#39;079777999190&#39;, 0, 0, 0, NULL, 0, 0, CAST(10.0000 AS Decimal(18, 4)), NULL, N&#39;079&#39;, NULL, NULL, N&#39;207&#39;, CAST(N&#39;2022-12-01T11:54:33.9702312&#39; AS DateTime2), NULL, N&#39;0840&#39;, NULL, NULL, N&#39;&#39;, NULL, NULL, NULL, 0)<br>GO<br>INSERT [dbo].[TransactionCHTs] ([SerialId], [DueDate], [PID], [OfficeCode], [TelNo], [IDOld], [OfficeCodeOld], [TelNoOld], [BillId], [BillYearMonth], [CheckCode], [CompanyCode], [AdminisOffice], [System], [CreateUserId], [CreateUser], [CreateDate], [ModiUserId], [ModiDate], [ModiUser], [ImportBatchNo], [RawData], [Hostenum], [PayDate], [ReturnCode], [MainControlSetId], [SplitSubControlSetId], [Status], [AccountNo], [Amount], [CurrentAccountNo], [TradeStatus], [ECStatus], [TradeTypeenum], [AAAAccountNo], [SortKey], [AuthorizeStatus], [ChargeFee], [MergeSubControlSetId], [BranchCode], [FISCBranchCode], [TradeBranchCode], [AccountingSubject], [ExpectedPayDate], [TransDate], [ChiefBranchCode], [AccountNoId], [ErrorMessage], [Filler], [AccountType], [CMIBUSI1], [CMIBUSI2], [IsChangeAccountNo]) VALUES (98, CAST(N&#39;2022-11-30T00:00:00.0000000&#39; AS DateTime2), N&#39;&#39;, N&#39;023&#39;, N&#39;0400001001116&#39;, N&#39;&#39;, N&#39;&#39;, N&#39;&#39;, N&#39;1&#39;, N&#39;11105&#39;, N&#39;01&#39;, N&#39;200&#39;, N&#39;N&#39;, N&#39;&#39;, -1, N&#39;System&#39;, CAST(N&#39;2022-12-01T11:54:34.5204705&#39; AS DateTime2), -1, CAST(N&#39;2022-12-01T11:55:13.0686662&#39; AS DateTime2), N&#39;System&#39;, N&#39;PU202212010000016&#39;, N&#39;2084010999991510 000000130023 0400001001116                                                       111105011130200N      &#39;, 2, CAST(N&#39;2023-10-02T15:13:34.6900000&#39; AS DateTime2), NULL, 426, 427, NULL, N&#39;084010999991510&#39;, CAST(130.0000 AS Decimal(18, 4)), N&#39;010999991510&#39;, 0, 0, 0, NULL, 1, 0, CAST(10.0000 AS Decimal(18, 4)), NULL, N&#39;010&#39;, NULL, NULL, N&#39;201&#39;, CAST(N&#39;2022-12-01T11:54:33.9712419&#39; AS DateTime2), NULL, N&#39;0840&#39;, NULL, NULL, N&#39;&#39;, NULL, NULL, NULL, 0)<br>GO<br>INSERT [dbo].[TransactionCHTs] ([SerialId], [DueDate], [PID], [OfficeCode], [TelNo], [IDOld], [OfficeCodeOld], [TelNoOld], [BillId], [BillYearMonth], [CheckCode], [CompanyCode], [AdminisOffice], [System], [CreateUserId], [CreateUser], [CreateDate], [ModiUserId], [ModiDate], [ModiUser], [ImportBatchNo], [RawData], [Hostenum], [PayDate], [ReturnCode], [MainControlSetId], [SplitSubControlSetId], [Status], [AccountNo], [Amount], [CurrentAccountNo], [TradeStatus], [ECStatus], [TradeTypeenum], [AAAAccountNo], [SortKey], [AuthorizeStatus], [ChargeFee], [MergeSubControlSetId], [BranchCode], [FISCBranchCode], [TradeBranchCode], [AccountingSubject], [ExpectedPayDate], [TransDate], [ChiefBranchCode], [AccountNoId], [ErrorMessage], [Filler], [AccountType], [CMIBUSI1], [CMIBUSI2], [IsChangeAccountNo]) VALUES (99, CAST(N&#39;2022-11-30T00:00:00.0000000&#39; AS DateTime2), N&#39;&#39;, N&#39;220&#39;, N&#39;0912000001&#39;, N&#39;&#39;, N&#39;&#39;, N&#39;&#39;, N&#39;1&#39;, N&#39;11105&#39;, N&#39;01&#39;, N&#39;200&#39;, N&#39;N&#39;, N&#39;&#39;, -1, N&#39;System&#39;, CAST(N&#39;2022-12-01T11:54:34.5204707&#39; AS DateTime2), -1, CAST(N&#39;2022-12-01T11:55:13.0686663&#39; AS DateTime2), N&#39;System&#39;, N&#39;PU202212010000016&#39;, N&#39;2084009001000210 000000200220 0912000001                                                          111105011130200N      &#39;, 2, CAST(N&#39;2023-10-02T15:13:34.6900000&#39; AS DateTime2), NULL, 426, 427, NULL, N&#39;084009001000210&#39;, CAST(200.0000 AS Decimal(18, 4)), N&#39;009001000210&#39;, 0, 0, 0, NULL, 2, 0, CAST(10.0000 AS Decimal(18, 4)), NULL, N&#39;009&#39;, NULL, NULL, N&#39;200&#39;, CAST(N&#39;2022-12-01T11:54:33.9712596&#39; AS DateTime2), NULL, N&#39;0840&#39;, NULL, NULL, N&#39;&#39;, NULL, NULL, NULL, 0)<br>GO<br>INSERT [dbo].[TransactionCHTs] ([SerialId], [DueDate], [PID], [OfficeCode], [TelNo], [IDOld], [OfficeCodeOld], [TelNoOld], [BillId], [BillYearMonth], [CheckCode], [CompanyCode], [AdminisOffice], [System], [CreateUserId], [CreateUser], [CreateDate], [ModiUserId], [ModiDate], [ModiUser], [ImportBatchNo], [RawData], [Hostenum], [PayDate], [ReturnCode], [MainControlSetId], [SplitSubControlSetId], [Status], [AccountNo], [Amount], [CurrentAccountNo], [TradeStatus], [ECStatus], [TradeTypeenum], [AAAAccountNo], [SortKey], [AuthorizeStatus], [ChargeFee], [MergeSubControlSetId], [BranchCode], [FISCBranchCode], [TradeBranchCode], [AccountingSubject], [ExpectedPayDate], [TransDate], [ChiefBranchCode], [AccountNoId], [ErrorMessage], [Filler], [AccountType], [CMIBUSI1], [CMIBUSI2], [IsChangeAccountNo]) VALUES (100, CAST(N&#39;2022-11-30T00:00:00.0000000&#39; AS DateTime2), N&#39;&#39;, N&#39;220&#39;, N&#39;0912000002&#39;, N&#39;&#39;, N&#39;&#39;, N&#39;&#39;, N&#39;1&#39;, N&#39;11105&#39;, N&#39;01&#39;, N&#39;200&#39;, N&#39;N&#39;, N&#39;&#39;, -1, N&#39;System&#39;, CAST(N&#39;2022-12-01T11:54:34.5204708&#39; AS DateTime2), -1, CAST(N&#39;2022-12-01T11:55:13.0686664&#39; AS DateTime2), N&#39;System&#39;, N&#39;PU202212010000016&#39;, N&#39;2084009001000320 000000600220 0912000002                                                          111105011130200N      &#39;, 2, CAST(N&#39;2023-10-02T15:13:34.6900000&#39; AS DateTime2), NULL, 426, 427, NULL, N&#39;084009001000320&#39;, CAST(600.0000 AS Decimal(18, 4)), N&#39;009001000320&#39;, 0, 0, 0, NULL, 3, 0, CAST(10.0000 AS Decimal(18, 4)), NULL, N&#39;009&#39;, NULL, NULL, N&#39;200&#39;, CAST(N&#39;2022-12-01T11:54:33.9712678&#39; AS DateTime2), NULL, N&#39;0840&#39;, NULL, NULL, N&#39;&#39;, NULL, NULL, NULL, 0)<br>GO<br>INSERT [dbo].[TransactionCHTs] ([SerialId], [DueDate], [PID], [OfficeCode], [TelNo], [IDOld], [OfficeCodeOld], [TelNoOld], [BillId], [BillYearMonth], [CheckCode], [CompanyCode], [AdminisOffice], [System], [CreateUserId], [CreateUser], [CreateDate], [ModiUserId], [ModiDate], [ModiUser], [ImportBatchNo], [RawData], [Hostenum], [PayDate], [ReturnCode], [MainControlSetId], [SplitSubControlSetId], [Status], [AccountNo], [Amount], [CurrentAccountNo], [TradeStatus], [ECStatus], [TradeTypeenum], [AAAAccountNo], [SortKey], [AuthorizeStatus], [ChargeFee], [MergeSubControlSetId], [BranchCode], [FISCBranchCode], [TradeBranchCode], [AccountingSubject], [ExpectedPayDate], [TransDate], [ChiefBranchCode], [AccountNoId], [ErrorMessage], [Filler], [AccountType], [CMIBUSI1], [CMIBUSI2], [IsChangeAccountNo]) VALUES (101, CAST(N&#39;2022-11-30T00:00:00.0000000&#39; AS DateTime2), N&#39;&#39;, N&#39;220&#39;, N&#39;0912000004&#39;, N&#39;&#39;, N&#39;&#39;, N&#39;&#39;, N&#39;1&#39;, N&#39;11105&#39;, N&#39;01&#39;, N&#39;200&#39;, N&#39;N&#39;, N&#39;&#39;, -1, N&#39;System&#39;, CAST(N&#39;2022-12-01T11:54:34.5204710&#39; AS DateTime2), -1, CAST(N&#39;2022-12-01T11:55:13.0686665&#39; AS DateTime2), N&#39;System&#39;, N&#39;PU202212010000016&#39;, N&#39;2084021001000380 000000050220 0912000004                                                          111105011130200N      &#39;, 2, CAST(N&#39;2023-10-02T15:13:34.6900000&#39; AS DateTime2), NULL, 426, 427, NULL, N&#39;084021001000380&#39;, CAST(50.0000 AS Decimal(18, 4)), N&#39;021001000380&#39;, 0, 0, 0, NULL, 4, 0, CAST(10.0000 AS Decimal(18, 4)), NULL, N&#39;021&#39;, NULL, NULL, N&#39;202&#39;, CAST(N&#39;2022-12-01T11:54:33.9712725&#39; AS DateTime2), NULL, N&#39;0840&#39;, NULL, NULL, N&#39;&#39;, NULL, NULL, NULL, 0)<br>GO<br>INSERT [dbo].[TransactionCHTs] ([SerialId], [DueDate], [PID], [OfficeCode], [TelNo], [IDOld], [OfficeCodeOld], [TelNoOld], [BillId], [BillYearMonth], [CheckCode], [CompanyCode], [AdminisOffice], [System], [CreateUserId], [CreateUser], [CreateDate], [ModiUserId], [ModiDate], [ModiUser], [ImportBatchNo], [RawData], [Hostenum], [PayDate], [ReturnCode], [MainControlSetId], [SplitSubControlSetId], [Status], [AccountNo], [Amount], [CurrentAccountNo], [TradeStatus], [ECStatus], [TradeTypeenum], [AAAAccountNo], [SortKey], [AuthorizeStatus], [ChargeFee], [MergeSubControlSetId], [BranchCode], [FISCBranchCode], [TradeBranchCode], [AccountingSubject], [ExpectedPayDate], [TransDate], [ChiefBranchCode], [AccountNoId], [ErrorMessage], [Filler], [AccountType], [CMIBUSI1], [CMIBUSI2], [IsChangeAccountNo]) VALUES (102, CAST(N&#39;2022-11-30T00:00:00.0000000&#39; AS DateTime2), N&#39;&#39;, N&#39;022&#39;, N&#39;0912000123&#39;, N&#39;&#39;, N&#39;&#39;, N&#39;&#39;, N&#39;1&#39;, N&#39;11105&#39;, N&#39;01&#39;, N&#39;200&#39;, N&#39;N&#39;, N&#39;&#39;, -1, N&#39;System&#39;, CAST(N&#39;2022-12-01T12:18:17.1864438&#39; AS DateTime2), -1, CAST(N&#39;2022-12-05T17:45:21.6337076&#39; AS DateTime2), N&#39;System&#39;, N&#39;PU202212010000017&#39;, N&#39;2084079777999190 000000070022 0912000123                                                          111105011130200N      &#39;, 2, CAST(N&#39;2023-10-02T15:13:34.6900000&#39; AS DateTime2), N&#39;08&#39;, 428, 429, N&#39;08&#39;, N&#39;084079777999190&#39;, CAST(70.0000 AS Decimal(18, 4)), N&#39;079777999190&#39;, 2, 0, 0, NULL, 0, 0, CAST(10.0000 AS Decimal(18, 4)), NULL, N&#39;079&#39;, NULL, NULL, N&#39;207&#39;, CAST(N&#39;2022-12-01T12:18:17.0588561&#39; AS DateTime2), NULL, N&#39;0840&#39;, NULL, NULL, N&#39;&#39;, NULL, NULL, NULL, 0)<br>GO<br>INSERT [dbo].[TransactionCHTs] ([SerialId], [DueDate], [PID], [OfficeCode], [TelNo], [IDOld], [OfficeCodeOld], [TelNoOld], [BillId], [BillYearMonth], [CheckCode], [CompanyCode], [AdminisOffice], [System], [CreateUserId], [CreateUser], [CreateDate], [ModiUserId], [ModiDate], [ModiUser], [ImportBatchNo], [RawData], [Hostenum], [PayDate], [ReturnCode], [MainControlSetId], [SplitSubControlSetId], [Status], [AccountNo], [Amount], [CurrentAccountNo], [TradeStatus], [ECStatus], [TradeTypeenum], [AAAAccountNo], [SortKey], [AuthorizeStatus], [ChargeFee], [MergeSubControlSetId], [BranchCode], [FISCBranchCode], [TradeBranchCode], [AccountingSubject], [ExpectedPayDate], [TransDate], [ChiefBranchCode], [AccountNoId], [ErrorMessage], [Filler], [AccountType], [CMIBUSI1], [CMIBUSI2], [IsChangeAccountNo]) VALUES (103, CAST(N&#39;2022-11-30T00:00:00.0000000&#39; AS DateTime2), N&#39;&#39;, N&#39;023&#39;, N&#39;0400001001116&#39;, N&#39;&#39;, N&#39;&#39;, N&#39;&#39;, N&#39;1&#39;, N&#39;11105&#39;, N&#39;01&#39;, N&#39;200&#39;, N&#39;N&#39;, N&#39;&#39;, -1, N&#39;System&#39;, CAST(N&#39;2022-12-01T12:18:17.1864459&#39; AS DateTime2), -1, CAST(N&#39;2022-12-05T17:45:21.6337095&#39; AS DateTime2), N&#39;System&#39;, N&#39;PU202212010000017&#39;, N&#39;2084010999991510 000000130023 0400001001116                                                       111105011130200N      &#39;, 2, CAST(N&#39;2023-10-02T15:13:34.6900000&#39; AS DateTime2), N&#39;08&#39;, 428, 429, N&#39;08&#39;, N&#39;084010999991510&#39;, CAST(130.0000 AS Decimal(18, 4)), N&#39;010999991510&#39;, 2, 0, 0, NULL, 1, 0, CAST(10.0000 AS Decimal(18, 4)), NULL, N&#39;010&#39;, NULL, NULL, N&#39;201&#39;, CAST(N&#39;2022-12-01T12:18:17.0591796&#39; AS DateTime2), NULL, N&#39;0840&#39;, NULL, NULL, N&#39;&#39;, NULL, NULL, NULL, 0)<br>GO<br>INSERT [dbo].[TransactionCHTs] ([SerialId], [DueDate], [PID], [OfficeCode], [TelNo], [IDOld], [OfficeCodeOld], [TelNoOld], [BillId], [BillYearMonth], [CheckCode], [CompanyCode], [AdminisOffice], [System], [CreateUserId], [CreateUser], [CreateDate], [ModiUserId], [ModiDate], [ModiUser], [ImportBatchNo], [RawData], [Hostenum], [PayDate], [ReturnCode], [MainControlSetId], [SplitSubControlSetId], [Status], [AccountNo], [Amount], [CurrentAccountNo], [TradeStatus], [ECStatus], [TradeTypeenum], [AAAAccountNo], [SortKey], [AuthorizeStatus], [ChargeFee], [MergeSubControlSetId], [BranchCode], [FISCBranchCode], [TradeBranchCode], [AccountingSubject], [ExpectedPayDate], [TransDate], [ChiefBranchCode], [AccountNoId], [ErrorMessage], [Filler], [AccountType], [CMIBUSI1], [CMIBUSI2], [IsChangeAccountNo]) VALUES (104, CAST(N&#39;2022-11-30T00:00:00.0000000&#39; AS DateTime2), N&#39;&#39;, N&#39;220&#39;, N&#39;0912000001&#39;, N&#39;&#39;, N&#39;&#39;, N&#39;&#39;, N&#39;1&#39;, N&#39;11105&#39;, N&#39;01&#39;, N&#39;200&#39;, N&#39;N&#39;, N&#39;&#39;, -1, N&#39;System&#39;, CAST(N&#39;2022-12-01T12:18:17.1864462&#39; AS DateTime2), -1, CAST(N&#39;2022-12-05T17:45:21.6337097&#39; AS DateTime2), N&#39;System&#39;, N&#39;PU202212010000017&#39;, N&#39;2084009001000210 000000200220 0912000001                                                          111105011130200N      &#39;, 2, CAST(N&#39;2023-10-02T15:13:34.6900000&#39; AS DateTime2), N&#39;&#39;, 428, 429, N&#39;&#39;, N&#39;084009001000210&#39;, CAST(200.0000 AS Decimal(18, 4)), N&#39;009001000210&#39;, 1, 0, 0, NULL, 2, 0, CAST(10.0000 AS Decimal(18, 4)), NULL, N&#39;009&#39;, NULL, NULL, N&#39;200&#39;, CAST(N&#39;2022-12-01T12:18:17.0591880&#39; AS DateTime2), NULL, N&#39;0840&#39;, NULL, NULL, N&#39;&#39;, NULL, NULL, NULL, 0)<br>GO<br>INSERT [dbo].[TransactionCHTs] ([SerialId], [DueDate], [PID], [OfficeCode], [TelNo], [IDOld], [OfficeCodeOld], [TelNoOld], [BillId], [BillYearMonth], [CheckCode], [CompanyCode], [AdminisOffice], [System], [CreateUserId], [CreateUser], [CreateDate], [ModiUserId], [ModiDate], [ModiUser], [ImportBatchNo], [RawData], [Hostenum], [PayDate], [ReturnCode], [MainControlSetId], [SplitSubControlSetId], [Status], [AccountNo], [Amount], [CurrentAccountNo], [TradeStatus], [ECStatus], [TradeTypeenum], [AAAAccountNo], [SortKey], [AuthorizeStatus], [ChargeFee], [MergeSubControlSetId], [BranchCode], [FISCBranchCode], [TradeBranchCode], [AccountingSubject], [ExpectedPayDate], [TransDate], [ChiefBranchCode], [AccountNoId], [ErrorMessage], [Filler], [AccountType], [CMIBUSI1], [CMIBUSI2], [IsChangeAccountNo]) VALUES (105, CAST(N&#39;2022-11-30T00:00:00.0000000&#39; AS DateTime2), N&#39;&#39;, N&#39;220&#39;, N&#39;0912000002&#39;, N&#39;&#39;, N&#39;&#39;, N&#39;&#39;, N&#39;1&#39;, N&#39;11105&#39;, N&#39;01&#39;, N&#39;200&#39;, N&#39;N&#39;, N&#39;&#39;, -1, N&#39;System&#39;, CAST(N&#39;2022-12-01T12:18:17.1864464&#39; AS DateTime2), -1, CAST(N&#39;2022-12-05T17:45:21.6337098&#39; AS DateTime2), N&#39;System&#39;, N&#39;PU202212010000017&#39;, N&#39;2084009001000320 000000600220 0912000002                                                          111105011130200N      &#39;, 2, CAST(N&#39;2023-10-02T15:13:34.6900000&#39; AS DateTime2), N&#39;&#39;, 428, 429, N&#39;&#39;, N&#39;084009001000320&#39;, CAST(600.0000 AS Decimal(18, 4)), N&#39;009001000320&#39;, 1, 0, 0, NULL, 3, 0, CAST(10.0000 AS Decimal(18, 4)), NULL, N&#39;009&#39;, NULL, NULL, N&#39;200&#39;, CAST(N&#39;2022-12-01T12:18:17.0591906&#39; AS DateTime2), NULL, N&#39;0840&#39;, NULL, NULL, N&#39;&#39;, NULL, NULL, NULL, 0)<br>GO<br>INSERT [dbo].[TransactionCHTs] ([SerialId], [DueDate], [PID], [OfficeCode], [TelNo], [IDOld], [OfficeCodeOld], [TelNoOld], [BillId], [BillYearMonth], [CheckCode], [CompanyCode], [AdminisOffice], [System], [CreateUserId], [CreateUser], [CreateDate], [ModiUserId], [ModiDate], [ModiUser], [ImportBatchNo], [RawData], [Hostenum], [PayDate], [ReturnCode], [MainControlSetId], [SplitSubControlSetId], [Status], [AccountNo], [Amount], [CurrentAccountNo], [TradeStatus], [ECStatus], [TradeTypeenum], [AAAAccountNo], [SortKey], [AuthorizeStatus], [ChargeFee], [MergeSubControlSetId], [BranchCode], [FISCBranchCode], [TradeBranchCode], [AccountingSubject], [ExpectedPayDate], [TransDate], [ChiefBranchCode], [AccountNoId], [ErrorMessage], [Filler], [AccountType], [CMIBUSI1], [CMIBUSI2], [IsChangeAccountNo]) VALUES (106, CAST(N&#39;2022-11-30T00:00:00.0000000&#39; AS DateTime2), N&#39;&#39;, N&#39;220&#39;, N&#39;0912000004&#39;, N&#39;&#39;, N&#39;&#39;, N&#39;&#39;, N&#39;1&#39;, N&#39;11105&#39;, N&#39;01&#39;, N&#39;200&#39;, N&#39;N&#39;, N&#39;&#39;, -1, N&#39;System&#39;, CAST(N&#39;2022-12-01T12:18:17.1864467&#39; AS DateTime2), -1, CAST(N&#39;2022-12-05T17:45:21.6337099&#39; AS DateTime2), N&#39;System&#39;, N&#39;PU202212010000017&#39;, N&#39;2084021001000380 000000050220 0912000004                                                          111105011130200N      &#39;, 2, CAST(N&#39;2023-10-02T15:13:34.6900000&#39; AS DateTime2), N&#39;&#39;, 428, 429, N&#39;&#39;, N&#39;084021001000380&#39;, CAST(50.0000 AS Decimal(18, 4)), N&#39;021001000380&#39;, 1, 0, 0, NULL, 4, 0, CAST(10.0000 AS Decimal(18, 4)), NULL, N&#39;021&#39;, NULL, NULL, N&#39;202&#39;, CAST(N&#39;2022-12-01T12:18:17.0592034&#39; AS DateTime2), NULL, N&#39;0840&#39;, NULL, NULL, N&#39;&#39;, NULL, NULL, NULL, 0)<br>GO</pre><p>查看分布</p><pre>SELECT * FROM PartitionInfo(&#39;TransactionCHTs&#39;);</pre><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*uwaz2m5tnqtlpPlSD9n2YA.png" /></figure><p>自動化新增排程</p><pre>SELECT o.name as table_name, <br>  pf.name as PartitionFunction, <br>  ps.name as PartitionScheme, <br>  Convert(DATETIME,MAX(rv.value)) AS LastPartitionRange,<br>  CASE WHEN MAX(rv.value) &lt;= DATEADD(MONTH, 2, GETDATE()) THEN 1 else 0 END AS isRequiredMaintenance<br>INTO #temp<br>FROM sys.partitions p<br>INNER JOIN sys.indexes i ON p.object_id = i.object_id AND p.index_id = i.index_id<br>INNER JOIN sys.objects o ON p.object_id = o.object_id<br>INNER JOIN sys.system_internals_allocation_units au ON p.partition_id = au.container_id<br>INNER JOIN sys.partition_schemes ps ON ps.data_space_id = i.data_space_id<br>INNER JOIN sys.partition_functions pf ON pf.function_id = ps.function_id<br>INNER JOIN sys.partition_range_values rv ON pf.function_id = rv.function_id AND p.partition_number = rv.boundary_id<br>GROUP BY o.name, pf.name, ps.name<br><br>SELECT table_name, <br>  PartitionFunction, <br>  PartitionScheme, <br>  LastPartitionRange,<br>  CONVERT(VARCHAR, DATEADD(YEAR, 1, LastPartitionRange), 25) AS NewRange,<br>  &#39;TESTDB_History_FG&#39; +<br>    CAST(YEAR(DATEADD(YEAR, 1, LastPartitionRange)) AS VARCHAR(4)) AS NewFileGroup,<br>  &#39;TESTDB_History&#39; + CAST(YEAR(DATEADD(YEAR, 1, LastPartitionRange)) AS VARCHAR(4)) AS FileName,<br>  &#39;D:\DBFiles\&#39; AS file_path<br>INTO #generateScript<br>FROM #temp<br>WHERE isRequiredMaintenance = 1<br><br><br>DECLARE @filegroup NVARCHAR(MAX) = &#39;&#39;<br>DECLARE @file NVARCHAR(MAX) = &#39;&#39;<br>DECLARE @PScheme NVARCHAR(MAX) = &#39;&#39;<br>DECLARE @PFunction NVARCHAR(MAX) = &#39;&#39;<br> <br>SELECT @filegroup = @filegroup + <br>    CONCAT(&#39;IF NOT EXISTS(SELECT 1 FROM TESTDB_History.sys.filegroups WHERE name = &#39;&#39;&#39;,NewFileGroup,&#39;&#39;&#39;)<br>    BEGIN<br>      ALTER DATABASE TESTDB_History ADD FileGroup &#39;,NewFileGroup,&#39; <br>    END;&#39;),<br>    @file = @file + CONCAT(&#39;IF NOT EXISTS(SELECT 1 FROM TESTDB_History.sys.database_files WHERE name = &#39;&#39;&#39;,FileName,&#39;&#39;&#39;)<br>    BEGIN<br>    ALTER DATABASE TESTDB_History ADD FILE <br>    (NAME = &#39;&#39;&#39;,FileName,&#39;&#39;&#39;, <br>    FILENAME = &#39;&#39;&#39;,File_Path,FileName,&#39;.ndf&#39;&#39;, <br>    SIZE = 5MB, MAXSIZE = UNLIMITED, <br>    FILEGROWTH = 10MB )<br>    TO FILEGROUP &#39;,NewFileGroup, &#39;<br>    END;&#39;),<br>    @PScheme = @PScheme + CONCAT(&#39;ALTER PARTITION SCHEME &#39;, PartitionScheme, &#39; NEXT USED &#39;,NewFileGroup,&#39;;&#39;),<br>    @PFunction = @PFunction + CONCAT(&#39;ALTER PARTITION FUNCTION &#39;, PartitionFunction, &#39;() SPLIT RANGE (&#39;&#39;&#39;,NewRange,&#39;&#39;&#39;);&#39;)<br>FROM #generateScript<br> <br>EXEC (@filegroup)<br>EXEC (@file)<br>EXEC (@PScheme)<br>EXEC (@PFunction)</pre><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=5d8a2995c01c" width="1" height="1" alt="">]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[EDA implement （Event-Driven Architecture）]]></title>
            <link>https://medium.com/@harrychen1471/eda-implement-event-driven-architecture-ff3627c60815?source=rss-28d4c335fd94------2</link>
            <guid isPermaLink="false">https://medium.com/p/ff3627c60815</guid>
            <dc:creator><![CDATA[DeronChen]]></dc:creator>
            <pubDate>Wed, 16 Oct 2024 07:29:35 GMT</pubDate>
            <atom:updated>2024-10-16T07:29:35.784Z</atom:updated>
            <content:encoded><![CDATA[<p>When designing a high-concurrency system, there are several key strategies and best practices to consider. Today, we will discuss Event-Driven Architecture (EDA).</p><p>There are many ways to implement EDA, with the main characteristics as follows:</p><ol><li><strong>Event-Oriented</strong><br>In this model, each request can be viewed as an event. By temporarily storing requests in a cache, the system can concentrate on processing these events.</li><li><strong>Asynchronous Processing</strong><br>Requests in the cache can be processed in batches without affecting user experience, aligning with the asynchronous nature of event-driven architecture.</li><li><strong>Decoupling</strong><br>Decoupling requests from backend processing logic allows the system to dynamically adjust processing strategies based on traffic and demand.</li><li><strong>Flexibility and Scalability</strong><br>This design makes the system more resilient, capable of handling high-concurrency traffic and easily scalable.</li></ol><p>Below is a simple example: suppose we have a high-concurrency system that needs to handle a large amount of traffic. Since I cannot access the database for every single request, I adopt an EDA approach. Each request is treated as an event and stored in a singleton processing cache. At fixed intervals, the contents of the cache are retrieved for subsequent processing.</p><pre>//請求模型<br>public class Request<br>{<br>    public string Id { get; set; }<br>    public string Data { get; set; }<br>}<br><br><br>//緩存管理<br>using Microsoft.Extensions.Caching.Memory;<br>public class RequestCache<br>{<br>    private readonly IMemoryCache _cache;<br><br>    public RequestCache(IMemoryCache cache)<br>    {<br>        _cache = cache;<br>    }<br><br>    public void AddRequest(string key, Request request)<br>    {<br>        _cache.Set(key, request);<br>    }<br><br>    public List&lt;Request&gt; GetAllRequests()<br>    {<br>        var requests = new List&lt;Request&gt;();<br>        foreach (var item in _cache)<br>        {<br>            requests.Add((Request)item.Value);<br>        }<br>        return requests;<br>    }<br><br>    public void RemoveRequest(string key)<br>    {<br>        _cache.Remove(key);<br>    }<br>}<br><br>//請求處理<br>using System.Timers;<br>public class RequestProcessor<br>{<br>    private readonly RequestCache _requestCache;<br>    private Timer _timer;<br><br>    public RequestProcessor(RequestCache requestCache)<br>    {<br>        _requestCache = requestCache;<br>        _timer = new Timer(300000); // 5 minutes<br>        _timer.Elapsed += ProcessRequests;<br>        _timer.Start();<br>    }<br><br>    private void ProcessRequests(object sender, ElapsedEventArgs e)<br>    {<br>        var requests = _requestCache.GetAllRequests();<br>        if (requests.Count &gt; 0)<br>        {<br>            // 處理請求邏輯<br>            foreach (var request in requests)<br>            {<br>                Console.WriteLine($&quot;Processing request: {request.Id} with data: {request.Data}&quot;);<br>                _requestCache.RemoveRequest(request.Id); // 處理完後移除<br>            }<br>        }<br>    }<br>}<br><br>// 主程式<br>using Microsoft.Extensions.DependencyInjection;<br>class Program<br>{<br>    static void Main(string[] args)<br>    {<br>        var serviceProvider = new ServiceCollection()<br>            .AddMemoryCache()<br>            .AddSingleton&lt;RequestCache&gt;()<br>            .AddSingleton&lt;RequestProcessor&gt;()<br>            .BuildServiceProvider();<br><br>        var requestCache = serviceProvider.GetService&lt;RequestCache&gt;();<br>        var requestProcessor = serviceProvider.GetService&lt;RequestProcessor&gt;();<br><br>        // 模擬請求<br>        for (int i = 1; i &lt;= 10; i++)<br>        {<br>            var request = new Request { Id = $&quot;Request-{i}&quot;, Data = $&quot;Data-{i}&quot; };<br>            requestCache.AddRequest(request.Id, request);<br>            Console.WriteLine($&quot;Added: {request.Id}&quot;);<br>        }<br><br>        Console.WriteLine(&quot;Press any key to exit...&quot;);<br>        Console.ReadKey();<br>    }<br>}</pre><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=ff3627c60815" width="1" height="1" alt="">]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[SQL Server Backup Types and Recovery Model Mechanism]]></title>
            <link>https://medium.com/@harrychen1471/sql-server-backup-types-and-recovery-model-mechanism-18d4c574f7fd?source=rss-28d4c335fd94------2</link>
            <guid isPermaLink="false">https://medium.com/p/18d4c574f7fd</guid>
            <dc:creator><![CDATA[DeronChen]]></dc:creator>
            <pubDate>Wed, 16 Oct 2024 06:05:38 GMT</pubDate>
            <atom:updated>2024-10-16T06:07:19.802Z</atom:updated>
            <content:encoded><![CDATA[<p>💡 <strong>Usage Scenarios</strong></p><ul><li>🔹 <strong>Development</strong>: Copying customer data to achieve data consistency.</li><li>🔹 <strong>Operations</strong>: SQL Agent creates scheduled backups, disaster recovery drills, and restoration when a critical issue occurs in the database.</li></ul><p>📚 <strong>Concepts</strong> <strong>Transaction Log</strong> — The transaction log records various types of operations, including:</p><ul><li>🔹 Start and end of each transaction.</li><li>🔹 Each data modification (insert, update, or delete). Modifications include changes made by system stored procedures or Data Definition Language (DDL) statements on any tables, including system tables.</li><li>🔹 Each configuration or deconfiguration of ranges and pages.</li><li>🔹 Creation or removal of tables or indexes.</li></ul><p><strong>Recovery Model ➔ Backup ➔ Restore</strong> 📚 <strong>Recovery Model</strong></p><p>💡 This setting determines how a database handles its transaction logs. Different models process backups and restores differently.</p><p><strong>Full Recovery Model</strong></p><ul><li>🔹 Complete retention of transaction logs; full backups, differential backups, and transaction log backups can be used.</li><li>🔹 Requires more space, necessitating regular backups and compression of transaction log files to prevent excessive growth.</li></ul><p><strong>Simple Recovery Model</strong></p><ul><li>🔹 Automatically truncates completed or rolled-back transaction logs whenever a checkpoint occurs (e.g., when the transaction log reaches a certain size), not retaining past transaction logs.</li><li>🔹 Can use full backups and differential backups.</li></ul><p><strong>Bulk-Logged Recovery Model</strong></p><ul><li>🔹 Most transaction logs are retained except for bulk operations logged in a minimal manner.</li><li>🔹 Cannot guarantee restoring the database to any point in time due to the absence of complete transaction logs for bulk operations.</li></ul><p>📚 <strong>Backup Types</strong></p><p>💡 Describes the differences between various backup types; in practice, they are often used in combination, as described by MSDN: a full database backup weekly; a differential database backup daily; and a high-frequency backup of transaction logs (up to every 15 to 30 minutes).</p><p><strong>Full Backup</strong></p><ul><li>🔹 Backs up the entire database, including data files and parts of the transaction log, allowing for a complete restoration of the database.</li><li>🔹 Full backups may lead to excessive storage and backup redundancy.</li></ul><p><strong>Differential Backup</strong></p><ul><li>🔹 Backs up the changes made since the last full backup. It captures only the data that has changed since the last full backup.</li></ul><p><strong>Transaction Log Backup</strong></p><ul><li>🔹 Retains the complete state of data changes. To perform a transaction log backup, the database must be in either [Full] or [Bulk-Logged] recovery mode.</li><li>🔹 A full backup must be created first.</li></ul><p>📚 <strong>Options for Restoring Database Recovery States</strong> 💡 Before executing a restore operation, it’s essential to understand the recovery state options provided by SQL Server to perform the restoration correctly.</p><p><strong>RECOVERY</strong></p><ul><li>🔹 This is the default value when executing the SQL Command Restore.</li><li>🔹 It will recover all transactions and set the database to a normal accessible state. Typically, this option is used in the last restore operation. For instance, if you want to restore to Wednesday at 7 AM with Full Backup #1, Differential Backup #1, and Transaction Log Backup #3, then Transaction Log Backup #3 would be the last restore operation where you would use the RECOVERY option.</li></ul><p><strong>NORECOVERY</strong></p><ul><li>🔹 The database is in a restoring state and cannot be accessed. This is the opposite of RECOVERY and is used in non-final restore operations. In the previous example, Full Backup #1 and Differential Backup #1 would require using the NORECOVERY option during the restore operation.</li></ul><p><strong>STANDBY</strong></p><ul><li>🔹 The database is in a read-only state, allowing users to perform queries. STANDBY will roll back uncommitted transactions to avoid locking queries, and all recovery actions will be logged in a standby file. If the standby file is corrupted, it must be restored again.</li></ul><p>📚 <strong>Other Methods to Obtain Database Structure or Data</strong></p><ul><li>🔹 Detaching/attaching the database’s MDF and LDF files.</li><li>🔹 Generating scripts to capture all or part of the data or schema.</li><li>🔹 Importing/exporting data application layers, similar to generating scripts, can be done with Azure SQL.</li></ul><p>📚 <strong>Examples</strong></p><ul><li>🔹 MSDN — Log Chain Restore: Link</li><li>🔹 Full Backup + Transaction Log Backup: <a href="https://learn.microsoft.com/zh-tw/sql/relational-databases/backup-restore/restore-a-sql-server-database-to-a-point-in-time-full-recovery-model?view=sql-server-ver16#TsqlExample">Link</a></li></ul><p>💬 <strong>References</strong></p><ul><li>MSDN — Transaction Logs: <a href="https://learn.microsoft.com/zh-tw/sql/relational-databases/sql-server-transaction-log-architecture-and-management-guide?view=sql-server-ver16">Link</a></li><li>MSDN — Recovery Models: <a href="https://learn.microsoft.com/zh-tw/sql/relational-databases/backup-restore/recovery-models-sql-server?view=sql-server-ver16">Link</a></li><li>SQL Server Ultimate Guide: <a href="https://ithelp.ithome.com.tw/articles/10028383">Link</a></li><li>Three Methods for Backing Up and Restoring SQL Server Schema and Data: <a href="https://blog.yowko.com/sql-server-backup-restore/">Link</a></li></ul><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=18d4c574f7fd" width="1" height="1" alt="">]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[Strategy Pattern vs Factory Pattern]]></title>
            <link>https://medium.com/@harrychen1471/strategy-pattern-vs-factory-pattern-757c2a22dab7?source=rss-28d4c335fd94------2</link>
            <guid isPermaLink="false">https://medium.com/p/757c2a22dab7</guid>
            <dc:creator><![CDATA[DeronChen]]></dc:creator>
            <pubDate>Wed, 16 Oct 2024 05:52:18 GMT</pubDate>
            <atom:updated>2024-10-16T05:52:18.252Z</atom:updated>
            <content:encoded><![CDATA[<h3>1. Introduction</h3><p>In software design, both the Strategy Pattern and the Factory Pattern are commonly used design patterns, but they address different problems. Understanding the differences and applications of these patterns is crucial for designing flexible and maintainable systems.</p><h3>2. Strategy Pattern</h3><p><strong>Strategy Pattern</strong> is a behavioral design pattern that defines a family of algorithms, encapsulates each algorithm, and makes them interchangeable. This design allows the behavior of an algorithm to change independently from the clients that use it.</p><h4>Characteristics:</h4><ul><li>Defines an interface for a family of algorithms.</li><li>Clients can choose the desired algorithm at runtime.</li><li>New algorithms can be added without modifying existing code.</li></ul><h4>Example:</h4><p>Consider a pricing system where different customers may have different discount strategies.</p><pre>public interface IDiscountStrategy<br>{<br>    decimal ApplyDiscount(decimal price);<br>}<br>public class NoDiscountStrategy : IDiscountStrategy<br>{<br>    public decimal ApplyDiscount(decimal price) =&gt; price;<br>}<br>public class SeasonalDiscountStrategy : IDiscountStrategy<br>{<br>    public decimal ApplyDiscount(decimal price) =&gt; price * 0.9m; // 10% discount<br>}<br>public class ShoppingCart<br>{<br>    private IDiscountStrategy _discountStrategy;<br>    public ShoppingCart(IDiscountStrategy discountStrategy)<br>    {<br>        _discountStrategy = discountStrategy;<br>    }<br>    public void SetDiscountStrategy(IDiscountStrategy discountStrategy)<br>    {<br>        _discountStrategy = discountStrategy;<br>    }<br>    public decimal CalculatePrice(decimal price)<br>    {<br>        return _discountStrategy.ApplyDiscount(price);<br>    }<br>}</pre><h3>3. Factory Pattern</h3><p><strong>Factory Pattern</strong> is a creational design pattern that provides an interface for creating objects without specifying the exact class of object that will be created. The main goal of the Factory Pattern is to separate the logic of object creation from the logic of using the object.</p><h4>Characteristics:</h4><ul><li>Encapsulates the details of object creation.</li><li>Allows the creation logic to be centralized.</li><li>Can generate different objects based on varying needs.</li></ul><h4>Example:</h4><p>Suppose we need to create different types of payment methods.</p><pre>public interface IPayment<br>{<br>    void ProcessPayment(decimal amount);<br>}<br>public class CreditCardPayment : IPayment<br>{<br>    public void ProcessPayment(decimal amount) =&gt; Console.WriteLine($&quot;Processing credit card payment of {amount}&quot;);<br>}<br>public class PayPalPayment : IPayment<br>{<br>    public void ProcessPayment(decimal amount) =&gt; Console.WriteLine($&quot;Processing PayPal payment of {amount}&quot;);<br>}<br>public class PaymentFactory<br>{<br>    public static IPayment CreatePayment(string type)<br>    {<br>        return type switch<br>        {<br>            &quot;CreditCard&quot; =&gt; new CreditCardPayment(),<br>            &quot;PayPal&quot; =&gt; new PayPalPayment(),<br>            _ =&gt; throw new ArgumentException(&quot;Invalid payment type&quot;)<br>        };<br>    }<br>}</pre><h3>4. Comparison of Strategy Pattern and Factory Pattern</h3><figure><img alt="" src="https://cdn-images-1.medium.com/max/793/1*6JkX1WcRff678o7wGCGdrw.png" /></figure><p>FeatureStrategy PatternFactory PatternTypeBehavioral design patternCreational design patternPrimary PurposeEncapsulate algorithms, allowing runtime selectionEncapsulate object creation logicUsage ScenarioWhen multiple algorithms are needed and should be interchangeable at runtimeWhen different types of objects need to be created while hiding the creation detailsExtensibilityAdding new algorithms does not require modifying existing codeAdding new object types requires only modifying the factory class</p><h3>5. Conclusion</h3><p>Both the Strategy Pattern and the Factory Pattern are important tools for designing well-structured systems. The Strategy Pattern emphasizes behavioral flexibility, while the Factory Pattern focuses on the flexibility of object creation. Choosing the right pattern based on specific needs can make a system more maintainable and extensible.</p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=757c2a22dab7" width="1" height="1" alt="">]]></content:encoded>
        </item>
    </channel>
</rss>