0:00:50 16 กุมภาพันธ์ 2561 :Index was out of range. Must be non-negative and less than the size of the collection. Parameter name: index 0:00:50 16 กุมภาพันธ์ 2561 :try to logon with: GS1WS 0:22:05 16 กุมภาพันธ์ 2561 :Index was out of range. Must be non-negative and less than the size of the collection. Parameter name: index 0:22:05 16 กุมภาพันธ์ 2561 :try to logon with: GS1WS 0:29:22 16 กุมภาพันธ์ 2561 :Index was out of range. Must be non-negative and less than the size of the collection. Parameter name: index 0:29:22 16 กุมภาพันธ์ 2561 :try to logon with: GS1WS 0:44:20 16 กุมภาพันธ์ 2561 :Index was out of range. Must be non-negative and less than the size of the collection. Parameter name: index 0:44:20 16 กุมภาพันธ์ 2561 :try to logon with: GS1WS 1:00:49 16 กุมภาพันธ์ 2561 :Index was out of range. Must be non-negative and less than the size of the collection. Parameter name: index 1:00:49 16 กุมภาพันธ์ 2561 :try to logon with: GS1WS 2:00:48 16 กุมภาพันธ์ 2561 :Index was out of range. Must be non-negative and less than the size of the collection. Parameter name: index 2:00:48 16 กุมภาพันธ์ 2561 :try to logon with: GS1WS 3:00:48 16 กุมภาพันธ์ 2561 :Index was out of range. Must be non-negative and less than the size of the collection. Parameter name: index 3:00:48 16 กุมภาพันธ์ 2561 :try to logon with: GS1WS 4:00:48 16 กุมภาพันธ์ 2561 :Index was out of range. Must be non-negative and less than the size of the collection. Parameter name: index 4:00:48 16 กุมภาพันธ์ 2561 :try to logon with: GS1WS 5:00:52 16 กุมภาพันธ์ 2561 :Index was out of range. Must be non-negative and less than the size of the collection. Parameter name: index 5:00:52 16 กุมภาพันธ์ 2561 :try to logon with: GS1WS 5:43:42 16 กุมภาพันธ์ 2561 :Index was out of range. Must be non-negative and less than the size of the collection. Parameter name: index 5:43:42 16 กุมภาพันธ์ 2561 :try to logon with: GS1WS 5:44:33 16 กุมภาพันธ์ 2561 :Index was out of range. Must be non-negative and less than the size of the collection. Parameter name: index 5:44:33 16 กุมภาพันธ์ 2561 :try to logon with: GS1WS 5:45:29 16 กุมภาพันธ์ 2561 :Index was out of range. Must be non-negative and less than the size of the collection. Parameter name: index 5:45:29 16 กุมภาพันธ์ 2561 :try to logon with: GS1WS 5:45:46 16 กุมภาพันธ์ 2561 :Index was out of range. Must be non-negative and less than the size of the collection. Parameter name: index 5:45:46 16 กุมภาพันธ์ 2561 :try to logon with: GS1WS 5:46:02 16 กุมภาพันธ์ 2561 :Index was out of range. Must be non-negative and less than the size of the collection. Parameter name: index 5:46:02 16 กุมภาพันธ์ 2561 :try to logon with: GS1WS 5:53:59 16 กุมภาพันธ์ 2561 :Index was out of range. Must be non-negative and less than the size of the collection. Parameter name: index 5:53:59 16 กุมภาพันธ์ 2561 :try to logon with: GS1WS 5:58:10 16 กุมภาพันธ์ 2561 :Index was out of range. Must be non-negative and less than the size of the collection. Parameter name: index 5:58:10 16 กุมภาพันธ์ 2561 :try to logon with: GS1WS 6:00:48 16 กุมภาพันธ์ 2561 :Index was out of range. Must be non-negative and less than the size of the collection. Parameter name: index 6:00:48 16 กุมภาพันธ์ 2561 :try to logon with: GS1WS 6:02:12 16 กุมภาพันธ์ 2561 :Index was out of range. Must be non-negative and less than the size of the collection. Parameter name: index 6:02:12 16 กุมภาพันธ์ 2561 :try to logon with: GS1WS 6:08:33 16 กุมภาพันธ์ 2561 :Index was out of range. Must be non-negative and less than the size of the collection. Parameter name: index 6:08:33 16 กุมภาพันธ์ 2561 :try to logon with: GS1WS 6:08:56 16 กุมภาพันธ์ 2561 :Index was out of range. Must be non-negative and less than the size of the collection. Parameter name: index 6:08:56 16 กุมภาพันธ์ 2561 :try to logon with: GS1WS 6:15:54 16 กุมภาพันธ์ 2561 :Index was out of range. Must be non-negative and less than the size of the collection. Parameter name: index 6:15:54 16 กุมภาพันธ์ 2561 :try to logon with: GS1WS 6:19:34 16 กุมภาพันธ์ 2561 :Index was out of range. Must be non-negative and less than the size of the collection. Parameter name: index 6:19:34 16 กุมภาพันธ์ 2561 :try to logon with: GS1WS 6:20:54 16 กุมภาพันธ์ 2561 :Index was out of range. Must be non-negative and less than the size of the collection. Parameter name: index 6:20:54 16 กุมภาพันธ์ 2561 :try to logon with: GS1WS 6:22:12 16 กุมภาพันธ์ 2561 :Index was out of range. Must be non-negative and less than the size of the collection. Parameter name: index 6:22:12 16 กุมภาพันธ์ 2561 :try to logon with: GS1WS 6:23:23 16 กุมภาพันธ์ 2561 :Index was out of range. Must be non-negative and less than the size of the collection. Parameter name: index 6:23:23 16 กุมภาพันธ์ 2561 :try to logon with: GS1WS 6:26:55 16 กุมภาพันธ์ 2561 :Index was out of range. Must be non-negative and less than the size of the collection. Parameter name: index 6:26:55 16 กุมภาพันธ์ 2561 :try to logon with: GS1WS 7:00:48 16 กุมภาพันธ์ 2561 :Index was out of range. Must be non-negative and less than the size of the collection. Parameter name: index 7:00:48 16 กุมภาพันธ์ 2561 :try to logon with: GS1WS 7:01:18 16 กุมภาพันธ์ 2561 :getGS1changed=/*SELECT MB_MEMBER.MEMBER_CODE, MB_PRENAME.PRENAME_TH, MB_COMP_PERSON.COMP_PERSON_NAME_TH, MB_PRENAME.PRENAME_EN, MB_COMP_PERSON.COMP_PERSON_NAME_EN, MB_COMP_PERSON.TAX_ID, MB_MEMBER.REGIST_DATE, MB_MEMBER.MEMBER_MAIN_TYPE_CODE, MB_MEMBER.MEMBER_TYPE_CODE, MB_MEMBER.MEMBER_STATUS_CODE, MB_MEMBER_RETIRE.APPROVE_DATE FROM MB_MEMBER INNER JOIN MB_COMP_PERSON ON MB_MEMBER.COMP_PERSON_CODE = MB_COMP_PERSON.COMP_PERSON_CODE INNER JOIN MB_MEMBER_RETIRE ON MB_MEMBER.REGIST_CODE = MB_MEMBER_RETIRE.REGIST_CODE LEFT OUTER JOIN MB_PRENAME ON MB_COMP_PERSON.PREN_CODE = MB_PRENAME.PRENAME_CODE WHERE (MB_MEMBER.MEMBER_MAIN_GROUP_CODE = '300') AND (MB_MEMBER_RETIRE.APPROVE_DATE BETWEEN dbo.fnc_StrToDateTime(@YYYYMMDD_FROM + '000000') AND dbo.fnc_StrToDateTime(@YYYYMMDD_TO + '235959')) ORDER BY MB_MEMBER_RETIRE.APPROVE_DATE*/ --declare @YYYYMMDD_FROM varchar(max) = '20171101' --declare @YYYYMMDD_TO varchar(max) = '20171201' create table tempWsGs1_001 ( id int, tax_id varchar(max) ) create table tempWsGs1_002 ( MEMBER_CODE varchar(max) , TAX_ID varchar(max) , BDB_CODE varchar(max) , MEMBER_MAIN_TYPE_CODE varchar(max) , MEMBER_MAIN_TYPE_NAME varchar(max) , MEMBER_TYPE_CODE varchar(max) , MEMBER_TYPE_NAME varchar(max) , BUSSINESS_TYPE_TH varchar(max) , BUSSINESS_TYPE_EN varchar(max) , PRENAME_TH varchar(max) , COMP_PERSON_NAME_TH varchar(max) , PRENAME_EN varchar(max) , COMP_PERSON_NAME_EN varchar(max) , ADDR_TH varchar(max) , ADDR_EN varchar(max) , ZIP_CODE_TH varchar(max) , ZIP_CODE_EN varchar(max) , TELEPHONE_TH varchar(max) , TELEPHONE_EN varchar(max) , EMAIL_TH varchar(max) , EMAIL_EN varchar(max) , STATUS varchar(max) , REGIST_DATE varchar(max) , MEMBER_DATE varchar(max) , UPDATE_DATE varchar(max) , CompanyPrefix varchar(max) ) insert into tempWsGs1_001 select distinct ROW_NUMBER() over (order by r.approve_date) as id, c.TAX_ID as tax_id from MB_MEMBER m,MB_COMP_PERSON c,MB_MEMBER_RETIRE r where r.REGIST_CODE=m.REGIST_CODE and m.MEMBER_MAIN_GROUP_CODE='300' and m.COMP_PERSON_CODE=c.COMP_PERSON_CODE AND (r.APPROVE_DATE BETWEEN dbo.fnc_StrToDateTime(@YYYYMMDD_FROM + '000000') AND dbo.fnc_StrToDateTime(@YYYYMMDD_TO + '235959')) declare @id int declare @totalRows int = (select count(*) from tempWsGs1_001) declare @currentRow int = 0 declare @BussinessTypeTH VARCHAR(max) declare @BussinessTypeEN VARCHAR(max) while @currentRow < @totalRows begin set @id = @currentRow+1 declare @TAX_ID varchar(max) set @TAX_ID = (select top 1 tax_id from tempWsGs1_001 where id=@id) insert into tempWsGs1_002 select * from fnc_GetGS1MemberInfoForWebServiceByTaxID(@TAX_ID) set @currentRow = @currentRow +1 end drop table tempWsGs1_001 select * from tempWsGs1_002 drop table tempWsGs1_002 7:01:18 16 กุมภาพันธ์ 2561 :Execution Timeout Expired. The timeout period elapsed prior to completion of the operation or the server is not responding. 8:00:48 16 กุมภาพันธ์ 2561 :Index was out of range. Must be non-negative and less than the size of the collection. Parameter name: index 8:00:48 16 กุมภาพันธ์ 2561 :try to logon with: GS1WS 8:00:48 16 กุมภาพันธ์ 2561 :getGS1changed=/*SELECT MB_MEMBER.MEMBER_CODE, MB_PRENAME.PRENAME_TH, MB_COMP_PERSON.COMP_PERSON_NAME_TH, MB_PRENAME.PRENAME_EN, MB_COMP_PERSON.COMP_PERSON_NAME_EN, MB_COMP_PERSON.TAX_ID, MB_MEMBER.REGIST_DATE, MB_MEMBER.MEMBER_MAIN_TYPE_CODE, MB_MEMBER.MEMBER_TYPE_CODE, MB_MEMBER.MEMBER_STATUS_CODE, MB_MEMBER_RETIRE.APPROVE_DATE FROM MB_MEMBER INNER JOIN MB_COMP_PERSON ON MB_MEMBER.COMP_PERSON_CODE = MB_COMP_PERSON.COMP_PERSON_CODE INNER JOIN MB_MEMBER_RETIRE ON MB_MEMBER.REGIST_CODE = MB_MEMBER_RETIRE.REGIST_CODE LEFT OUTER JOIN MB_PRENAME ON MB_COMP_PERSON.PREN_CODE = MB_PRENAME.PRENAME_CODE WHERE (MB_MEMBER.MEMBER_MAIN_GROUP_CODE = '300') AND (MB_MEMBER_RETIRE.APPROVE_DATE BETWEEN dbo.fnc_StrToDateTime(@YYYYMMDD_FROM + '000000') AND dbo.fnc_StrToDateTime(@YYYYMMDD_TO + '235959')) ORDER BY MB_MEMBER_RETIRE.APPROVE_DATE*/ --declare @YYYYMMDD_FROM varchar(max) = '20171101' --declare @YYYYMMDD_TO varchar(max) = '20171201' create table tempWsGs1_001 ( id int, tax_id varchar(max) ) create table tempWsGs1_002 ( MEMBER_CODE varchar(max) , TAX_ID varchar(max) , BDB_CODE varchar(max) , MEMBER_MAIN_TYPE_CODE varchar(max) , MEMBER_MAIN_TYPE_NAME varchar(max) , MEMBER_TYPE_CODE varchar(max) , MEMBER_TYPE_NAME varchar(max) , BUSSINESS_TYPE_TH varchar(max) , BUSSINESS_TYPE_EN varchar(max) , PRENAME_TH varchar(max) , COMP_PERSON_NAME_TH varchar(max) , PRENAME_EN varchar(max) , COMP_PERSON_NAME_EN varchar(max) , ADDR_TH varchar(max) , ADDR_EN varchar(max) , ZIP_CODE_TH varchar(max) , ZIP_CODE_EN varchar(max) , TELEPHONE_TH varchar(max) , TELEPHONE_EN varchar(max) , EMAIL_TH varchar(max) , EMAIL_EN varchar(max) , STATUS varchar(max) , REGIST_DATE varchar(max) , MEMBER_DATE varchar(max) , UPDATE_DATE varchar(max) , CompanyPrefix varchar(max) ) insert into tempWsGs1_001 select distinct ROW_NUMBER() over (order by r.approve_date) as id, c.TAX_ID as tax_id from MB_MEMBER m,MB_COMP_PERSON c,MB_MEMBER_RETIRE r where r.REGIST_CODE=m.REGIST_CODE and m.MEMBER_MAIN_GROUP_CODE='300' and m.COMP_PERSON_CODE=c.COMP_PERSON_CODE AND (r.APPROVE_DATE BETWEEN dbo.fnc_StrToDateTime(@YYYYMMDD_FROM + '000000') AND dbo.fnc_StrToDateTime(@YYYYMMDD_TO + '235959')) declare @id int declare @totalRows int = (select count(*) from tempWsGs1_001) declare @currentRow int = 0 declare @BussinessTypeTH VARCHAR(max) declare @BussinessTypeEN VARCHAR(max) while @currentRow < @totalRows begin set @id = @currentRow+1 declare @TAX_ID varchar(max) set @TAX_ID = (select top 1 tax_id from tempWsGs1_001 where id=@id) insert into tempWsGs1_002 select * from fnc_GetGS1MemberInfoForWebServiceByTaxID(@TAX_ID) set @currentRow = @currentRow +1 end drop table tempWsGs1_001 select * from tempWsGs1_002 drop table tempWsGs1_002 8:00:48 16 กุมภาพันธ์ 2561 :There is already an object named 'tempWsGs1_001' in the database. 8:45:05 16 กุมภาพันธ์ 2561 :Index was out of range. Must be non-negative and less than the size of the collection. Parameter name: index 8:45:05 16 กุมภาพันธ์ 2561 :try to logon with: GS1WS 8:49:13 16 กุมภาพันธ์ 2561 :Index was out of range. Must be non-negative and less than the size of the collection. Parameter name: index 8:49:13 16 กุมภาพันธ์ 2561 :try to logon with: GS1WS 8:55:31 16 กุมภาพันธ์ 2561 :Index was out of range. Must be non-negative and less than the size of the collection. Parameter name: index 8:55:31 16 กุมภาพันธ์ 2561 :try to logon with: GS1WS 9:00:49 16 กุมภาพันธ์ 2561 :Index was out of range. Must be non-negative and less than the size of the collection. Parameter name: index 9:00:49 16 กุมภาพันธ์ 2561 :try to logon with: GS1WS 9:00:49 16 กุมภาพันธ์ 2561 :getGS1changed=/*SELECT MB_MEMBER.MEMBER_CODE, MB_PRENAME.PRENAME_TH, MB_COMP_PERSON.COMP_PERSON_NAME_TH, MB_PRENAME.PRENAME_EN, MB_COMP_PERSON.COMP_PERSON_NAME_EN, MB_COMP_PERSON.TAX_ID, MB_MEMBER.REGIST_DATE, MB_MEMBER.MEMBER_MAIN_TYPE_CODE, MB_MEMBER.MEMBER_TYPE_CODE, MB_MEMBER.MEMBER_STATUS_CODE, MB_MEMBER_RETIRE.APPROVE_DATE FROM MB_MEMBER INNER JOIN MB_COMP_PERSON ON MB_MEMBER.COMP_PERSON_CODE = MB_COMP_PERSON.COMP_PERSON_CODE INNER JOIN MB_MEMBER_RETIRE ON MB_MEMBER.REGIST_CODE = MB_MEMBER_RETIRE.REGIST_CODE LEFT OUTER JOIN MB_PRENAME ON MB_COMP_PERSON.PREN_CODE = MB_PRENAME.PRENAME_CODE WHERE (MB_MEMBER.MEMBER_MAIN_GROUP_CODE = '300') AND (MB_MEMBER_RETIRE.APPROVE_DATE BETWEEN dbo.fnc_StrToDateTime(@YYYYMMDD_FROM + '000000') AND dbo.fnc_StrToDateTime(@YYYYMMDD_TO + '235959')) ORDER BY MB_MEMBER_RETIRE.APPROVE_DATE*/ --declare @YYYYMMDD_FROM varchar(max) = '20171101' --declare @YYYYMMDD_TO varchar(max) = '20171201' create table tempWsGs1_001 ( id int, tax_id varchar(max) ) create table tempWsGs1_002 ( MEMBER_CODE varchar(max) , TAX_ID varchar(max) , BDB_CODE varchar(max) , MEMBER_MAIN_TYPE_CODE varchar(max) , MEMBER_MAIN_TYPE_NAME varchar(max) , MEMBER_TYPE_CODE varchar(max) , MEMBER_TYPE_NAME varchar(max) , BUSSINESS_TYPE_TH varchar(max) , BUSSINESS_TYPE_EN varchar(max) , PRENAME_TH varchar(max) , COMP_PERSON_NAME_TH varchar(max) , PRENAME_EN varchar(max) , COMP_PERSON_NAME_EN varchar(max) , ADDR_TH varchar(max) , ADDR_EN varchar(max) , ZIP_CODE_TH varchar(max) , ZIP_CODE_EN varchar(max) , TELEPHONE_TH varchar(max) , TELEPHONE_EN varchar(max) , EMAIL_TH varchar(max) , EMAIL_EN varchar(max) , STATUS varchar(max) , REGIST_DATE varchar(max) , MEMBER_DATE varchar(max) , UPDATE_DATE varchar(max) , CompanyPrefix varchar(max) ) insert into tempWsGs1_001 select distinct ROW_NUMBER() over (order by r.approve_date) as id, c.TAX_ID as tax_id from MB_MEMBER m,MB_COMP_PERSON c,MB_MEMBER_RETIRE r where r.REGIST_CODE=m.REGIST_CODE and m.MEMBER_MAIN_GROUP_CODE='300' and m.COMP_PERSON_CODE=c.COMP_PERSON_CODE AND (r.APPROVE_DATE BETWEEN dbo.fnc_StrToDateTime(@YYYYMMDD_FROM + '000000') AND dbo.fnc_StrToDateTime(@YYYYMMDD_TO + '235959')) declare @id int declare @totalRows int = (select count(*) from tempWsGs1_001) declare @currentRow int = 0 declare @BussinessTypeTH VARCHAR(max) declare @BussinessTypeEN VARCHAR(max) while @currentRow < @totalRows begin set @id = @currentRow+1 declare @TAX_ID varchar(max) set @TAX_ID = (select top 1 tax_id from tempWsGs1_001 where id=@id) insert into tempWsGs1_002 select * from fnc_GetGS1MemberInfoForWebServiceByTaxID(@TAX_ID) set @currentRow = @currentRow +1 end drop table tempWsGs1_001 select * from tempWsGs1_002 drop table tempWsGs1_002 9:00:49 16 กุมภาพันธ์ 2561 :There is already an object named 'tempWsGs1_001' in the database. 9:03:27 16 กุมภาพันธ์ 2561 :Index was out of range. Must be non-negative and less than the size of the collection. Parameter name: index 9:03:27 16 กุมภาพันธ์ 2561 :try to logon with: GS1WS 9:06:15 16 กุมภาพันธ์ 2561 :Index was out of range. Must be non-negative and less than the size of the collection. Parameter name: index 9:06:15 16 กุมภาพันธ์ 2561 :try to logon with: GS1WS 9:10:51 16 กุมภาพันธ์ 2561 :Index was out of range. Must be non-negative and less than the size of the collection. Parameter name: index 9:10:51 16 กุมภาพันธ์ 2561 :try to logon with: GS1WS 9:14:07 16 กุมภาพันธ์ 2561 :Index was out of range. Must be non-negative and less than the size of the collection. Parameter name: index 9:14:07 16 กุมภาพันธ์ 2561 :try to logon with: GS1WS 9:19:01 16 กุมภาพันธ์ 2561 :Index was out of range. Must be non-negative and less than the size of the collection. Parameter name: index 9:19:01 16 กุมภาพันธ์ 2561 :try to logon with: GS1WS 9:23:54 16 กุมภาพันธ์ 2561 :Index was out of range. Must be non-negative and less than the size of the collection. Parameter name: index 9:23:54 16 กุมภาพันธ์ 2561 :try to logon with: GS1WS 9:26:31 16 กุมภาพันธ์ 2561 :Index was out of range. Must be non-negative and less than the size of the collection. Parameter name: index 9:26:31 16 กุมภาพันธ์ 2561 :try to logon with: GS1WS 9:29:20 16 กุมภาพันธ์ 2561 :Index was out of range. Must be non-negative and less than the size of the collection. Parameter name: index 9:29:20 16 กุมภาพันธ์ 2561 :try to logon with: GS1WS 9:32:10 16 กุมภาพันธ์ 2561 :Index was out of range. Must be non-negative and less than the size of the collection. Parameter name: index 9:32:10 16 กุมภาพันธ์ 2561 :try to logon with: GS1WS 9:32:31 16 กุมภาพันธ์ 2561 :Index was out of range. Must be non-negative and less than the size of the collection. Parameter name: index 9:32:31 16 กุมภาพันธ์ 2561 :try to logon with: GS1WS 9:35:40 16 กุมภาพันธ์ 2561 :Index was out of range. Must be non-negative and less than the size of the collection. Parameter name: index 9:35:40 16 กุมภาพันธ์ 2561 :try to logon with: GS1WS 9:38:27 16 กุมภาพันธ์ 2561 :Index was out of range. Must be non-negative and less than the size of the collection. Parameter name: index 9:38:27 16 กุมภาพันธ์ 2561 :try to logon with: GS1WS 9:41:52 16 กุมภาพันธ์ 2561 :Index was out of range. Must be non-negative and less than the size of the collection. Parameter name: index 9:41:52 16 กุมภาพันธ์ 2561 :try to logon with: GS1WS 9:44:39 16 กุมภาพันธ์ 2561 :Index was out of range. Must be non-negative and less than the size of the collection. Parameter name: index 9:44:39 16 กุมภาพันธ์ 2561 :try to logon with: GS1WS 9:44:45 16 กุมภาพันธ์ 2561 :Index was out of range. Must be non-negative and less than the size of the collection. Parameter name: index 9:44:45 16 กุมภาพันธ์ 2561 :try to logon with: GS1WS 9:46:30 16 กุมภาพันธ์ 2561 :Index was out of range. Must be non-negative and less than the size of the collection. Parameter name: index 9:46:30 16 กุมภาพันธ์ 2561 :try to logon with: GS1WS 9:47:14 16 กุมภาพันธ์ 2561 :Index was out of range. Must be non-negative and less than the size of the collection. Parameter name: index 9:47:14 16 กุมภาพันธ์ 2561 :try to logon with: GS1WS 9:50:23 16 กุมภาพันธ์ 2561 :Index was out of range. Must be non-negative and less than the size of the collection. Parameter name: index 9:50:23 16 กุมภาพันธ์ 2561 :try to logon with: GS1WS 9:53:29 16 กุมภาพันธ์ 2561 :Index was out of range. Must be non-negative and less than the size of the collection. Parameter name: index 9:53:29 16 กุมภาพันธ์ 2561 :try to logon with: GS1WS 9:57:13 16 กุมภาพันธ์ 2561 :Index was out of range. Must be non-negative and less than the size of the collection. Parameter name: index 9:57:13 16 กุมภาพันธ์ 2561 :try to logon with: GS1WS 10:00:48 16 กุมภาพันธ์ 2561 :Index was out of range. Must be non-negative and less than the size of the collection. Parameter name: index 10:00:48 16 กุมภาพันธ์ 2561 :try to logon with: GS1WS 10:00:48 16 กุมภาพันธ์ 2561 :getGS1changed=/*SELECT MB_MEMBER.MEMBER_CODE, MB_PRENAME.PRENAME_TH, MB_COMP_PERSON.COMP_PERSON_NAME_TH, MB_PRENAME.PRENAME_EN, MB_COMP_PERSON.COMP_PERSON_NAME_EN, MB_COMP_PERSON.TAX_ID, MB_MEMBER.REGIST_DATE, MB_MEMBER.MEMBER_MAIN_TYPE_CODE, MB_MEMBER.MEMBER_TYPE_CODE, MB_MEMBER.MEMBER_STATUS_CODE, MB_MEMBER_RETIRE.APPROVE_DATE FROM MB_MEMBER INNER JOIN MB_COMP_PERSON ON MB_MEMBER.COMP_PERSON_CODE = MB_COMP_PERSON.COMP_PERSON_CODE INNER JOIN MB_MEMBER_RETIRE ON MB_MEMBER.REGIST_CODE = MB_MEMBER_RETIRE.REGIST_CODE LEFT OUTER JOIN MB_PRENAME ON MB_COMP_PERSON.PREN_CODE = MB_PRENAME.PRENAME_CODE WHERE (MB_MEMBER.MEMBER_MAIN_GROUP_CODE = '300') AND (MB_MEMBER_RETIRE.APPROVE_DATE BETWEEN dbo.fnc_StrToDateTime(@YYYYMMDD_FROM + '000000') AND dbo.fnc_StrToDateTime(@YYYYMMDD_TO + '235959')) ORDER BY MB_MEMBER_RETIRE.APPROVE_DATE*/ --declare @YYYYMMDD_FROM varchar(max) = '20171101' --declare @YYYYMMDD_TO varchar(max) = '20171201' create table tempWsGs1_001 ( id int, tax_id varchar(max) ) create table tempWsGs1_002 ( MEMBER_CODE varchar(max) , TAX_ID varchar(max) , BDB_CODE varchar(max) , MEMBER_MAIN_TYPE_CODE varchar(max) , MEMBER_MAIN_TYPE_NAME varchar(max) , MEMBER_TYPE_CODE varchar(max) , MEMBER_TYPE_NAME varchar(max) , BUSSINESS_TYPE_TH varchar(max) , BUSSINESS_TYPE_EN varchar(max) , PRENAME_TH varchar(max) , COMP_PERSON_NAME_TH varchar(max) , PRENAME_EN varchar(max) , COMP_PERSON_NAME_EN varchar(max) , ADDR_TH varchar(max) , ADDR_EN varchar(max) , ZIP_CODE_TH varchar(max) , ZIP_CODE_EN varchar(max) , TELEPHONE_TH varchar(max) , TELEPHONE_EN varchar(max) , EMAIL_TH varchar(max) , EMAIL_EN varchar(max) , STATUS varchar(max) , REGIST_DATE varchar(max) , MEMBER_DATE varchar(max) , UPDATE_DATE varchar(max) , CompanyPrefix varchar(max) ) insert into tempWsGs1_001 select distinct ROW_NUMBER() over (order by r.approve_date) as id, c.TAX_ID as tax_id from MB_MEMBER m,MB_COMP_PERSON c,MB_MEMBER_RETIRE r where r.REGIST_CODE=m.REGIST_CODE and m.MEMBER_MAIN_GROUP_CODE='300' and m.COMP_PERSON_CODE=c.COMP_PERSON_CODE AND (r.APPROVE_DATE BETWEEN dbo.fnc_StrToDateTime(@YYYYMMDD_FROM + '000000') AND dbo.fnc_StrToDateTime(@YYYYMMDD_TO + '235959')) declare @id int declare @totalRows int = (select count(*) from tempWsGs1_001) declare @currentRow int = 0 declare @BussinessTypeTH VARCHAR(max) declare @BussinessTypeEN VARCHAR(max) while @currentRow < @totalRows begin set @id = @currentRow+1 declare @TAX_ID varchar(max) set @TAX_ID = (select top 1 tax_id from tempWsGs1_001 where id=@id) insert into tempWsGs1_002 select * from fnc_GetGS1MemberInfoForWebServiceByTaxID(@TAX_ID) set @currentRow = @currentRow +1 end drop table tempWsGs1_001 select * from tempWsGs1_002 drop table tempWsGs1_002 10:00:48 16 กุมภาพันธ์ 2561 :There is already an object named 'tempWsGs1_001' in the database. 10:01:38 16 กุมภาพันธ์ 2561 :Index was out of range. Must be non-negative and less than the size of the collection. Parameter name: index 10:01:38 16 กุมภาพันธ์ 2561 :try to logon with: GS1WS 10:05:03 16 กุมภาพันธ์ 2561 :Index was out of range. Must be non-negative and less than the size of the collection. Parameter name: index 10:05:03 16 กุมภาพันธ์ 2561 :try to logon with: GS1WS 10:06:41 16 กุมภาพันธ์ 2561 :Index was out of range. Must be non-negative and less than the size of the collection. Parameter name: index 10:06:41 16 กุมภาพันธ์ 2561 :try to logon with: GS1WS 10:08:56 16 กุมภาพันธ์ 2561 :Index was out of range. Must be non-negative and less than the size of the collection. Parameter name: index 10:08:56 16 กุมภาพันธ์ 2561 :try to logon with: GS1WS 10:10:58 16 กุมภาพันธ์ 2561 :Index was out of range. Must be non-negative and less than the size of the collection. Parameter name: index 10:10:58 16 กุมภาพันธ์ 2561 :try to logon with: GS1WS 10:11:47 16 กุมภาพันธ์ 2561 :Index was out of range. Must be non-negative and less than the size of the collection. Parameter name: index 10:11:47 16 กุมภาพันธ์ 2561 :try to logon with: GS1WS 10:14:35 16 กุมภาพันธ์ 2561 :Index was out of range. Must be non-negative and less than the size of the collection. Parameter name: index 10:14:35 16 กุมภาพันธ์ 2561 :try to logon with: GS1WS 10:15:22 16 กุมภาพันธ์ 2561 :Index was out of range. Must be non-negative and less than the size of the collection. Parameter name: index 10:15:22 16 กุมภาพันธ์ 2561 :try to logon with: GS1WS 10:18:28 16 กุมภาพันธ์ 2561 :Index was out of range. Must be non-negative and less than the size of the collection. Parameter name: index 10:18:28 16 กุมภาพันธ์ 2561 :try to logon with: GS1WS 10:21:35 16 กุมภาพันธ์ 2561 :Index was out of range. Must be non-negative and less than the size of the collection. Parameter name: index 10:21:35 16 กุมภาพันธ์ 2561 :try to logon with: GS1WS 10:29:37 16 กุมภาพันธ์ 2561 :Index was out of range. Must be non-negative and less than the size of the collection. Parameter name: index 10:29:37 16 กุมภาพันธ์ 2561 :try to logon with: GS1WS 10:33:53 16 กุมภาพันธ์ 2561 :Index was out of range. Must be non-negative and less than the size of the collection. Parameter name: index 10:33:53 16 กุมภาพันธ์ 2561 :try to logon with: GS1WS 10:36:23 16 กุมภาพันธ์ 2561 :Index was out of range. Must be non-negative and less than the size of the collection. Parameter name: index 10:36:23 16 กุมภาพันธ์ 2561 :try to logon with: GS1WS 10:37:25 16 กุมภาพันธ์ 2561 :Index was out of range. Must be non-negative and less than the size of the collection. Parameter name: index 10:37:25 16 กุมภาพันธ์ 2561 :try to logon with: GS1WS 10:37:55 16 กุมภาพันธ์ 2561 :Index was out of range. Must be non-negative and less than the size of the collection. Parameter name: index 10:37:55 16 กุมภาพันธ์ 2561 :try to logon with: GS1WS 10:38:37 16 กุมภาพันธ์ 2561 :Index was out of range. Must be non-negative and less than the size of the collection. Parameter name: index 10:38:37 16 กุมภาพันธ์ 2561 :try to logon with: GS1WS 10:42:29 16 กุมภาพันธ์ 2561 :Index was out of range. Must be non-negative and less than the size of the collection. Parameter name: index 10:42:29 16 กุมภาพันธ์ 2561 :try to logon with: GS1WS 10:46:08 16 กุมภาพันธ์ 2561 :Index was out of range. Must be non-negative and less than the size of the collection. Parameter name: index 10:46:08 16 กุมภาพันธ์ 2561 :try to logon with: GS1WS 10:50:26 16 กุมภาพันธ์ 2561 :Index was out of range. Must be non-negative and less than the size of the collection. Parameter name: index 10:50:26 16 กุมภาพันธ์ 2561 :try to logon with: GS1WS 10:52:57 16 กุมภาพันธ์ 2561 :There was no endpoint listening at https://rdws.rd.go.th/serviceRD3/vatserviceRD3.asmx that could accept the message. This is often caused by an incorrect address or SOAP action. See InnerException, if present, for more details. 10:56:28 16 กุมภาพันธ์ 2561 :Index was out of range. Must be non-negative and less than the size of the collection. Parameter name: index 10:56:28 16 กุมภาพันธ์ 2561 :try to logon with: GS1WS 10:58:23 16 กุมภาพันธ์ 2561 :Index was out of range. Must be non-negative and less than the size of the collection. Parameter name: index 10:58:23 16 กุมภาพันธ์ 2561 :try to logon with: GS1WS 11:00:51 16 กุมภาพันธ์ 2561 :Index was out of range. Must be non-negative and less than the size of the collection. Parameter name: index 11:00:51 16 กุมภาพันธ์ 2561 :try to logon with: GS1WS 11:00:51 16 กุมภาพันธ์ 2561 :getGS1changed=/*SELECT MB_MEMBER.MEMBER_CODE, MB_PRENAME.PRENAME_TH, MB_COMP_PERSON.COMP_PERSON_NAME_TH, MB_PRENAME.PRENAME_EN, MB_COMP_PERSON.COMP_PERSON_NAME_EN, MB_COMP_PERSON.TAX_ID, MB_MEMBER.REGIST_DATE, MB_MEMBER.MEMBER_MAIN_TYPE_CODE, MB_MEMBER.MEMBER_TYPE_CODE, MB_MEMBER.MEMBER_STATUS_CODE, MB_MEMBER_RETIRE.APPROVE_DATE FROM MB_MEMBER INNER JOIN MB_COMP_PERSON ON MB_MEMBER.COMP_PERSON_CODE = MB_COMP_PERSON.COMP_PERSON_CODE INNER JOIN MB_MEMBER_RETIRE ON MB_MEMBER.REGIST_CODE = MB_MEMBER_RETIRE.REGIST_CODE LEFT OUTER JOIN MB_PRENAME ON MB_COMP_PERSON.PREN_CODE = MB_PRENAME.PRENAME_CODE WHERE (MB_MEMBER.MEMBER_MAIN_GROUP_CODE = '300') AND (MB_MEMBER_RETIRE.APPROVE_DATE BETWEEN dbo.fnc_StrToDateTime(@YYYYMMDD_FROM + '000000') AND dbo.fnc_StrToDateTime(@YYYYMMDD_TO + '235959')) ORDER BY MB_MEMBER_RETIRE.APPROVE_DATE*/ --declare @YYYYMMDD_FROM varchar(max) = '20171101' --declare @YYYYMMDD_TO varchar(max) = '20171201' create table tempWsGs1_001 ( id int, tax_id varchar(max) ) create table tempWsGs1_002 ( MEMBER_CODE varchar(max) , TAX_ID varchar(max) , BDB_CODE varchar(max) , MEMBER_MAIN_TYPE_CODE varchar(max) , MEMBER_MAIN_TYPE_NAME varchar(max) , MEMBER_TYPE_CODE varchar(max) , MEMBER_TYPE_NAME varchar(max) , BUSSINESS_TYPE_TH varchar(max) , BUSSINESS_TYPE_EN varchar(max) , PRENAME_TH varchar(max) , COMP_PERSON_NAME_TH varchar(max) , PRENAME_EN varchar(max) , COMP_PERSON_NAME_EN varchar(max) , ADDR_TH varchar(max) , ADDR_EN varchar(max) , ZIP_CODE_TH varchar(max) , ZIP_CODE_EN varchar(max) , TELEPHONE_TH varchar(max) , TELEPHONE_EN varchar(max) , EMAIL_TH varchar(max) , EMAIL_EN varchar(max) , STATUS varchar(max) , REGIST_DATE varchar(max) , MEMBER_DATE varchar(max) , UPDATE_DATE varchar(max) , CompanyPrefix varchar(max) ) insert into tempWsGs1_001 select distinct ROW_NUMBER() over (order by r.approve_date) as id, c.TAX_ID as tax_id from MB_MEMBER m,MB_COMP_PERSON c,MB_MEMBER_RETIRE r where r.REGIST_CODE=m.REGIST_CODE and m.MEMBER_MAIN_GROUP_CODE='300' and m.COMP_PERSON_CODE=c.COMP_PERSON_CODE AND (r.APPROVE_DATE BETWEEN dbo.fnc_StrToDateTime(@YYYYMMDD_FROM + '000000') AND dbo.fnc_StrToDateTime(@YYYYMMDD_TO + '235959')) declare @id int declare @totalRows int = (select count(*) from tempWsGs1_001) declare @currentRow int = 0 declare @BussinessTypeTH VARCHAR(max) declare @BussinessTypeEN VARCHAR(max) while @currentRow < @totalRows begin set @id = @currentRow+1 declare @TAX_ID varchar(max) set @TAX_ID = (select top 1 tax_id from tempWsGs1_001 where id=@id) insert into tempWsGs1_002 select * from fnc_GetGS1MemberInfoForWebServiceByTaxID(@TAX_ID) set @currentRow = @currentRow +1 end drop table tempWsGs1_001 select * from tempWsGs1_002 drop table tempWsGs1_002 11:00:51 16 กุมภาพันธ์ 2561 :There is already an object named 'tempWsGs1_001' in the database. 11:00:52 16 กุมภาพันธ์ 2561 :Index was out of range. Must be non-negative and less than the size of the collection. Parameter name: index 11:00:52 16 กุมภาพันธ์ 2561 :try to logon with: GS1WS 11:00:52 16 กุมภาพันธ์ 2561 :getGS1changed=/*SELECT MB_MEMBER.MEMBER_CODE, MB_PRENAME.PRENAME_TH, MB_COMP_PERSON.COMP_PERSON_NAME_TH, MB_PRENAME.PRENAME_EN, MB_COMP_PERSON.COMP_PERSON_NAME_EN, MB_COMP_PERSON.TAX_ID, MB_MEMBER.REGIST_DATE, MB_MEMBER.MEMBER_MAIN_TYPE_CODE, MB_MEMBER.MEMBER_TYPE_CODE, MB_MEMBER.MEMBER_STATUS_CODE, MB_MEMBER_RETIRE.APPROVE_DATE FROM MB_MEMBER INNER JOIN MB_COMP_PERSON ON MB_MEMBER.COMP_PERSON_CODE = MB_COMP_PERSON.COMP_PERSON_CODE INNER JOIN MB_MEMBER_RETIRE ON MB_MEMBER.REGIST_CODE = MB_MEMBER_RETIRE.REGIST_CODE LEFT OUTER JOIN MB_PRENAME ON MB_COMP_PERSON.PREN_CODE = MB_PRENAME.PRENAME_CODE WHERE (MB_MEMBER.MEMBER_MAIN_GROUP_CODE = '300') AND (MB_MEMBER_RETIRE.APPROVE_DATE BETWEEN dbo.fnc_StrToDateTime(@YYYYMMDD_FROM + '000000') AND dbo.fnc_StrToDateTime(@YYYYMMDD_TO + '235959')) ORDER BY MB_MEMBER_RETIRE.APPROVE_DATE*/ --declare @YYYYMMDD_FROM varchar(max) = '20171101' --declare @YYYYMMDD_TO varchar(max) = '20171201' create table tempWsGs1_001 ( id int, tax_id varchar(max) ) create table tempWsGs1_002 ( MEMBER_CODE varchar(max) , TAX_ID varchar(max) , BDB_CODE varchar(max) , MEMBER_MAIN_TYPE_CODE varchar(max) , MEMBER_MAIN_TYPE_NAME varchar(max) , MEMBER_TYPE_CODE varchar(max) , MEMBER_TYPE_NAME varchar(max) , BUSSINESS_TYPE_TH varchar(max) , BUSSINESS_TYPE_EN varchar(max) , PRENAME_TH varchar(max) , COMP_PERSON_NAME_TH varchar(max) , PRENAME_EN varchar(max) , COMP_PERSON_NAME_EN varchar(max) , ADDR_TH varchar(max) , ADDR_EN varchar(max) , ZIP_CODE_TH varchar(max) , ZIP_CODE_EN varchar(max) , TELEPHONE_TH varchar(max) , TELEPHONE_EN varchar(max) , EMAIL_TH varchar(max) , EMAIL_EN varchar(max) , STATUS varchar(max) , REGIST_DATE varchar(max) , MEMBER_DATE varchar(max) , UPDATE_DATE varchar(max) , CompanyPrefix varchar(max) ) insert into tempWsGs1_001 select distinct ROW_NUMBER() over (order by r.approve_date) as id, c.TAX_ID as tax_id from MB_MEMBER m,MB_COMP_PERSON c,MB_MEMBER_RETIRE r where r.REGIST_CODE=m.REGIST_CODE and m.MEMBER_MAIN_GROUP_CODE='300' and m.COMP_PERSON_CODE=c.COMP_PERSON_CODE AND (r.APPROVE_DATE BETWEEN dbo.fnc_StrToDateTime(@YYYYMMDD_FROM + '000000') AND dbo.fnc_StrToDateTime(@YYYYMMDD_TO + '235959')) declare @id int declare @totalRows int = (select count(*) from tempWsGs1_001) declare @currentRow int = 0 declare @BussinessTypeTH VARCHAR(max) declare @BussinessTypeEN VARCHAR(max) while @currentRow < @totalRows begin set @id = @currentRow+1 declare @TAX_ID varchar(max) set @TAX_ID = (select top 1 tax_id from tempWsGs1_001 where id=@id) insert into tempWsGs1_002 select * from fnc_GetGS1MemberInfoForWebServiceByTaxID(@TAX_ID) set @currentRow = @currentRow +1 end drop table tempWsGs1_001 select * from tempWsGs1_002 drop table tempWsGs1_002 11:00:52 16 กุมภาพันธ์ 2561 :There is already an object named 'tempWsGs1_001' in the database. 11:02:02 16 กุมภาพันธ์ 2561 :Index was out of range. Must be non-negative and less than the size of the collection. Parameter name: index 11:02:02 16 กุมภาพันธ์ 2561 :try to logon with: GS1WS 11:02:11 16 กุมภาพันธ์ 2561 :Index was out of range. Must be non-negative and less than the size of the collection. Parameter name: index 11:02:11 16 กุมภาพันธ์ 2561 :try to logon with: GS1WS 11:05:29 16 กุมภาพันธ์ 2561 :Index was out of range. Must be non-negative and less than the size of the collection. Parameter name: index 11:05:29 16 กุมภาพันธ์ 2561 :try to logon with: GS1WS 11:09:01 16 กุมภาพันธ์ 2561 :Index was out of range. Must be non-negative and less than the size of the collection. Parameter name: index 11:09:01 16 กุมภาพันธ์ 2561 :try to logon with: GS1WS 11:10:05 16 กุมภาพันธ์ 2561 :Index was out of range. Must be non-negative and less than the size of the collection. Parameter name: index 11:10:05 16 กุมภาพันธ์ 2561 :try to logon with: GS1WS 11:12:50 16 กุมภาพันธ์ 2561 :Index was out of range. Must be non-negative and less than the size of the collection. Parameter name: index 11:12:50 16 กุมภาพันธ์ 2561 :try to logon with: GS1WS 11:19:34 16 กุมภาพันธ์ 2561 :Index was out of range. Must be non-negative and less than the size of the collection. Parameter name: index 11:19:34 16 กุมภาพันธ์ 2561 :try to logon with: GS1WS 11:20:09 16 กุมภาพันธ์ 2561 :Index was out of range. Must be non-negative and less than the size of the collection. Parameter name: index 11:20:09 16 กุมภาพันธ์ 2561 :try to logon with: GS1WS 11:25:03 16 กุมภาพันธ์ 2561 :Index was out of range. Must be non-negative and less than the size of the collection. Parameter name: index 11:25:03 16 กุมภาพันธ์ 2561 :try to logon with: GS1WS 11:28:10 16 กุมภาพันธ์ 2561 :Index was out of range. Must be non-negative and less than the size of the collection. Parameter name: index 11:28:10 16 กุมภาพันธ์ 2561 :try to logon with: GS1WS 11:28:46 16 กุมภาพันธ์ 2561 :Index was out of range. Must be non-negative and less than the size of the collection. Parameter name: index 11:28:46 16 กุมภาพันธ์ 2561 :try to logon with: GS1WS 11:33:44 16 กุมภาพันธ์ 2561 :Index was out of range. Must be non-negative and less than the size of the collection. Parameter name: index 11:33:44 16 กุมภาพันธ์ 2561 :try to logon with: GS1WS 11:37:05 16 กุมภาพันธ์ 2561 :Index was out of range. Must be non-negative and less than the size of the collection. Parameter name: index 11:37:05 16 กุมภาพันธ์ 2561 :try to logon with: GS1WS 11:37:23 16 กุมภาพันธ์ 2561 :Index was out of range. Must be non-negative and less than the size of the collection. Parameter name: index 11:37:23 16 กุมภาพันธ์ 2561 :try to logon with: GS1WS 11:39:45 16 กุมภาพันธ์ 2561 :Index was out of range. Must be non-negative and less than the size of the collection. Parameter name: index 11:39:45 16 กุมภาพันธ์ 2561 :try to logon with: GS1WS 11:40:24 16 กุมภาพันธ์ 2561 :Index was out of range. Must be non-negative and less than the size of the collection. Parameter name: index 11:40:24 16 กุมภาพันธ์ 2561 :try to logon with: GS1WS 11:40:40 16 กุมภาพันธ์ 2561 :Index was out of range. Must be non-negative and less than the size of the collection. Parameter name: index 11:40:40 16 กุมภาพันธ์ 2561 :try to logon with: GS1WS 11:41:54 16 กุมภาพันธ์ 2561 :Index was out of range. Must be non-negative and less than the size of the collection. Parameter name: index 11:41:54 16 กุมภาพันธ์ 2561 :try to logon with: GS1WS 11:44:12 16 กุมภาพันธ์ 2561 :Index was out of range. Must be non-negative and less than the size of the collection. Parameter name: index 11:44:12 16 กุมภาพันธ์ 2561 :try to logon with: GS1WS 11:45:07 16 กุมภาพันธ์ 2561 :Index was out of range. Must be non-negative and less than the size of the collection. Parameter name: index 11:45:07 16 กุมภาพันธ์ 2561 :try to logon with: GS1WS 11:45:27 16 กุมภาพันธ์ 2561 :Index was out of range. Must be non-negative and less than the size of the collection. Parameter name: index 11:45:27 16 กุมภาพันธ์ 2561 :try to logon with: GS1WS 11:46:51 16 กุมภาพันธ์ 2561 :Index was out of range. Must be non-negative and less than the size of the collection. Parameter name: index 11:46:51 16 กุมภาพันธ์ 2561 :try to logon with: GS1WS 11:47:08 16 กุมภาพันธ์ 2561 :Index was out of range. Must be non-negative and less than the size of the collection. Parameter name: index 11:47:08 16 กุมภาพันธ์ 2561 :try to logon with: GS1WS 11:48:01 16 กุมภาพันธ์ 2561 :Index was out of range. Must be non-negative and less than the size of the collection. Parameter name: index 11:48:01 16 กุมภาพันธ์ 2561 :try to logon with: GS1WS 11:49:46 16 กุมภาพันธ์ 2561 :Index was out of range. Must be non-negative and less than the size of the collection. Parameter name: index 11:49:46 16 กุมภาพันธ์ 2561 :try to logon with: GS1WS 11:51:22 16 กุมภาพันธ์ 2561 :Index was out of range. Must be non-negative and less than the size of the collection. Parameter name: index 11:51:22 16 กุมภาพันธ์ 2561 :try to logon with: GS1WS 11:52:42 16 กุมภาพันธ์ 2561 :Index was out of range. Must be non-negative and less than the size of the collection. Parameter name: index 11:52:42 16 กุมภาพันธ์ 2561 :try to logon with: GS1WS 11:57:50 16 กุมภาพันธ์ 2561 :Index was out of range. Must be non-negative and less than the size of the collection. Parameter name: index 11:57:50 16 กุมภาพันธ์ 2561 :try to logon with: GS1WS 11:59:04 16 กุมภาพันธ์ 2561 :Index was out of range. Must be non-negative and less than the size of the collection. Parameter name: index 11:59:04 16 กุมภาพันธ์ 2561 :try to logon with: GS1WS 12:00:48 16 กุมภาพันธ์ 2561 :Index was out of range. Must be non-negative and less than the size of the collection. Parameter name: index 12:00:48 16 กุมภาพันธ์ 2561 :try to logon with: GS1WS 12:00:48 16 กุมภาพันธ์ 2561 :getGS1changed=/*SELECT MB_MEMBER.MEMBER_CODE, MB_PRENAME.PRENAME_TH, MB_COMP_PERSON.COMP_PERSON_NAME_TH, MB_PRENAME.PRENAME_EN, MB_COMP_PERSON.COMP_PERSON_NAME_EN, MB_COMP_PERSON.TAX_ID, MB_MEMBER.REGIST_DATE, MB_MEMBER.MEMBER_MAIN_TYPE_CODE, MB_MEMBER.MEMBER_TYPE_CODE, MB_MEMBER.MEMBER_STATUS_CODE, MB_MEMBER_RETIRE.APPROVE_DATE FROM MB_MEMBER INNER JOIN MB_COMP_PERSON ON MB_MEMBER.COMP_PERSON_CODE = MB_COMP_PERSON.COMP_PERSON_CODE INNER JOIN MB_MEMBER_RETIRE ON MB_MEMBER.REGIST_CODE = MB_MEMBER_RETIRE.REGIST_CODE LEFT OUTER JOIN MB_PRENAME ON MB_COMP_PERSON.PREN_CODE = MB_PRENAME.PRENAME_CODE WHERE (MB_MEMBER.MEMBER_MAIN_GROUP_CODE = '300') AND (MB_MEMBER_RETIRE.APPROVE_DATE BETWEEN dbo.fnc_StrToDateTime(@YYYYMMDD_FROM + '000000') AND dbo.fnc_StrToDateTime(@YYYYMMDD_TO + '235959')) ORDER BY MB_MEMBER_RETIRE.APPROVE_DATE*/ --declare @YYYYMMDD_FROM varchar(max) = '20171101' --declare @YYYYMMDD_TO varchar(max) = '20171201' create table tempWsGs1_001 ( id int, tax_id varchar(max) ) create table tempWsGs1_002 ( MEMBER_CODE varchar(max) , TAX_ID varchar(max) , BDB_CODE varchar(max) , MEMBER_MAIN_TYPE_CODE varchar(max) , MEMBER_MAIN_TYPE_NAME varchar(max) , MEMBER_TYPE_CODE varchar(max) , MEMBER_TYPE_NAME varchar(max) , BUSSINESS_TYPE_TH varchar(max) , BUSSINESS_TYPE_EN varchar(max) , PRENAME_TH varchar(max) , COMP_PERSON_NAME_TH varchar(max) , PRENAME_EN varchar(max) , COMP_PERSON_NAME_EN varchar(max) , ADDR_TH varchar(max) , ADDR_EN varchar(max) , ZIP_CODE_TH varchar(max) , ZIP_CODE_EN varchar(max) , TELEPHONE_TH varchar(max) , TELEPHONE_EN varchar(max) , EMAIL_TH varchar(max) , EMAIL_EN varchar(max) , STATUS varchar(max) , REGIST_DATE varchar(max) , MEMBER_DATE varchar(max) , UPDATE_DATE varchar(max) , CompanyPrefix varchar(max) ) insert into tempWsGs1_001 select distinct ROW_NUMBER() over (order by r.approve_date) as id, c.TAX_ID as tax_id from MB_MEMBER m,MB_COMP_PERSON c,MB_MEMBER_RETIRE r where r.REGIST_CODE=m.REGIST_CODE and m.MEMBER_MAIN_GROUP_CODE='300' and m.COMP_PERSON_CODE=c.COMP_PERSON_CODE AND (r.APPROVE_DATE BETWEEN dbo.fnc_StrToDateTime(@YYYYMMDD_FROM + '000000') AND dbo.fnc_StrToDateTime(@YYYYMMDD_TO + '235959')) declare @id int declare @totalRows int = (select count(*) from tempWsGs1_001) declare @currentRow int = 0 declare @BussinessTypeTH VARCHAR(max) declare @BussinessTypeEN VARCHAR(max) while @currentRow < @totalRows begin set @id = @currentRow+1 declare @TAX_ID varchar(max) set @TAX_ID = (select top 1 tax_id from tempWsGs1_001 where id=@id) insert into tempWsGs1_002 select * from fnc_GetGS1MemberInfoForWebServiceByTaxID(@TAX_ID) set @currentRow = @currentRow +1 end drop table tempWsGs1_001 select * from tempWsGs1_002 drop table tempWsGs1_002 12:00:48 16 กุมภาพันธ์ 2561 :There is already an object named 'tempWsGs1_001' in the database. 12:00:48 16 กุมภาพันธ์ 2561 :Index was out of range. Must be non-negative and less than the size of the collection. Parameter name: index 12:00:48 16 กุมภาพันธ์ 2561 :try to logon with: GS1WS 12:00:48 16 กุมภาพันธ์ 2561 :getGS1changed=/*SELECT MB_MEMBER.MEMBER_CODE, MB_PRENAME.PRENAME_TH, MB_COMP_PERSON.COMP_PERSON_NAME_TH, MB_PRENAME.PRENAME_EN, MB_COMP_PERSON.COMP_PERSON_NAME_EN, MB_COMP_PERSON.TAX_ID, MB_MEMBER.REGIST_DATE, MB_MEMBER.MEMBER_MAIN_TYPE_CODE, MB_MEMBER.MEMBER_TYPE_CODE, MB_MEMBER.MEMBER_STATUS_CODE, MB_MEMBER_RETIRE.APPROVE_DATE FROM MB_MEMBER INNER JOIN MB_COMP_PERSON ON MB_MEMBER.COMP_PERSON_CODE = MB_COMP_PERSON.COMP_PERSON_CODE INNER JOIN MB_MEMBER_RETIRE ON MB_MEMBER.REGIST_CODE = MB_MEMBER_RETIRE.REGIST_CODE LEFT OUTER JOIN MB_PRENAME ON MB_COMP_PERSON.PREN_CODE = MB_PRENAME.PRENAME_CODE WHERE (MB_MEMBER.MEMBER_MAIN_GROUP_CODE = '300') AND (MB_MEMBER_RETIRE.APPROVE_DATE BETWEEN dbo.fnc_StrToDateTime(@YYYYMMDD_FROM + '000000') AND dbo.fnc_StrToDateTime(@YYYYMMDD_TO + '235959')) ORDER BY MB_MEMBER_RETIRE.APPROVE_DATE*/ --declare @YYYYMMDD_FROM varchar(max) = '20171101' --declare @YYYYMMDD_TO varchar(max) = '20171201' create table tempWsGs1_001 ( id int, tax_id varchar(max) ) create table tempWsGs1_002 ( MEMBER_CODE varchar(max) , TAX_ID varchar(max) , BDB_CODE varchar(max) , MEMBER_MAIN_TYPE_CODE varchar(max) , MEMBER_MAIN_TYPE_NAME varchar(max) , MEMBER_TYPE_CODE varchar(max) , MEMBER_TYPE_NAME varchar(max) , BUSSINESS_TYPE_TH varchar(max) , BUSSINESS_TYPE_EN varchar(max) , PRENAME_TH varchar(max) , COMP_PERSON_NAME_TH varchar(max) , PRENAME_EN varchar(max) , COMP_PERSON_NAME_EN varchar(max) , ADDR_TH varchar(max) , ADDR_EN varchar(max) , ZIP_CODE_TH varchar(max) , ZIP_CODE_EN varchar(max) , TELEPHONE_TH varchar(max) , TELEPHONE_EN varchar(max) , EMAIL_TH varchar(max) , EMAIL_EN varchar(max) , STATUS varchar(max) , REGIST_DATE varchar(max) , MEMBER_DATE varchar(max) , UPDATE_DATE varchar(max) , CompanyPrefix varchar(max) ) insert into tempWsGs1_001 select distinct ROW_NUMBER() over (order by r.approve_date) as id, c.TAX_ID as tax_id from MB_MEMBER m,MB_COMP_PERSON c,MB_MEMBER_RETIRE r where r.REGIST_CODE=m.REGIST_CODE and m.MEMBER_MAIN_GROUP_CODE='300' and m.COMP_PERSON_CODE=c.COMP_PERSON_CODE AND (r.APPROVE_DATE BETWEEN dbo.fnc_StrToDateTime(@YYYYMMDD_FROM + '000000') AND dbo.fnc_StrToDateTime(@YYYYMMDD_TO + '235959')) declare @id int declare @totalRows int = (select count(*) from tempWsGs1_001) declare @currentRow int = 0 declare @BussinessTypeTH VARCHAR(max) declare @BussinessTypeEN VARCHAR(max) while @currentRow < @totalRows begin set @id = @currentRow+1 declare @TAX_ID varchar(max) set @TAX_ID = (select top 1 tax_id from tempWsGs1_001 where id=@id) insert into tempWsGs1_002 select * from fnc_GetGS1MemberInfoForWebServiceByTaxID(@TAX_ID) set @currentRow = @currentRow +1 end drop table tempWsGs1_001 select * from tempWsGs1_002 drop table tempWsGs1_002 12:00:48 16 กุมภาพันธ์ 2561 :There is already an object named 'tempWsGs1_001' in the database. 12:08:19 16 กุมภาพันธ์ 2561 :Index was out of range. Must be non-negative and less than the size of the collection. Parameter name: index 12:08:19 16 กุมภาพันธ์ 2561 :try to logon with: GS1WS 12:10:36 16 กุมภาพันธ์ 2561 :Index was out of range. Must be non-negative and less than the size of the collection. Parameter name: index 12:10:36 16 กุมภาพันธ์ 2561 :try to logon with: GS1WS 12:13:14 16 กุมภาพันธ์ 2561 :Index was out of range. Must be non-negative and less than the size of the collection. Parameter name: index 12:13:14 16 กุมภาพันธ์ 2561 :try to logon with: GS1WS 12:15:30 16 กุมภาพันธ์ 2561 :Index was out of range. Must be non-negative and less than the size of the collection. Parameter name: index 12:15:30 16 กุมภาพันธ์ 2561 :try to logon with: GS1WS 12:18:13 16 กุมภาพันธ์ 2561 :Index was out of range. Must be non-negative and less than the size of the collection. Parameter name: index 12:18:13 16 กุมภาพันธ์ 2561 :try to logon with: GS1WS 12:21:00 16 กุมภาพันธ์ 2561 :Index was out of range. Must be non-negative and less than the size of the collection. Parameter name: index 12:21:00 16 กุมภาพันธ์ 2561 :try to logon with: GS1WS 12:23:36 16 กุมภาพันธ์ 2561 :Index was out of range. Must be non-negative and less than the size of the collection. Parameter name: index 12:23:36 16 กุมภาพันธ์ 2561 :try to logon with: GS1WS 12:28:34 16 กุมภาพันธ์ 2561 :Index was out of range. Must be non-negative and less than the size of the collection. Parameter name: index 12:28:34 16 กุมภาพันธ์ 2561 :try to logon with: GS1WS 12:31:46 16 กุมภาพันธ์ 2561 :Index was out of range. Must be non-negative and less than the size of the collection. Parameter name: index 12:31:46 16 กุมภาพันธ์ 2561 :try to logon with: GS1WS 12:34:15 16 กุมภาพันธ์ 2561 :Index was out of range. Must be non-negative and less than the size of the collection. Parameter name: index 12:34:15 16 กุมภาพันธ์ 2561 :try to logon with: GS1WS 12:36:26 16 กุมภาพันธ์ 2561 :Index was out of range. Must be non-negative and less than the size of the collection. Parameter name: index 12:36:26 16 กุมภาพันธ์ 2561 :try to logon with: GS1WS 12:38:34 16 กุมภาพันธ์ 2561 :Index was out of range. Must be non-negative and less than the size of the collection. Parameter name: index 12:38:34 16 กุมภาพันธ์ 2561 :try to logon with: GS1WS 12:42:11 16 กุมภาพันธ์ 2561 :Index was out of range. Must be non-negative and less than the size of the collection. Parameter name: index 12:42:11 16 กุมภาพันธ์ 2561 :try to logon with: GS1WS 12:42:52 16 กุมภาพันธ์ 2561 :Index was out of range. Must be non-negative and less than the size of the collection. Parameter name: index 12:42:52 16 กุมภาพันธ์ 2561 :try to logon with: GS1WS 12:45:01 16 กุมภาพันธ์ 2561 :Index was out of range. Must be non-negative and less than the size of the collection. Parameter name: index 12:45:01 16 กุมภาพันธ์ 2561 :try to logon with: GS1WS 13:00:52 16 กุมภาพันธ์ 2561 :Index was out of range. Must be non-negative and less than the size of the collection. Parameter name: index 13:00:52 16 กุมภาพันธ์ 2561 :try to logon with: GS1WS 13:00:52 16 กุมภาพันธ์ 2561 :getGS1changed=/*SELECT MB_MEMBER.MEMBER_CODE, MB_PRENAME.PRENAME_TH, MB_COMP_PERSON.COMP_PERSON_NAME_TH, MB_PRENAME.PRENAME_EN, MB_COMP_PERSON.COMP_PERSON_NAME_EN, MB_COMP_PERSON.TAX_ID, MB_MEMBER.REGIST_DATE, MB_MEMBER.MEMBER_MAIN_TYPE_CODE, MB_MEMBER.MEMBER_TYPE_CODE, MB_MEMBER.MEMBER_STATUS_CODE, MB_MEMBER_RETIRE.APPROVE_DATE FROM MB_MEMBER INNER JOIN MB_COMP_PERSON ON MB_MEMBER.COMP_PERSON_CODE = MB_COMP_PERSON.COMP_PERSON_CODE INNER JOIN MB_MEMBER_RETIRE ON MB_MEMBER.REGIST_CODE = MB_MEMBER_RETIRE.REGIST_CODE LEFT OUTER JOIN MB_PRENAME ON MB_COMP_PERSON.PREN_CODE = MB_PRENAME.PRENAME_CODE WHERE (MB_MEMBER.MEMBER_MAIN_GROUP_CODE = '300') AND (MB_MEMBER_RETIRE.APPROVE_DATE BETWEEN dbo.fnc_StrToDateTime(@YYYYMMDD_FROM + '000000') AND dbo.fnc_StrToDateTime(@YYYYMMDD_TO + '235959')) ORDER BY MB_MEMBER_RETIRE.APPROVE_DATE*/ --declare @YYYYMMDD_FROM varchar(max) = '20171101' --declare @YYYYMMDD_TO varchar(max) = '20171201' create table tempWsGs1_001 ( id int, tax_id varchar(max) ) create table tempWsGs1_002 ( MEMBER_CODE varchar(max) , TAX_ID varchar(max) , BDB_CODE varchar(max) , MEMBER_MAIN_TYPE_CODE varchar(max) , MEMBER_MAIN_TYPE_NAME varchar(max) , MEMBER_TYPE_CODE varchar(max) , MEMBER_TYPE_NAME varchar(max) , BUSSINESS_TYPE_TH varchar(max) , BUSSINESS_TYPE_EN varchar(max) , PRENAME_TH varchar(max) , COMP_PERSON_NAME_TH varchar(max) , PRENAME_EN varchar(max) , COMP_PERSON_NAME_EN varchar(max) , ADDR_TH varchar(max) , ADDR_EN varchar(max) , ZIP_CODE_TH varchar(max) , ZIP_CODE_EN varchar(max) , TELEPHONE_TH varchar(max) , TELEPHONE_EN varchar(max) , EMAIL_TH varchar(max) , EMAIL_EN varchar(max) , STATUS varchar(max) , REGIST_DATE varchar(max) , MEMBER_DATE varchar(max) , UPDATE_DATE varchar(max) , CompanyPrefix varchar(max) ) insert into tempWsGs1_001 select distinct ROW_NUMBER() over (order by r.approve_date) as id, c.TAX_ID as tax_id from MB_MEMBER m,MB_COMP_PERSON c,MB_MEMBER_RETIRE r where r.REGIST_CODE=m.REGIST_CODE and m.MEMBER_MAIN_GROUP_CODE='300' and m.COMP_PERSON_CODE=c.COMP_PERSON_CODE AND (r.APPROVE_DATE BETWEEN dbo.fnc_StrToDateTime(@YYYYMMDD_FROM + '000000') AND dbo.fnc_StrToDateTime(@YYYYMMDD_TO + '235959')) declare @id int declare @totalRows int = (select count(*) from tempWsGs1_001) declare @currentRow int = 0 declare @BussinessTypeTH VARCHAR(max) declare @BussinessTypeEN VARCHAR(max) while @currentRow < @totalRows begin set @id = @currentRow+1 declare @TAX_ID varchar(max) set @TAX_ID = (select top 1 tax_id from tempWsGs1_001 where id=@id) insert into tempWsGs1_002 select * from fnc_GetGS1MemberInfoForWebServiceByTaxID(@TAX_ID) set @currentRow = @currentRow +1 end drop table tempWsGs1_001 select * from tempWsGs1_002 drop table tempWsGs1_002 13:00:52 16 กุมภาพันธ์ 2561 :There is already an object named 'tempWsGs1_001' in the database. 13:01:12 16 กุมภาพันธ์ 2561 :Index was out of range. Must be non-negative and less than the size of the collection. Parameter name: index 13:01:12 16 กุมภาพันธ์ 2561 :try to logon with: GS1WS 13:01:12 16 กุมภาพันธ์ 2561 :getGS1changed=/*SELECT MB_MEMBER.MEMBER_CODE, MB_PRENAME.PRENAME_TH, MB_COMP_PERSON.COMP_PERSON_NAME_TH, MB_PRENAME.PRENAME_EN, MB_COMP_PERSON.COMP_PERSON_NAME_EN, MB_COMP_PERSON.TAX_ID, MB_MEMBER.REGIST_DATE, MB_MEMBER.MEMBER_MAIN_TYPE_CODE, MB_MEMBER.MEMBER_TYPE_CODE, MB_MEMBER.MEMBER_STATUS_CODE, MB_MEMBER_RETIRE.APPROVE_DATE FROM MB_MEMBER INNER JOIN MB_COMP_PERSON ON MB_MEMBER.COMP_PERSON_CODE = MB_COMP_PERSON.COMP_PERSON_CODE INNER JOIN MB_MEMBER_RETIRE ON MB_MEMBER.REGIST_CODE = MB_MEMBER_RETIRE.REGIST_CODE LEFT OUTER JOIN MB_PRENAME ON MB_COMP_PERSON.PREN_CODE = MB_PRENAME.PRENAME_CODE WHERE (MB_MEMBER.MEMBER_MAIN_GROUP_CODE = '300') AND (MB_MEMBER_RETIRE.APPROVE_DATE BETWEEN dbo.fnc_StrToDateTime(@YYYYMMDD_FROM + '000000') AND dbo.fnc_StrToDateTime(@YYYYMMDD_TO + '235959')) ORDER BY MB_MEMBER_RETIRE.APPROVE_DATE*/ --declare @YYYYMMDD_FROM varchar(max) = '20171101' --declare @YYYYMMDD_TO varchar(max) = '20171201' create table tempWsGs1_001 ( id int, tax_id varchar(max) ) create table tempWsGs1_002 ( MEMBER_CODE varchar(max) , TAX_ID varchar(max) , BDB_CODE varchar(max) , MEMBER_MAIN_TYPE_CODE varchar(max) , MEMBER_MAIN_TYPE_NAME varchar(max) , MEMBER_TYPE_CODE varchar(max) , MEMBER_TYPE_NAME varchar(max) , BUSSINESS_TYPE_TH varchar(max) , BUSSINESS_TYPE_EN varchar(max) , PRENAME_TH varchar(max) , COMP_PERSON_NAME_TH varchar(max) , PRENAME_EN varchar(max) , COMP_PERSON_NAME_EN varchar(max) , ADDR_TH varchar(max) , ADDR_EN varchar(max) , ZIP_CODE_TH varchar(max) , ZIP_CODE_EN varchar(max) , TELEPHONE_TH varchar(max) , TELEPHONE_EN varchar(max) , EMAIL_TH varchar(max) , EMAIL_EN varchar(max) , STATUS varchar(max) , REGIST_DATE varchar(max) , MEMBER_DATE varchar(max) , UPDATE_DATE varchar(max) , CompanyPrefix varchar(max) ) insert into tempWsGs1_001 select distinct ROW_NUMBER() over (order by r.approve_date) as id, c.TAX_ID as tax_id from MB_MEMBER m,MB_COMP_PERSON c,MB_MEMBER_RETIRE r where r.REGIST_CODE=m.REGIST_CODE and m.MEMBER_MAIN_GROUP_CODE='300' and m.COMP_PERSON_CODE=c.COMP_PERSON_CODE AND (r.APPROVE_DATE BETWEEN dbo.fnc_StrToDateTime(@YYYYMMDD_FROM + '000000') AND dbo.fnc_StrToDateTime(@YYYYMMDD_TO + '235959')) declare @id int declare @totalRows int = (select count(*) from tempWsGs1_001) declare @currentRow int = 0 declare @BussinessTypeTH VARCHAR(max) declare @BussinessTypeEN VARCHAR(max) while @currentRow < @totalRows begin set @id = @currentRow+1 declare @TAX_ID varchar(max) set @TAX_ID = (select top 1 tax_id from tempWsGs1_001 where id=@id) insert into tempWsGs1_002 select * from fnc_GetGS1MemberInfoForWebServiceByTaxID(@TAX_ID) set @currentRow = @currentRow +1 end drop table tempWsGs1_001 select * from tempWsGs1_002 drop table tempWsGs1_002 13:01:12 16 กุมภาพันธ์ 2561 :There is already an object named 'tempWsGs1_001' in the database. 13:08:32 16 กุมภาพันธ์ 2561 :Index was out of range. Must be non-negative and less than the size of the collection. Parameter name: index 13:08:32 16 กุมภาพันธ์ 2561 :try to logon with: GS1WS 13:12:04 16 กุมภาพันธ์ 2561 :Index was out of range. Must be non-negative and less than the size of the collection. Parameter name: index 13:12:04 16 กุมภาพันธ์ 2561 :try to logon with: GS1WS 13:12:43 16 กุมภาพันธ์ 2561 :Index was out of range. Must be non-negative and less than the size of the collection. Parameter name: index 13:12:43 16 กุมภาพันธ์ 2561 :try to logon with: GS1WS 13:15:08 16 กุมภาพันธ์ 2561 :Index was out of range. Must be non-negative and less than the size of the collection. Parameter name: index 13:15:08 16 กุมภาพันธ์ 2561 :try to logon with: GS1WS 13:19:41 16 กุมภาพันธ์ 2561 :Index was out of range. Must be non-negative and less than the size of the collection. Parameter name: index 13:19:41 16 กุมภาพันธ์ 2561 :try to logon with: GS1WS 13:20:09 16 กุมภาพันธ์ 2561 :Index was out of range. Must be non-negative and less than the size of the collection. Parameter name: index 13:20:09 16 กุมภาพันธ์ 2561 :try to logon with: GS1WS 13:21:23 16 กุมภาพันธ์ 2561 :Index was out of range. Must be non-negative and less than the size of the collection. Parameter name: index 13:21:23 16 กุมภาพันธ์ 2561 :try to logon with: GS1WS 13:24:13 16 กุมภาพันธ์ 2561 :Index was out of range. Must be non-negative and less than the size of the collection. Parameter name: index 13:24:13 16 กุมภาพันธ์ 2561 :try to logon with: GS1WS 13:25:30 16 กุมภาพันธ์ 2561 :Index was out of range. Must be non-negative and less than the size of the collection. Parameter name: index 13:25:30 16 กุมภาพันธ์ 2561 :try to logon with: GS1WS 13:25:30 16 กุมภาพันธ์ 2561 :Index was out of range. Must be non-negative and less than the size of the collection. Parameter name: index 13:25:30 16 กุมภาพันธ์ 2561 :try to logon with: GS1WS 13:25:30 16 กุมภาพันธ์ 2561 :Index was out of range. Must be non-negative and less than the size of the collection. Parameter name: index 13:25:30 16 กุมภาพันธ์ 2561 :try to logon with: GS1WS 13:25:31 16 กุมภาพันธ์ 2561 :Index was out of range. Must be non-negative and less than the size of the collection. Parameter name: index 13:25:31 16 กุมภาพันธ์ 2561 :try to logon with: GS1WS 13:25:32 16 กุมภาพันธ์ 2561 :Index was out of range. Must be non-negative and less than the size of the collection. Parameter name: index 13:25:32 16 กุมภาพันธ์ 2561 :try to logon with: GS1WS 13:25:32 16 กุมภาพันธ์ 2561 :Index was out of range. Must be non-negative and less than the size of the collection. Parameter name: index 13:25:32 16 กุมภาพันธ์ 2561 :try to logon with: GS1WS 13:25:34 16 กุมภาพันธ์ 2561 :Index was out of range. Must be non-negative and less than the size of the collection. Parameter name: index 13:25:34 16 กุมภาพันธ์ 2561 :try to logon with: GS1WS 13:25:34 16 กุมภาพันธ์ 2561 :Index was out of range. Must be non-negative and less than the size of the collection. Parameter name: index 13:25:34 16 กุมภาพันธ์ 2561 :try to logon with: GS1WS 13:25:34 16 กุมภาพันธ์ 2561 :Index was out of range. Must be non-negative and less than the size of the collection. Parameter name: index 13:25:34 16 กุมภาพันธ์ 2561 :try to logon with: GS1WS 13:25:34 16 กุมภาพันธ์ 2561 :Index was out of range. Must be non-negative and less than the size of the collection. Parameter name: index 13:25:34 16 กุมภาพันธ์ 2561 :try to logon with: GS1WS 13:25:34 16 กุมภาพันธ์ 2561 :Index was out of range. Must be non-negative and less than the size of the collection. Parameter name: index 13:25:34 16 กุมภาพันธ์ 2561 :try to logon with: GS1WS 13:25:34 16 กุมภาพันธ์ 2561 :Index was out of range. Must be non-negative and less than the size of the collection. Parameter name: index 13:25:34 16 กุมภาพันธ์ 2561 :try to logon with: GS1WS 13:25:34 16 กุมภาพันธ์ 2561 :Index was out of range. Must be non-negative and less than the size of the collection. Parameter name: index 13:25:34 16 กุมภาพันธ์ 2561 :try to logon with: GS1WS 13:25:34 16 กุมภาพันธ์ 2561 :Index was out of range. Must be non-negative and less than the size of the collection. Parameter name: index 13:25:34 16 กุมภาพันธ์ 2561 :try to logon with: GS1WS 13:25:34 16 กุมภาพันธ์ 2561 :Index was out of range. Must be non-negative and less than the size of the collection. Parameter name: index 13:25:34 16 กุมภาพันธ์ 2561 :try to logon with: GS1WS 13:25:35 16 กุมภาพันธ์ 2561 :Index was out of range. Must be non-negative and less than the size of the collection. Parameter name: index 13:25:35 16 กุมภาพันธ์ 2561 :try to logon with: GS1WS 13:25:35 16 กุมภาพันธ์ 2561 :Index was out of range. Must be non-negative and less than the size of the collection. Parameter name: index 13:25:35 16 กุมภาพันธ์ 2561 :try to logon with: GS1WS 13:25:35 16 กุมภาพันธ์ 2561 :Index was out of range. Must be non-negative and less than the size of the collection. Parameter name: index 13:25:35 16 กุมภาพันธ์ 2561 :try to logon with: GS1WS 13:25:35 16 กุมภาพันธ์ 2561 :Index was out of range. Must be non-negative and less than the size of the collection. Parameter name: index 13:25:35 16 กุมภาพันธ์ 2561 :try to logon with: GS1WS 13:25:35 16 กุมภาพันธ์ 2561 :Index was out of range. Must be non-negative and less than the size of the collection. Parameter name: index 13:25:35 16 กุมภาพันธ์ 2561 :try to logon with: GS1WS 13:25:35 16 กุมภาพันธ์ 2561 :Index was out of range. Must be non-negative and less than the size of the collection. Parameter name: index 13:25:35 16 กุมภาพันธ์ 2561 :try to logon with: GS1WS 13:25:35 16 กุมภาพันธ์ 2561 :Index was out of range. Must be non-negative and less than the size of the collection. Parameter name: index 13:25:35 16 กุมภาพันธ์ 2561 :try to logon with: GS1WS 13:25:36 16 กุมภาพันธ์ 2561 :Index was out of range. Must be non-negative and less than the size of the collection. Parameter name: index 13:25:36 16 กุมภาพันธ์ 2561 :try to logon with: GS1WS 13:25:36 16 กุมภาพันธ์ 2561 :Index was out of range. Must be non-negative and less than the size of the collection. Parameter name: index 13:25:36 16 กุมภาพันธ์ 2561 :try to logon with: GS1WS 13:25:36 16 กุมภาพันธ์ 2561 :Index was out of range. Must be non-negative and less than the size of the collection. Parameter name: index 13:25:36 16 กุมภาพันธ์ 2561 :try to logon with: GS1WS 13:25:36 16 กุมภาพันธ์ 2561 :Index was out of range. Must be non-negative and less than the size of the collection. Parameter name: index 13:25:36 16 กุมภาพันธ์ 2561 :try to logon with: GS1WS 13:25:36 16 กุมภาพันธ์ 2561 :Index was out of range. Must be non-negative and less than the size of the collection. Parameter name: index 13:25:36 16 กุมภาพันธ์ 2561 :try to logon with: GS1WS 13:25:36 16 กุมภาพันธ์ 2561 :Index was out of range. Must be non-negative and less than the size of the collection. Parameter name: index 13:25:36 16 กุมภาพันธ์ 2561 :try to logon with: GS1WS 13:25:36 16 กุมภาพันธ์ 2561 :Index was out of range. Must be non-negative and less than the size of the collection. Parameter name: index 13:25:36 16 กุมภาพันธ์ 2561 :try to logon with: GS1WS 13:25:36 16 กุมภาพันธ์ 2561 :Index was out of range. Must be non-negative and less than the size of the collection. Parameter name: index 13:25:36 16 กุมภาพันธ์ 2561 :try to logon with: GS1WS 13:25:37 16 กุมภาพันธ์ 2561 :Index was out of range. Must be non-negative and less than the size of the collection. Parameter name: index 13:25:37 16 กุมภาพันธ์ 2561 :try to logon with: GS1WS 13:25:37 16 กุมภาพันธ์ 2561 :Index was out of range. Must be non-negative and less than the size of the collection. Parameter name: index 13:25:37 16 กุมภาพันธ์ 2561 :try to logon with: GS1WS 13:25:37 16 กุมภาพันธ์ 2561 :Index was out of range. Must be non-negative and less than the size of the collection. Parameter name: index 13:25:37 16 กุมภาพันธ์ 2561 :try to logon with: GS1WS 13:25:37 16 กุมภาพันธ์ 2561 :Index was out of range. Must be non-negative and less than the size of the collection. Parameter name: index 13:25:37 16 กุมภาพันธ์ 2561 :try to logon with: GS1WS 13:25:37 16 กุมภาพันธ์ 2561 :Index was out of range. Must be non-negative and less than the size of the collection. Parameter name: index 13:25:37 16 กุมภาพันธ์ 2561 :try to logon with: GS1WS 13:25:37 16 กุมภาพันธ์ 2561 :Index was out of range. Must be non-negative and less than the size of the collection. Parameter name: index 13:25:37 16 กุมภาพันธ์ 2561 :try to logon with: GS1WS 13:25:37 16 กุมภาพันธ์ 2561 :Index was out of range. Must be non-negative and less than the size of the collection. Parameter name: index 13:25:37 16 กุมภาพันธ์ 2561 :try to logon with: GS1WS 13:25:37 16 กุมภาพันธ์ 2561 :Index was out of range. Must be non-negative and less than the size of the collection. Parameter name: index 13:25:37 16 กุมภาพันธ์ 2561 :try to logon with: GS1WS 13:25:37 16 กุมภาพันธ์ 2561 :Index was out of range. Must be non-negative and less than the size of the collection. Parameter name: index 13:25:37 16 กุมภาพันธ์ 2561 :try to logon with: GS1WS 13:25:38 16 กุมภาพันธ์ 2561 :Index was out of range. Must be non-negative and less than the size of the collection. Parameter name: index 13:25:38 16 กุมภาพันธ์ 2561 :try to logon with: GS1WS 13:25:38 16 กุมภาพันธ์ 2561 :Index was out of range. Must be non-negative and less than the size of the collection. Parameter name: index 13:25:38 16 กุมภาพันธ์ 2561 :try to logon with: GS1WS 13:29:32 16 กุมภาพันธ์ 2561 :Index was out of range. Must be non-negative and less than the size of the collection. Parameter name: index 13:29:32 16 กุมภาพันธ์ 2561 :try to logon with: GS1WS 13:29:32 16 กุมภาพันธ์ 2561 :Index was out of range. Must be non-negative and less than the size of the collection. Parameter name: index 13:29:32 16 กุมภาพันธ์ 2561 :try to logon with: GS1WS 13:29:32 16 กุมภาพันธ์ 2561 :Index was out of range. Must be non-negative and less than the size of the collection. Parameter name: index 13:29:32 16 กุมภาพันธ์ 2561 :try to logon with: GS1WS 13:29:33 16 กุมภาพันธ์ 2561 :Index was out of range. Must be non-negative and less than the size of the collection. Parameter name: index 13:29:33 16 กุมภาพันธ์ 2561 :try to logon with: GS1WS 13:29:33 16 กุมภาพันธ์ 2561 :Index was out of range. Must be non-negative and less than the size of the collection. Parameter name: index 13:29:33 16 กุมภาพันธ์ 2561 :try to logon with: GS1WS 13:29:33 16 กุมภาพันธ์ 2561 :Index was out of range. Must be non-negative and less than the size of the collection. Parameter name: index 13:29:33 16 กุมภาพันธ์ 2561 :try to logon with: GS1WS 13:29:33 16 กุมภาพันธ์ 2561 :Index was out of range. Must be non-negative and less than the size of the collection. Parameter name: index 13:29:33 16 กุมภาพันธ์ 2561 :try to logon with: GS1WS 13:29:33 16 กุมภาพันธ์ 2561 :Index was out of range. Must be non-negative and less than the size of the collection. Parameter name: index 13:29:33 16 กุมภาพันธ์ 2561 :try to logon with: GS1WS 13:29:33 16 กุมภาพันธ์ 2561 :Index was out of range. Must be non-negative and less than the size of the collection. Parameter name: index 13:29:33 16 กุมภาพันธ์ 2561 :try to logon with: GS1WS 13:29:33 16 กุมภาพันธ์ 2561 :Index was out of range. Must be non-negative and less than the size of the collection. Parameter name: index 13:29:33 16 กุมภาพันธ์ 2561 :try to logon with: GS1WS 13:29:33 16 กุมภาพันธ์ 2561 :Index was out of range. Must be non-negative and less than the size of the collection. Parameter name: index 13:29:33 16 กุมภาพันธ์ 2561 :try to logon with: GS1WS 13:29:33 16 กุมภาพันธ์ 2561 :Index was out of range. Must be non-negative and less than the size of the collection. Parameter name: index 13:29:34 16 กุมภาพันธ์ 2561 :try to logon with: GS1WS 13:29:34 16 กุมภาพันธ์ 2561 :Index was out of range. Must be non-negative and less than the size of the collection. Parameter name: index 13:29:34 16 กุมภาพันธ์ 2561 :try to logon with: GS1WS 13:29:34 16 กุมภาพันธ์ 2561 :Index was out of range. Must be non-negative and less than the size of the collection. Parameter name: index 13:29:34 16 กุมภาพันธ์ 2561 :try to logon with: GS1WS 13:29:34 16 กุมภาพันธ์ 2561 :Index was out of range. Must be non-negative and less than the size of the collection. Parameter name: index 13:29:34 16 กุมภาพันธ์ 2561 :try to logon with: GS1WS 13:29:34 16 กุมภาพันธ์ 2561 :Index was out of range. Must be non-negative and less than the size of the collection. Parameter name: index 13:29:34 16 กุมภาพันธ์ 2561 :try to logon with: GS1WS 13:29:34 16 กุมภาพันธ์ 2561 :Index was out of range. Must be non-negative and less than the size of the collection. Parameter name: index 13:29:34 16 กุมภาพันธ์ 2561 :try to logon with: GS1WS 13:29:34 16 กุมภาพันธ์ 2561 :Index was out of range. Must be non-negative and less than the size of the collection. Parameter name: index 13:29:34 16 กุมภาพันธ์ 2561 :try to logon with: GS1WS 13:29:34 16 กุมภาพันธ์ 2561 :Index was out of range. Must be non-negative and less than the size of the collection. Parameter name: index 13:29:34 16 กุมภาพันธ์ 2561 :try to logon with: GS1WS 13:29:34 16 กุมภาพันธ์ 2561 :Index was out of range. Must be non-negative and less than the size of the collection. Parameter name: index 13:29:34 16 กุมภาพันธ์ 2561 :try to logon with: GS1WS 13:29:35 16 กุมภาพันธ์ 2561 :Index was out of range. Must be non-negative and less than the size of the collection. Parameter name: index 13:29:35 16 กุมภาพันธ์ 2561 :try to logon with: GS1WS 13:29:35 16 กุมภาพันธ์ 2561 :Index was out of range. Must be non-negative and less than the size of the collection. Parameter name: index 13:29:35 16 กุมภาพันธ์ 2561 :try to logon with: GS1WS 13:29:35 16 กุมภาพันธ์ 2561 :Index was out of range. Must be non-negative and less than the size of the collection. Parameter name: index 13:29:35 16 กุมภาพันธ์ 2561 :try to logon with: GS1WS 13:29:35 16 กุมภาพันธ์ 2561 :Index was out of range. Must be non-negative and less than the size of the collection. Parameter name: index 13:29:35 16 กุมภาพันธ์ 2561 :try to logon with: GS1WS 13:29:35 16 กุมภาพันธ์ 2561 :Index was out of range. Must be non-negative and less than the size of the collection. Parameter name: index 13:29:35 16 กุมภาพันธ์ 2561 :try to logon with: GS1WS 13:29:35 16 กุมภาพันธ์ 2561 :Index was out of range. Must be non-negative and less than the size of the collection. Parameter name: index 13:29:35 16 กุมภาพันธ์ 2561 :try to logon with: GS1WS 13:29:35 16 กุมภาพันธ์ 2561 :Index was out of range. Must be non-negative and less than the size of the collection. Parameter name: index 13:29:35 16 กุมภาพันธ์ 2561 :try to logon with: GS1WS 13:29:35 16 กุมภาพันธ์ 2561 :Index was out of range. Must be non-negative and less than the size of the collection. Parameter name: index 13:29:35 16 กุมภาพันธ์ 2561 :try to logon with: GS1WS 13:29:36 16 กุมภาพันธ์ 2561 :Index was out of range. Must be non-negative and less than the size of the collection. Parameter name: index 13:29:36 16 กุมภาพันธ์ 2561 :try to logon with: GS1WS 13:29:36 16 กุมภาพันธ์ 2561 :Index was out of range. Must be non-negative and less than the size of the collection. Parameter name: index 13:29:36 16 กุมภาพันธ์ 2561 :try to logon with: GS1WS 13:29:36 16 กุมภาพันธ์ 2561 :Index was out of range. Must be non-negative and less than the size of the collection. Parameter name: index 13:29:36 16 กุมภาพันธ์ 2561 :try to logon with: GS1WS 13:29:36 16 กุมภาพันธ์ 2561 :Index was out of range. Must be non-negative and less than the size of the collection. Parameter name: index 13:29:36 16 กุมภาพันธ์ 2561 :try to logon with: GS1WS 13:29:36 16 กุมภาพันธ์ 2561 :Index was out of range. Must be non-negative and less than the size of the collection. Parameter name: index 13:29:36 16 กุมภาพันธ์ 2561 :try to logon with: GS1WS 13:29:36 16 กุมภาพันธ์ 2561 :Index was out of range. Must be non-negative and less than the size of the collection. Parameter name: index 13:29:36 16 กุมภาพันธ์ 2561 :try to logon with: GS1WS 13:29:36 16 กุมภาพันธ์ 2561 :Index was out of range. Must be non-negative and less than the size of the collection. Parameter name: index 13:29:36 16 กุมภาพันธ์ 2561 :try to logon with: GS1WS 13:29:36 16 กุมภาพันธ์ 2561 :Index was out of range. Must be non-negative and less than the size of the collection. Parameter name: index 13:29:36 16 กุมภาพันธ์ 2561 :try to logon with: GS1WS 13:29:37 16 กุมภาพันธ์ 2561 :Index was out of range. Must be non-negative and less than the size of the collection. Parameter name: index 13:29:37 16 กุมภาพันธ์ 2561 :try to logon with: GS1WS 13:29:37 16 กุมภาพันธ์ 2561 :Index was out of range. Must be non-negative and less than the size of the collection. Parameter name: index 13:29:37 16 กุมภาพันธ์ 2561 :try to logon with: GS1WS 13:29:37 16 กุมภาพันธ์ 2561 :Index was out of range. Must be non-negative and less than the size of the collection. Parameter name: index 13:29:37 16 กุมภาพันธ์ 2561 :try to logon with: GS1WS 13:29:37 16 กุมภาพันธ์ 2561 :Index was out of range. Must be non-negative and less than the size of the collection. Parameter name: index 13:29:37 16 กุมภาพันธ์ 2561 :try to logon with: GS1WS 13:29:37 16 กุมภาพันธ์ 2561 :Index was out of range. Must be non-negative and less than the size of the collection. Parameter name: index 13:29:37 16 กุมภาพันธ์ 2561 :try to logon with: GS1WS 13:31:20 16 กุมภาพันธ์ 2561 :Index was out of range. Must be non-negative and less than the size of the collection. Parameter name: index 13:31:20 16 กุมภาพันธ์ 2561 :try to logon with: GS1WS 13:31:20 16 กุมภาพันธ์ 2561 :Index was out of range. Must be non-negative and less than the size of the collection. Parameter name: index 13:31:20 16 กุมภาพันธ์ 2561 :try to logon with: GS1WS 13:31:20 16 กุมภาพันธ์ 2561 :Index was out of range. Must be non-negative and less than the size of the collection. Parameter name: index 13:31:20 16 กุมภาพันธ์ 2561 :try to logon with: GS1WS 13:31:20 16 กุมภาพันธ์ 2561 :Index was out of range. Must be non-negative and less than the size of the collection. Parameter name: index 13:31:20 16 กุมภาพันธ์ 2561 :try to logon with: GS1WS 13:31:20 16 กุมภาพันธ์ 2561 :Index was out of range. Must be non-negative and less than the size of the collection. Parameter name: index 13:31:20 16 กุมภาพันธ์ 2561 :try to logon with: GS1WS 13:31:20 16 กุมภาพันธ์ 2561 :Index was out of range. Must be non-negative and less than the size of the collection. Parameter name: index 13:31:20 16 กุมภาพันธ์ 2561 :try to logon with: GS1WS 13:31:21 16 กุมภาพันธ์ 2561 :Index was out of range. Must be non-negative and less than the size of the collection. Parameter name: index 13:31:21 16 กุมภาพันธ์ 2561 :try to logon with: GS1WS 13:31:21 16 กุมภาพันธ์ 2561 :Index was out of range. Must be non-negative and less than the size of the collection. Parameter name: index 13:31:21 16 กุมภาพันธ์ 2561 :try to logon with: GS1WS 13:31:21 16 กุมภาพันธ์ 2561 :Index was out of range. Must be non-negative and less than the size of the collection. Parameter name: index 13:31:21 16 กุมภาพันธ์ 2561 :try to logon with: GS1WS 13:31:21 16 กุมภาพันธ์ 2561 :Index was out of range. Must be non-negative and less than the size of the collection. Parameter name: index 13:31:21 16 กุมภาพันธ์ 2561 :try to logon with: GS1WS 13:31:21 16 กุมภาพันธ์ 2561 :Index was out of range. Must be non-negative and less than the size of the collection. Parameter name: index 13:31:21 16 กุมภาพันธ์ 2561 :try to logon with: GS1WS 13:31:21 16 กุมภาพันธ์ 2561 :Index was out of range. Must be non-negative and less than the size of the collection. Parameter name: index 13:31:21 16 กุมภาพันธ์ 2561 :try to logon with: GS1WS 13:31:21 16 กุมภาพันธ์ 2561 :Index was out of range. Must be non-negative and less than the size of the collection. Parameter name: index 13:31:21 16 กุมภาพันธ์ 2561 :try to logon with: GS1WS 13:31:21 16 กุมภาพันธ์ 2561 :Index was out of range. Must be non-negative and less than the size of the collection. Parameter name: index 13:31:21 16 กุมภาพันธ์ 2561 :try to logon with: GS1WS 13:31:21 16 กุมภาพันธ์ 2561 :Index was out of range. Must be non-negative and less than the size of the collection. Parameter name: index 13:31:21 16 กุมภาพันธ์ 2561 :try to logon with: GS1WS 13:31:22 16 กุมภาพันธ์ 2561 :Index was out of range. Must be non-negative and less than the size of the collection. Parameter name: index 13:31:22 16 กุมภาพันธ์ 2561 :try to logon with: GS1WS 13:31:22 16 กุมภาพันธ์ 2561 :Index was out of range. Must be non-negative and less than the size of the collection. Parameter name: index 13:31:22 16 กุมภาพันธ์ 2561 :try to logon with: GS1WS 13:31:22 16 กุมภาพันธ์ 2561 :Index was out of range. Must be non-negative and less than the size of the collection. Parameter name: index 13:31:22 16 กุมภาพันธ์ 2561 :try to logon with: GS1WS 13:31:22 16 กุมภาพันธ์ 2561 :Index was out of range. Must be non-negative and less than the size of the collection. Parameter name: index 13:31:22 16 กุมภาพันธ์ 2561 :try to logon with: GS1WS 13:31:22 16 กุมภาพันธ์ 2561 :Index was out of range. Must be non-negative and less than the size of the collection. Parameter name: index 13:31:22 16 กุมภาพันธ์ 2561 :try to logon with: GS1WS 13:31:23 16 กุมภาพันธ์ 2561 :Index was out of range. Must be non-negative and less than the size of the collection. Parameter name: index 13:31:23 16 กุมภาพันธ์ 2561 :try to logon with: GS1WS 13:33:47 16 กุมภาพันธ์ 2561 :Index was out of range. Must be non-negative and less than the size of the collection. Parameter name: index 13:33:47 16 กุมภาพันธ์ 2561 :try to logon with: GS1WS 13:37:54 16 กุมภาพันธ์ 2561 :Index was out of range. Must be non-negative and less than the size of the collection. Parameter name: index 13:37:54 16 กุมภาพันธ์ 2561 :try to logon with: GS1WS 13:53:14 16 กุมภาพันธ์ 2561 :Index was out of range. Must be non-negative and less than the size of the collection. Parameter name: index 13:53:14 16 กุมภาพันธ์ 2561 :try to logon with: GS1WS 13:54:54 16 กุมภาพันธ์ 2561 :Index was out of range. Must be non-negative and less than the size of the collection. Parameter name: index 13:54:54 16 กุมภาพันธ์ 2561 :try to logon with: GS1WS 13:58:40 16 กุมภาพันธ์ 2561 :Index was out of range. Must be non-negative and less than the size of the collection. Parameter name: index 13:58:40 16 กุมภาพันธ์ 2561 :try to logon with: GS1WS 13:59:37 16 กุมภาพันธ์ 2561 :Index was out of range. Must be non-negative and less than the size of the collection. Parameter name: index 13:59:37 16 กุมภาพันธ์ 2561 :try to logon with: GS1WS 14:00:16 16 กุมภาพันธ์ 2561 :Index was out of range. Must be non-negative and less than the size of the collection. Parameter name: index 14:00:16 16 กุมภาพันธ์ 2561 :try to logon with: GS1WS 14:00:48 16 กุมภาพันธ์ 2561 :Index was out of range. Must be non-negative and less than the size of the collection. Parameter name: index 14:00:48 16 กุมภาพันธ์ 2561 :try to logon with: GS1WS 14:00:48 16 กุมภาพันธ์ 2561 :getGS1changed=/*SELECT MB_MEMBER.MEMBER_CODE, MB_PRENAME.PRENAME_TH, MB_COMP_PERSON.COMP_PERSON_NAME_TH, MB_PRENAME.PRENAME_EN, MB_COMP_PERSON.COMP_PERSON_NAME_EN, MB_COMP_PERSON.TAX_ID, MB_MEMBER.REGIST_DATE, MB_MEMBER.MEMBER_MAIN_TYPE_CODE, MB_MEMBER.MEMBER_TYPE_CODE, MB_MEMBER.MEMBER_STATUS_CODE, MB_MEMBER_RETIRE.APPROVE_DATE FROM MB_MEMBER INNER JOIN MB_COMP_PERSON ON MB_MEMBER.COMP_PERSON_CODE = MB_COMP_PERSON.COMP_PERSON_CODE INNER JOIN MB_MEMBER_RETIRE ON MB_MEMBER.REGIST_CODE = MB_MEMBER_RETIRE.REGIST_CODE LEFT OUTER JOIN MB_PRENAME ON MB_COMP_PERSON.PREN_CODE = MB_PRENAME.PRENAME_CODE WHERE (MB_MEMBER.MEMBER_MAIN_GROUP_CODE = '300') AND (MB_MEMBER_RETIRE.APPROVE_DATE BETWEEN dbo.fnc_StrToDateTime(@YYYYMMDD_FROM + '000000') AND dbo.fnc_StrToDateTime(@YYYYMMDD_TO + '235959')) ORDER BY MB_MEMBER_RETIRE.APPROVE_DATE*/ --declare @YYYYMMDD_FROM varchar(max) = '20171101' --declare @YYYYMMDD_TO varchar(max) = '20171201' create table tempWsGs1_001 ( id int, tax_id varchar(max) ) create table tempWsGs1_002 ( MEMBER_CODE varchar(max) , TAX_ID varchar(max) , BDB_CODE varchar(max) , MEMBER_MAIN_TYPE_CODE varchar(max) , MEMBER_MAIN_TYPE_NAME varchar(max) , MEMBER_TYPE_CODE varchar(max) , MEMBER_TYPE_NAME varchar(max) , BUSSINESS_TYPE_TH varchar(max) , BUSSINESS_TYPE_EN varchar(max) , PRENAME_TH varchar(max) , COMP_PERSON_NAME_TH varchar(max) , PRENAME_EN varchar(max) , COMP_PERSON_NAME_EN varchar(max) , ADDR_TH varchar(max) , ADDR_EN varchar(max) , ZIP_CODE_TH varchar(max) , ZIP_CODE_EN varchar(max) , TELEPHONE_TH varchar(max) , TELEPHONE_EN varchar(max) , EMAIL_TH varchar(max) , EMAIL_EN varchar(max) , STATUS varchar(max) , REGIST_DATE varchar(max) , MEMBER_DATE varchar(max) , UPDATE_DATE varchar(max) , CompanyPrefix varchar(max) ) insert into tempWsGs1_001 select distinct ROW_NUMBER() over (order by r.approve_date) as id, c.TAX_ID as tax_id from MB_MEMBER m,MB_COMP_PERSON c,MB_MEMBER_RETIRE r where r.REGIST_CODE=m.REGIST_CODE and m.MEMBER_MAIN_GROUP_CODE='300' and m.COMP_PERSON_CODE=c.COMP_PERSON_CODE AND (r.APPROVE_DATE BETWEEN dbo.fnc_StrToDateTime(@YYYYMMDD_FROM + '000000') AND dbo.fnc_StrToDateTime(@YYYYMMDD_TO + '235959')) declare @id int declare @totalRows int = (select count(*) from tempWsGs1_001) declare @currentRow int = 0 declare @BussinessTypeTH VARCHAR(max) declare @BussinessTypeEN VARCHAR(max) while @currentRow < @totalRows begin set @id = @currentRow+1 declare @TAX_ID varchar(max) set @TAX_ID = (select top 1 tax_id from tempWsGs1_001 where id=@id) insert into tempWsGs1_002 select * from fnc_GetGS1MemberInfoForWebServiceByTaxID(@TAX_ID) set @currentRow = @currentRow +1 end drop table tempWsGs1_001 select * from tempWsGs1_002 drop table tempWsGs1_002 14:00:48 16 กุมภาพันธ์ 2561 :There is already an object named 'tempWsGs1_001' in the database. 14:03:21 16 กุมภาพันธ์ 2561 :Index was out of range. Must be non-negative and less than the size of the collection. Parameter name: index 14:03:21 16 กุมภาพันธ์ 2561 :try to logon with: GS1WS 14:04:55 16 กุมภาพันธ์ 2561 :Index was out of range. Must be non-negative and less than the size of the collection. Parameter name: index 14:04:55 16 กุมภาพันธ์ 2561 :try to logon with: GS1WS 14:13:09 16 กุมภาพันธ์ 2561 :Server was unable to process request. ---> Cannot open database "RDtmp" requested by the login. The login failed. 14:13:55 16 กุมภาพันธ์ 2561 :Server was unable to process request. ---> Cannot open database "RDtmp" requested by the login. The login failed. 14:14:36 16 กุมภาพันธ์ 2561 :Server was unable to process request. ---> Cannot open database "RDtmp" requested by the login. The login failed. 14:18:25 16 กุมภาพันธ์ 2561 :Index was out of range. Must be non-negative and less than the size of the collection. Parameter name: index 14:18:25 16 กุมภาพันธ์ 2561 :try to logon with: GS1WS 14:18:25 16 กุมภาพันธ์ 2561 :getGS1changed=/*SELECT MB_MEMBER.MEMBER_CODE, MB_PRENAME.PRENAME_TH, MB_COMP_PERSON.COMP_PERSON_NAME_TH, MB_PRENAME.PRENAME_EN, MB_COMP_PERSON.COMP_PERSON_NAME_EN, MB_COMP_PERSON.TAX_ID, MB_MEMBER.REGIST_DATE, MB_MEMBER.MEMBER_MAIN_TYPE_CODE, MB_MEMBER.MEMBER_TYPE_CODE, MB_MEMBER.MEMBER_STATUS_CODE, MB_MEMBER_RETIRE.APPROVE_DATE FROM MB_MEMBER INNER JOIN MB_COMP_PERSON ON MB_MEMBER.COMP_PERSON_CODE = MB_COMP_PERSON.COMP_PERSON_CODE INNER JOIN MB_MEMBER_RETIRE ON MB_MEMBER.REGIST_CODE = MB_MEMBER_RETIRE.REGIST_CODE LEFT OUTER JOIN MB_PRENAME ON MB_COMP_PERSON.PREN_CODE = MB_PRENAME.PRENAME_CODE WHERE (MB_MEMBER.MEMBER_MAIN_GROUP_CODE = '300') AND (MB_MEMBER_RETIRE.APPROVE_DATE BETWEEN dbo.fnc_StrToDateTime(@YYYYMMDD_FROM + '000000') AND dbo.fnc_StrToDateTime(@YYYYMMDD_TO + '235959')) ORDER BY MB_MEMBER_RETIRE.APPROVE_DATE*/ --declare @YYYYMMDD_FROM varchar(max) = '20171101' --declare @YYYYMMDD_TO varchar(max) = '20171201' create table tempWsGs1_001 ( id int, tax_id varchar(max) ) create table tempWsGs1_002 ( MEMBER_CODE varchar(max) , TAX_ID varchar(max) , BDB_CODE varchar(max) , MEMBER_MAIN_TYPE_CODE varchar(max) , MEMBER_MAIN_TYPE_NAME varchar(max) , MEMBER_TYPE_CODE varchar(max) , MEMBER_TYPE_NAME varchar(max) , BUSSINESS_TYPE_TH varchar(max) , BUSSINESS_TYPE_EN varchar(max) , PRENAME_TH varchar(max) , COMP_PERSON_NAME_TH varchar(max) , PRENAME_EN varchar(max) , COMP_PERSON_NAME_EN varchar(max) , ADDR_TH varchar(max) , ADDR_EN varchar(max) , ZIP_CODE_TH varchar(max) , ZIP_CODE_EN varchar(max) , TELEPHONE_TH varchar(max) , TELEPHONE_EN varchar(max) , EMAIL_TH varchar(max) , EMAIL_EN varchar(max) , STATUS varchar(max) , REGIST_DATE varchar(max) , MEMBER_DATE varchar(max) , UPDATE_DATE varchar(max) , CompanyPrefix varchar(max) ) insert into tempWsGs1_001 select distinct ROW_NUMBER() over (order by r.approve_date) as id, c.TAX_ID as tax_id from MB_MEMBER m,MB_COMP_PERSON c,MB_MEMBER_RETIRE r where r.REGIST_CODE=m.REGIST_CODE and m.MEMBER_MAIN_GROUP_CODE='300' and m.COMP_PERSON_CODE=c.COMP_PERSON_CODE AND (r.APPROVE_DATE BETWEEN dbo.fnc_StrToDateTime(@YYYYMMDD_FROM + '000000') AND dbo.fnc_StrToDateTime(@YYYYMMDD_TO + '235959')) declare @id int declare @totalRows int = (select count(*) from tempWsGs1_001) declare @currentRow int = 0 declare @BussinessTypeTH VARCHAR(max) declare @BussinessTypeEN VARCHAR(max) while @currentRow < @totalRows begin set @id = @currentRow+1 declare @TAX_ID varchar(max) set @TAX_ID = (select top 1 tax_id from tempWsGs1_001 where id=@id) insert into tempWsGs1_002 select * from fnc_GetGS1MemberInfoForWebServiceByTaxID(@TAX_ID) set @currentRow = @currentRow +1 end drop table tempWsGs1_001 select * from tempWsGs1_002 drop table tempWsGs1_002 14:18:25 16 กุมภาพันธ์ 2561 :There is already an object named 'tempWsGs1_001' in the database. 14:24:51 16 กุมภาพันธ์ 2561 :Index was out of range. Must be non-negative and less than the size of the collection. Parameter name: index 14:24:51 16 กุมภาพันธ์ 2561 :try to logon with: GS1WS 14:34:47 16 กุมภาพันธ์ 2561 :Index was out of range. Must be non-negative and less than the size of the collection. Parameter name: index 14:34:47 16 กุมภาพันธ์ 2561 :try to logon with: GS1WS 14:34:59 16 กุมภาพันธ์ 2561 :Index was out of range. Must be non-negative and less than the size of the collection. Parameter name: index 14:34:59 16 กุมภาพันธ์ 2561 :try to logon with: GS1WS 14:35:25 16 กุมภาพันธ์ 2561 :Index was out of range. Must be non-negative and less than the size of the collection. Parameter name: index 14:35:25 16 กุมภาพันธ์ 2561 :try to logon with: GS1WS 15:00:48 16 กุมภาพันธ์ 2561 :Index was out of range. Must be non-negative and less than the size of the collection. Parameter name: index 15:00:48 16 กุมภาพันธ์ 2561 :try to logon with: GS1WS 15:00:48 16 กุมภาพันธ์ 2561 :Index was out of range. Must be non-negative and less than the size of the collection. Parameter name: index 15:00:48 16 กุมภาพันธ์ 2561 :try to logon with: GS1WS 15:00:48 16 กุมภาพันธ์ 2561 :getGS1changed=/*SELECT MB_MEMBER.MEMBER_CODE, MB_PRENAME.PRENAME_TH, MB_COMP_PERSON.COMP_PERSON_NAME_TH, MB_PRENAME.PRENAME_EN, MB_COMP_PERSON.COMP_PERSON_NAME_EN, MB_COMP_PERSON.TAX_ID, MB_MEMBER.REGIST_DATE, MB_MEMBER.MEMBER_MAIN_TYPE_CODE, MB_MEMBER.MEMBER_TYPE_CODE, MB_MEMBER.MEMBER_STATUS_CODE, MB_MEMBER_RETIRE.APPROVE_DATE FROM MB_MEMBER INNER JOIN MB_COMP_PERSON ON MB_MEMBER.COMP_PERSON_CODE = MB_COMP_PERSON.COMP_PERSON_CODE INNER JOIN MB_MEMBER_RETIRE ON MB_MEMBER.REGIST_CODE = MB_MEMBER_RETIRE.REGIST_CODE LEFT OUTER JOIN MB_PRENAME ON MB_COMP_PERSON.PREN_CODE = MB_PRENAME.PRENAME_CODE WHERE (MB_MEMBER.MEMBER_MAIN_GROUP_CODE = '300') AND (MB_MEMBER_RETIRE.APPROVE_DATE BETWEEN dbo.fnc_StrToDateTime(@YYYYMMDD_FROM + '000000') AND dbo.fnc_StrToDateTime(@YYYYMMDD_TO + '235959')) ORDER BY MB_MEMBER_RETIRE.APPROVE_DATE*/ --declare @YYYYMMDD_FROM varchar(max) = '20171101' --declare @YYYYMMDD_TO varchar(max) = '20171201' create table tempWsGs1_001 ( id int, tax_id varchar(max) ) create table tempWsGs1_002 ( MEMBER_CODE varchar(max) , TAX_ID varchar(max) , BDB_CODE varchar(max) , MEMBER_MAIN_TYPE_CODE varchar(max) , MEMBER_MAIN_TYPE_NAME varchar(max) , MEMBER_TYPE_CODE varchar(max) , MEMBER_TYPE_NAME varchar(max) , BUSSINESS_TYPE_TH varchar(max) , BUSSINESS_TYPE_EN varchar(max) , PRENAME_TH varchar(max) , COMP_PERSON_NAME_TH varchar(max) , PRENAME_EN varchar(max) , COMP_PERSON_NAME_EN varchar(max) , ADDR_TH varchar(max) , ADDR_EN varchar(max) , ZIP_CODE_TH varchar(max) , ZIP_CODE_EN varchar(max) , TELEPHONE_TH varchar(max) , TELEPHONE_EN varchar(max) , EMAIL_TH varchar(max) , EMAIL_EN varchar(max) , STATUS varchar(max) , REGIST_DATE varchar(max) , MEMBER_DATE varchar(max) , UPDATE_DATE varchar(max) , CompanyPrefix varchar(max) ) insert into tempWsGs1_001 select distinct ROW_NUMBER() over (order by r.approve_date) as id, c.TAX_ID as tax_id from MB_MEMBER m,MB_COMP_PERSON c,MB_MEMBER_RETIRE r where r.REGIST_CODE=m.REGIST_CODE and m.MEMBER_MAIN_GROUP_CODE='300' and m.COMP_PERSON_CODE=c.COMP_PERSON_CODE AND (r.APPROVE_DATE BETWEEN dbo.fnc_StrToDateTime(@YYYYMMDD_FROM + '000000') AND dbo.fnc_StrToDateTime(@YYYYMMDD_TO + '235959')) declare @id int declare @totalRows int = (select count(*) from tempWsGs1_001) declare @currentRow int = 0 declare @BussinessTypeTH VARCHAR(max) declare @BussinessTypeEN VARCHAR(max) while @currentRow < @totalRows begin set @id = @currentRow+1 declare @TAX_ID varchar(max) set @TAX_ID = (select top 1 tax_id from tempWsGs1_001 where id=@id) insert into tempWsGs1_002 select * from fnc_GetGS1MemberInfoForWebServiceByTaxID(@TAX_ID) set @currentRow = @currentRow +1 end drop table tempWsGs1_001 select * from tempWsGs1_002 drop table tempWsGs1_002 15:00:48 16 กุมภาพันธ์ 2561 :There is already an object named 'tempWsGs1_001' in the database. 15:00:48 16 กุมภาพันธ์ 2561 :getGS1changed=/*SELECT MB_MEMBER.MEMBER_CODE, MB_PRENAME.PRENAME_TH, MB_COMP_PERSON.COMP_PERSON_NAME_TH, MB_PRENAME.PRENAME_EN, MB_COMP_PERSON.COMP_PERSON_NAME_EN, MB_COMP_PERSON.TAX_ID, MB_MEMBER.REGIST_DATE, MB_MEMBER.MEMBER_MAIN_TYPE_CODE, MB_MEMBER.MEMBER_TYPE_CODE, MB_MEMBER.MEMBER_STATUS_CODE, MB_MEMBER_RETIRE.APPROVE_DATE FROM MB_MEMBER INNER JOIN MB_COMP_PERSON ON MB_MEMBER.COMP_PERSON_CODE = MB_COMP_PERSON.COMP_PERSON_CODE INNER JOIN MB_MEMBER_RETIRE ON MB_MEMBER.REGIST_CODE = MB_MEMBER_RETIRE.REGIST_CODE LEFT OUTER JOIN MB_PRENAME ON MB_COMP_PERSON.PREN_CODE = MB_PRENAME.PRENAME_CODE WHERE (MB_MEMBER.MEMBER_MAIN_GROUP_CODE = '300') AND (MB_MEMBER_RETIRE.APPROVE_DATE BETWEEN dbo.fnc_StrToDateTime(@YYYYMMDD_FROM + '000000') AND dbo.fnc_StrToDateTime(@YYYYMMDD_TO + '235959')) ORDER BY MB_MEMBER_RETIRE.APPROVE_DATE*/ --declare @YYYYMMDD_FROM varchar(max) = '20171101' --declare @YYYYMMDD_TO varchar(max) = '20171201' create table tempWsGs1_001 ( id int, tax_id varchar(max) ) create table tempWsGs1_002 ( MEMBER_CODE varchar(max) , TAX_ID varchar(max) , BDB_CODE varchar(max) , MEMBER_MAIN_TYPE_CODE varchar(max) , MEMBER_MAIN_TYPE_NAME varchar(max) , MEMBER_TYPE_CODE varchar(max) , MEMBER_TYPE_NAME varchar(max) , BUSSINESS_TYPE_TH varchar(max) , BUSSINESS_TYPE_EN varchar(max) , PRENAME_TH varchar(max) , COMP_PERSON_NAME_TH varchar(max) , PRENAME_EN varchar(max) , COMP_PERSON_NAME_EN varchar(max) , ADDR_TH varchar(max) , ADDR_EN varchar(max) , ZIP_CODE_TH varchar(max) , ZIP_CODE_EN varchar(max) , TELEPHONE_TH varchar(max) , TELEPHONE_EN varchar(max) , EMAIL_TH varchar(max) , EMAIL_EN varchar(max) , STATUS varchar(max) , REGIST_DATE varchar(max) , MEMBER_DATE varchar(max) , UPDATE_DATE varchar(max) , CompanyPrefix varchar(max) ) insert into tempWsGs1_001 select distinct ROW_NUMBER() over (order by r.approve_date) as id, c.TAX_ID as tax_id from MB_MEMBER m,MB_COMP_PERSON c,MB_MEMBER_RETIRE r where r.REGIST_CODE=m.REGIST_CODE and m.MEMBER_MAIN_GROUP_CODE='300' and m.COMP_PERSON_CODE=c.COMP_PERSON_CODE AND (r.APPROVE_DATE BETWEEN dbo.fnc_StrToDateTime(@YYYYMMDD_FROM + '000000') AND dbo.fnc_StrToDateTime(@YYYYMMDD_TO + '235959')) declare @id int declare @totalRows int = (select count(*) from tempWsGs1_001) declare @currentRow int = 0 declare @BussinessTypeTH VARCHAR(max) declare @BussinessTypeEN VARCHAR(max) while @currentRow < @totalRows begin set @id = @currentRow+1 declare @TAX_ID varchar(max) set @TAX_ID = (select top 1 tax_id from tempWsGs1_001 where id=@id) insert into tempWsGs1_002 select * from fnc_GetGS1MemberInfoForWebServiceByTaxID(@TAX_ID) set @currentRow = @currentRow +1 end drop table tempWsGs1_001 select * from tempWsGs1_002 drop table tempWsGs1_002 15:00:48 16 กุมภาพันธ์ 2561 :There is already an object named 'tempWsGs1_001' in the database. 15:04:15 16 กุมภาพันธ์ 2561 :Index was out of range. Must be non-negative and less than the size of the collection. Parameter name: index 15:04:15 16 กุมภาพันธ์ 2561 :try to logon with: GS1WS 15:14:06 16 กุมภาพันธ์ 2561 :Index was out of range. Must be non-negative and less than the size of the collection. Parameter name: index 15:14:06 16 กุมภาพันธ์ 2561 :try to logon with: GS1WS 15:32:02 16 กุมภาพันธ์ 2561 :Server was unable to process request. ---> Cannot open database "RDtmp" requested by the login. The login failed. 15:37:54 16 กุมภาพันธ์ 2561 :Index was out of range. Must be non-negative and less than the size of the collection. Parameter name: index 15:37:54 16 กุมภาพันธ์ 2561 :try to logon with: GS1WS 16:00:53 16 กุมภาพันธ์ 2561 :Index was out of range. Must be non-negative and less than the size of the collection. Parameter name: index 16:00:53 16 กุมภาพันธ์ 2561 :try to logon with: GS1WS 16:00:53 16 กุมภาพันธ์ 2561 :Index was out of range. Must be non-negative and less than the size of the collection. Parameter name: index 16:00:53 16 กุมภาพันธ์ 2561 :try to logon with: GS1WS 16:00:53 16 กุมภาพันธ์ 2561 :getGS1changed=/*SELECT MB_MEMBER.MEMBER_CODE, MB_PRENAME.PRENAME_TH, MB_COMP_PERSON.COMP_PERSON_NAME_TH, MB_PRENAME.PRENAME_EN, MB_COMP_PERSON.COMP_PERSON_NAME_EN, MB_COMP_PERSON.TAX_ID, MB_MEMBER.REGIST_DATE, MB_MEMBER.MEMBER_MAIN_TYPE_CODE, MB_MEMBER.MEMBER_TYPE_CODE, MB_MEMBER.MEMBER_STATUS_CODE, MB_MEMBER_RETIRE.APPROVE_DATE FROM MB_MEMBER INNER JOIN MB_COMP_PERSON ON MB_MEMBER.COMP_PERSON_CODE = MB_COMP_PERSON.COMP_PERSON_CODE INNER JOIN MB_MEMBER_RETIRE ON MB_MEMBER.REGIST_CODE = MB_MEMBER_RETIRE.REGIST_CODE LEFT OUTER JOIN MB_PRENAME ON MB_COMP_PERSON.PREN_CODE = MB_PRENAME.PRENAME_CODE WHERE (MB_MEMBER.MEMBER_MAIN_GROUP_CODE = '300') AND (MB_MEMBER_RETIRE.APPROVE_DATE BETWEEN dbo.fnc_StrToDateTime(@YYYYMMDD_FROM + '000000') AND dbo.fnc_StrToDateTime(@YYYYMMDD_TO + '235959')) ORDER BY MB_MEMBER_RETIRE.APPROVE_DATE*/ --declare @YYYYMMDD_FROM varchar(max) = '20171101' --declare @YYYYMMDD_TO varchar(max) = '20171201' create table tempWsGs1_001 ( id int, tax_id varchar(max) ) create table tempWsGs1_002 ( MEMBER_CODE varchar(max) , TAX_ID varchar(max) , BDB_CODE varchar(max) , MEMBER_MAIN_TYPE_CODE varchar(max) , MEMBER_MAIN_TYPE_NAME varchar(max) , MEMBER_TYPE_CODE varchar(max) , MEMBER_TYPE_NAME varchar(max) , BUSSINESS_TYPE_TH varchar(max) , BUSSINESS_TYPE_EN varchar(max) , PRENAME_TH varchar(max) , COMP_PERSON_NAME_TH varchar(max) , PRENAME_EN varchar(max) , COMP_PERSON_NAME_EN varchar(max) , ADDR_TH varchar(max) , ADDR_EN varchar(max) , ZIP_CODE_TH varchar(max) , ZIP_CODE_EN varchar(max) , TELEPHONE_TH varchar(max) , TELEPHONE_EN varchar(max) , EMAIL_TH varchar(max) , EMAIL_EN varchar(max) , STATUS varchar(max) , REGIST_DATE varchar(max) , MEMBER_DATE varchar(max) , UPDATE_DATE varchar(max) , CompanyPrefix varchar(max) ) insert into tempWsGs1_001 select distinct ROW_NUMBER() over (order by r.approve_date) as id, c.TAX_ID as tax_id from MB_MEMBER m,MB_COMP_PERSON c,MB_MEMBER_RETIRE r where r.REGIST_CODE=m.REGIST_CODE and m.MEMBER_MAIN_GROUP_CODE='300' and m.COMP_PERSON_CODE=c.COMP_PERSON_CODE AND (r.APPROVE_DATE BETWEEN dbo.fnc_StrToDateTime(@YYYYMMDD_FROM + '000000') AND dbo.fnc_StrToDateTime(@YYYYMMDD_TO + '235959')) declare @id int declare @totalRows int = (select count(*) from tempWsGs1_001) declare @currentRow int = 0 declare @BussinessTypeTH VARCHAR(max) declare @BussinessTypeEN VARCHAR(max) while @currentRow < @totalRows begin set @id = @currentRow+1 declare @TAX_ID varchar(max) set @TAX_ID = (select top 1 tax_id from tempWsGs1_001 where id=@id) insert into tempWsGs1_002 select * from fnc_GetGS1MemberInfoForWebServiceByTaxID(@TAX_ID) set @currentRow = @currentRow +1 end drop table tempWsGs1_001 select * from tempWsGs1_002 drop table tempWsGs1_002 16:00:53 16 กุมภาพันธ์ 2561 :There is already an object named 'tempWsGs1_001' in the database. 16:00:53 16 กุมภาพันธ์ 2561 :getGS1changed=/*SELECT MB_MEMBER.MEMBER_CODE, MB_PRENAME.PRENAME_TH, MB_COMP_PERSON.COMP_PERSON_NAME_TH, MB_PRENAME.PRENAME_EN, MB_COMP_PERSON.COMP_PERSON_NAME_EN, MB_COMP_PERSON.TAX_ID, MB_MEMBER.REGIST_DATE, MB_MEMBER.MEMBER_MAIN_TYPE_CODE, MB_MEMBER.MEMBER_TYPE_CODE, MB_MEMBER.MEMBER_STATUS_CODE, MB_MEMBER_RETIRE.APPROVE_DATE FROM MB_MEMBER INNER JOIN MB_COMP_PERSON ON MB_MEMBER.COMP_PERSON_CODE = MB_COMP_PERSON.COMP_PERSON_CODE INNER JOIN MB_MEMBER_RETIRE ON MB_MEMBER.REGIST_CODE = MB_MEMBER_RETIRE.REGIST_CODE LEFT OUTER JOIN MB_PRENAME ON MB_COMP_PERSON.PREN_CODE = MB_PRENAME.PRENAME_CODE WHERE (MB_MEMBER.MEMBER_MAIN_GROUP_CODE = '300') AND (MB_MEMBER_RETIRE.APPROVE_DATE BETWEEN dbo.fnc_StrToDateTime(@YYYYMMDD_FROM + '000000') AND dbo.fnc_StrToDateTime(@YYYYMMDD_TO + '235959')) ORDER BY MB_MEMBER_RETIRE.APPROVE_DATE*/ --declare @YYYYMMDD_FROM varchar(max) = '20171101' --declare @YYYYMMDD_TO varchar(max) = '20171201' create table tempWsGs1_001 ( id int, tax_id varchar(max) ) create table tempWsGs1_002 ( MEMBER_CODE varchar(max) , TAX_ID varchar(max) , BDB_CODE varchar(max) , MEMBER_MAIN_TYPE_CODE varchar(max) , MEMBER_MAIN_TYPE_NAME varchar(max) , MEMBER_TYPE_CODE varchar(max) , MEMBER_TYPE_NAME varchar(max) , BUSSINESS_TYPE_TH varchar(max) , BUSSINESS_TYPE_EN varchar(max) , PRENAME_TH varchar(max) , COMP_PERSON_NAME_TH varchar(max) , PRENAME_EN varchar(max) , COMP_PERSON_NAME_EN varchar(max) , ADDR_TH varchar(max) , ADDR_EN varchar(max) , ZIP_CODE_TH varchar(max) , ZIP_CODE_EN varchar(max) , TELEPHONE_TH varchar(max) , TELEPHONE_EN varchar(max) , EMAIL_TH varchar(max) , EMAIL_EN varchar(max) , STATUS varchar(max) , REGIST_DATE varchar(max) , MEMBER_DATE varchar(max) , UPDATE_DATE varchar(max) , CompanyPrefix varchar(max) ) insert into tempWsGs1_001 select distinct ROW_NUMBER() over (order by r.approve_date) as id, c.TAX_ID as tax_id from MB_MEMBER m,MB_COMP_PERSON c,MB_MEMBER_RETIRE r where r.REGIST_CODE=m.REGIST_CODE and m.MEMBER_MAIN_GROUP_CODE='300' and m.COMP_PERSON_CODE=c.COMP_PERSON_CODE AND (r.APPROVE_DATE BETWEEN dbo.fnc_StrToDateTime(@YYYYMMDD_FROM + '000000') AND dbo.fnc_StrToDateTime(@YYYYMMDD_TO + '235959')) declare @id int declare @totalRows int = (select count(*) from tempWsGs1_001) declare @currentRow int = 0 declare @BussinessTypeTH VARCHAR(max) declare @BussinessTypeEN VARCHAR(max) while @currentRow < @totalRows begin set @id = @currentRow+1 declare @TAX_ID varchar(max) set @TAX_ID = (select top 1 tax_id from tempWsGs1_001 where id=@id) insert into tempWsGs1_002 select * from fnc_GetGS1MemberInfoForWebServiceByTaxID(@TAX_ID) set @currentRow = @currentRow +1 end drop table tempWsGs1_001 select * from tempWsGs1_002 drop table tempWsGs1_002 16:00:53 16 กุมภาพันธ์ 2561 :There is already an object named 'tempWsGs1_001' in the database. 16:04:12 16 กุมภาพันธ์ 2561 :Index was out of range. Must be non-negative and less than the size of the collection. Parameter name: index 16:04:12 16 กุมภาพันธ์ 2561 :try to logon with: GS1WS 16:13:21 16 กุมภาพันธ์ 2561 : INSERT INTO FIN_RC_BANK_RECONCILE ([BR_NO],[BANK_CODE],[BRANCH_CODE],[REF_TRANSFER_SEQ],[TRANSFER_DATE],[TRANSFER_YEAR],[TRANSFER_MONTH],[SUM_AMT],[BAL_AMT],[TRAN_NO],[TRAN_DATE],[IS_DELETE],[CANCLE_BY],[CANCLE_DATE],[REMARK],[ACCOUNT_NUM_FTI],[CODE],[STAFF_ID],[COMP_PERSON_NAME_TH],[REMARK_REPORT],[CR_BY],[CR_DATE],[UPD_BY],[UPD_DATE],[IS_BILL_PAYMENT],[CHEQUE_AMT]) VALUES( @brNo,@bankCode,@branchCode,@seq,@transferDate,@transferYear,@transferMonth,@sumTotal,@balAmt,NULL,NULL,@isDelete,@cancleBy,GETDATE(),@remark,@accountNumFti,@code,@staffId,NULL,@remarkReport,@crBy,GETDATE(),@updBy,GETDATE(),@isBillPayment,@Cheque ); 16:13:21 16 กุมภาพันธ์ 2561 :Violation of PRIMARY KEY constraint 'PK_FIN_RC_BANK_RECONCILE'. Cannot insert duplicate key in object 'dbo.FIN_RC_BANK_RECONCILE'. The duplicate key value is (451000037161011). The statement has been terminated. 16:28:47 16 กุมภาพันธ์ 2561 :Index was out of range. Must be non-negative and less than the size of the collection. Parameter name: index 16:28:47 16 กุมภาพันธ์ 2561 :try to logon with: GS1WS 16:39:17 16 กุมภาพันธ์ 2561 :Index was out of range. Must be non-negative and less than the size of the collection. Parameter name: index 16:39:17 16 กุมภาพันธ์ 2561 :try to logon with: GS1WS 16:46:18 16 กุมภาพันธ์ 2561 :Index was out of range. Must be non-negative and less than the size of the collection. Parameter name: index 16:46:18 16 กุมภาพันธ์ 2561 :try to logon with: GS1WS 17:00:48 16 กุมภาพันธ์ 2561 :Index was out of range. Must be non-negative and less than the size of the collection. Parameter name: index 17:00:48 16 กุมภาพันธ์ 2561 :try to logon with: GS1WS 17:00:48 16 กุมภาพันธ์ 2561 :getGS1changed=/*SELECT MB_MEMBER.MEMBER_CODE, MB_PRENAME.PRENAME_TH, MB_COMP_PERSON.COMP_PERSON_NAME_TH, MB_PRENAME.PRENAME_EN, MB_COMP_PERSON.COMP_PERSON_NAME_EN, MB_COMP_PERSON.TAX_ID, MB_MEMBER.REGIST_DATE, MB_MEMBER.MEMBER_MAIN_TYPE_CODE, MB_MEMBER.MEMBER_TYPE_CODE, MB_MEMBER.MEMBER_STATUS_CODE, MB_MEMBER_RETIRE.APPROVE_DATE FROM MB_MEMBER INNER JOIN MB_COMP_PERSON ON MB_MEMBER.COMP_PERSON_CODE = MB_COMP_PERSON.COMP_PERSON_CODE INNER JOIN MB_MEMBER_RETIRE ON MB_MEMBER.REGIST_CODE = MB_MEMBER_RETIRE.REGIST_CODE LEFT OUTER JOIN MB_PRENAME ON MB_COMP_PERSON.PREN_CODE = MB_PRENAME.PRENAME_CODE WHERE (MB_MEMBER.MEMBER_MAIN_GROUP_CODE = '300') AND (MB_MEMBER_RETIRE.APPROVE_DATE BETWEEN dbo.fnc_StrToDateTime(@YYYYMMDD_FROM + '000000') AND dbo.fnc_StrToDateTime(@YYYYMMDD_TO + '235959')) ORDER BY MB_MEMBER_RETIRE.APPROVE_DATE*/ --declare @YYYYMMDD_FROM varchar(max) = '20171101' --declare @YYYYMMDD_TO varchar(max) = '20171201' create table tempWsGs1_001 ( id int, tax_id varchar(max) ) create table tempWsGs1_002 ( MEMBER_CODE varchar(max) , TAX_ID varchar(max) , BDB_CODE varchar(max) , MEMBER_MAIN_TYPE_CODE varchar(max) , MEMBER_MAIN_TYPE_NAME varchar(max) , MEMBER_TYPE_CODE varchar(max) , MEMBER_TYPE_NAME varchar(max) , BUSSINESS_TYPE_TH varchar(max) , BUSSINESS_TYPE_EN varchar(max) , PRENAME_TH varchar(max) , COMP_PERSON_NAME_TH varchar(max) , PRENAME_EN varchar(max) , COMP_PERSON_NAME_EN varchar(max) , ADDR_TH varchar(max) , ADDR_EN varchar(max) , ZIP_CODE_TH varchar(max) , ZIP_CODE_EN varchar(max) , TELEPHONE_TH varchar(max) , TELEPHONE_EN varchar(max) , EMAIL_TH varchar(max) , EMAIL_EN varchar(max) , STATUS varchar(max) , REGIST_DATE varchar(max) , MEMBER_DATE varchar(max) , UPDATE_DATE varchar(max) , CompanyPrefix varchar(max) ) insert into tempWsGs1_001 select distinct ROW_NUMBER() over (order by r.approve_date) as id, c.TAX_ID as tax_id from MB_MEMBER m,MB_COMP_PERSON c,MB_MEMBER_RETIRE r where r.REGIST_CODE=m.REGIST_CODE and m.MEMBER_MAIN_GROUP_CODE='300' and m.COMP_PERSON_CODE=c.COMP_PERSON_CODE AND (r.APPROVE_DATE BETWEEN dbo.fnc_StrToDateTime(@YYYYMMDD_FROM + '000000') AND dbo.fnc_StrToDateTime(@YYYYMMDD_TO + '235959')) declare @id int declare @totalRows int = (select count(*) from tempWsGs1_001) declare @currentRow int = 0 declare @BussinessTypeTH VARCHAR(max) declare @BussinessTypeEN VARCHAR(max) while @currentRow < @totalRows begin set @id = @currentRow+1 declare @TAX_ID varchar(max) set @TAX_ID = (select top 1 tax_id from tempWsGs1_001 where id=@id) insert into tempWsGs1_002 select * from fnc_GetGS1MemberInfoForWebServiceByTaxID(@TAX_ID) set @currentRow = @currentRow +1 end drop table tempWsGs1_001 select * from tempWsGs1_002 drop table tempWsGs1_002 17:00:48 16 กุมภาพันธ์ 2561 :There is already an object named 'tempWsGs1_001' in the database. 17:00:51 16 กุมภาพันธ์ 2561 :Index was out of range. Must be non-negative and less than the size of the collection. Parameter name: index 17:00:51 16 กุมภาพันธ์ 2561 :try to logon with: GS1WS 17:00:51 16 กุมภาพันธ์ 2561 :getGS1changed=/*SELECT MB_MEMBER.MEMBER_CODE, MB_PRENAME.PRENAME_TH, MB_COMP_PERSON.COMP_PERSON_NAME_TH, MB_PRENAME.PRENAME_EN, MB_COMP_PERSON.COMP_PERSON_NAME_EN, MB_COMP_PERSON.TAX_ID, MB_MEMBER.REGIST_DATE, MB_MEMBER.MEMBER_MAIN_TYPE_CODE, MB_MEMBER.MEMBER_TYPE_CODE, MB_MEMBER.MEMBER_STATUS_CODE, MB_MEMBER_RETIRE.APPROVE_DATE FROM MB_MEMBER INNER JOIN MB_COMP_PERSON ON MB_MEMBER.COMP_PERSON_CODE = MB_COMP_PERSON.COMP_PERSON_CODE INNER JOIN MB_MEMBER_RETIRE ON MB_MEMBER.REGIST_CODE = MB_MEMBER_RETIRE.REGIST_CODE LEFT OUTER JOIN MB_PRENAME ON MB_COMP_PERSON.PREN_CODE = MB_PRENAME.PRENAME_CODE WHERE (MB_MEMBER.MEMBER_MAIN_GROUP_CODE = '300') AND (MB_MEMBER_RETIRE.APPROVE_DATE BETWEEN dbo.fnc_StrToDateTime(@YYYYMMDD_FROM + '000000') AND dbo.fnc_StrToDateTime(@YYYYMMDD_TO + '235959')) ORDER BY MB_MEMBER_RETIRE.APPROVE_DATE*/ --declare @YYYYMMDD_FROM varchar(max) = '20171101' --declare @YYYYMMDD_TO varchar(max) = '20171201' create table tempWsGs1_001 ( id int, tax_id varchar(max) ) create table tempWsGs1_002 ( MEMBER_CODE varchar(max) , TAX_ID varchar(max) , BDB_CODE varchar(max) , MEMBER_MAIN_TYPE_CODE varchar(max) , MEMBER_MAIN_TYPE_NAME varchar(max) , MEMBER_TYPE_CODE varchar(max) , MEMBER_TYPE_NAME varchar(max) , BUSSINESS_TYPE_TH varchar(max) , BUSSINESS_TYPE_EN varchar(max) , PRENAME_TH varchar(max) , COMP_PERSON_NAME_TH varchar(max) , PRENAME_EN varchar(max) , COMP_PERSON_NAME_EN varchar(max) , ADDR_TH varchar(max) , ADDR_EN varchar(max) , ZIP_CODE_TH varchar(max) , ZIP_CODE_EN varchar(max) , TELEPHONE_TH varchar(max) , TELEPHONE_EN varchar(max) , EMAIL_TH varchar(max) , EMAIL_EN varchar(max) , STATUS varchar(max) , REGIST_DATE varchar(max) , MEMBER_DATE varchar(max) , UPDATE_DATE varchar(max) , CompanyPrefix varchar(max) ) insert into tempWsGs1_001 select distinct ROW_NUMBER() over (order by r.approve_date) as id, c.TAX_ID as tax_id from MB_MEMBER m,MB_COMP_PERSON c,MB_MEMBER_RETIRE r where r.REGIST_CODE=m.REGIST_CODE and m.MEMBER_MAIN_GROUP_CODE='300' and m.COMP_PERSON_CODE=c.COMP_PERSON_CODE AND (r.APPROVE_DATE BETWEEN dbo.fnc_StrToDateTime(@YYYYMMDD_FROM + '000000') AND dbo.fnc_StrToDateTime(@YYYYMMDD_TO + '235959')) declare @id int declare @totalRows int = (select count(*) from tempWsGs1_001) declare @currentRow int = 0 declare @BussinessTypeTH VARCHAR(max) declare @BussinessTypeEN VARCHAR(max) while @currentRow < @totalRows begin set @id = @currentRow+1 declare @TAX_ID varchar(max) set @TAX_ID = (select top 1 tax_id from tempWsGs1_001 where id=@id) insert into tempWsGs1_002 select * from fnc_GetGS1MemberInfoForWebServiceByTaxID(@TAX_ID) set @currentRow = @currentRow +1 end drop table tempWsGs1_001 select * from tempWsGs1_002 drop table tempWsGs1_002 17:00:51 16 กุมภาพันธ์ 2561 :There is already an object named 'tempWsGs1_001' in the database. 17:04:59 16 กุมภาพันธ์ 2561 :Index was out of range. Must be non-negative and less than the size of the collection. Parameter name: index 17:04:59 16 กุมภาพันธ์ 2561 :try to logon with: GS1WS 17:13:46 16 กุมภาพันธ์ 2561 :Server was unable to process request. ---> Cannot open database "RDtmp" requested by the login. The login failed. 18:00:49 16 กุมภาพันธ์ 2561 :Index was out of range. Must be non-negative and less than the size of the collection. Parameter name: index 18:00:49 16 กุมภาพันธ์ 2561 :try to logon with: GS1WS 18:00:49 16 กุมภาพันธ์ 2561 :Index was out of range. Must be non-negative and less than the size of the collection. Parameter name: index 18:00:49 16 กุมภาพันธ์ 2561 :getGS1changed=/*SELECT MB_MEMBER.MEMBER_CODE, MB_PRENAME.PRENAME_TH, MB_COMP_PERSON.COMP_PERSON_NAME_TH, MB_PRENAME.PRENAME_EN, MB_COMP_PERSON.COMP_PERSON_NAME_EN, MB_COMP_PERSON.TAX_ID, MB_MEMBER.REGIST_DATE, MB_MEMBER.MEMBER_MAIN_TYPE_CODE, MB_MEMBER.MEMBER_TYPE_CODE, MB_MEMBER.MEMBER_STATUS_CODE, MB_MEMBER_RETIRE.APPROVE_DATE FROM MB_MEMBER INNER JOIN MB_COMP_PERSON ON MB_MEMBER.COMP_PERSON_CODE = MB_COMP_PERSON.COMP_PERSON_CODE INNER JOIN MB_MEMBER_RETIRE ON MB_MEMBER.REGIST_CODE = MB_MEMBER_RETIRE.REGIST_CODE LEFT OUTER JOIN MB_PRENAME ON MB_COMP_PERSON.PREN_CODE = MB_PRENAME.PRENAME_CODE WHERE (MB_MEMBER.MEMBER_MAIN_GROUP_CODE = '300') AND (MB_MEMBER_RETIRE.APPROVE_DATE BETWEEN dbo.fnc_StrToDateTime(@YYYYMMDD_FROM + '000000') AND dbo.fnc_StrToDateTime(@YYYYMMDD_TO + '235959')) ORDER BY MB_MEMBER_RETIRE.APPROVE_DATE*/ --declare @YYYYMMDD_FROM varchar(max) = '20171101' --declare @YYYYMMDD_TO varchar(max) = '20171201' create table tempWsGs1_001 ( id int, tax_id varchar(max) ) create table tempWsGs1_002 ( MEMBER_CODE varchar(max) , TAX_ID varchar(max) , BDB_CODE varchar(max) , MEMBER_MAIN_TYPE_CODE varchar(max) , MEMBER_MAIN_TYPE_NAME varchar(max) , MEMBER_TYPE_CODE varchar(max) , MEMBER_TYPE_NAME varchar(max) , BUSSINESS_TYPE_TH varchar(max) , BUSSINESS_TYPE_EN varchar(max) , PRENAME_TH varchar(max) , COMP_PERSON_NAME_TH varchar(max) , PRENAME_EN varchar(max) , COMP_PERSON_NAME_EN varchar(max) , ADDR_TH varchar(max) , ADDR_EN varchar(max) , ZIP_CODE_TH varchar(max) , ZIP_CODE_EN varchar(max) , TELEPHONE_TH varchar(max) , TELEPHONE_EN varchar(max) , EMAIL_TH varchar(max) , EMAIL_EN varchar(max) , STATUS varchar(max) , REGIST_DATE varchar(max) , MEMBER_DATE varchar(max) , UPDATE_DATE varchar(max) , CompanyPrefix varchar(max) ) insert into tempWsGs1_001 select distinct ROW_NUMBER() over (order by r.approve_date) as id, c.TAX_ID as tax_id from MB_MEMBER m,MB_COMP_PERSON c,MB_MEMBER_RETIRE r where r.REGIST_CODE=m.REGIST_CODE and m.MEMBER_MAIN_GROUP_CODE='300' and m.COMP_PERSON_CODE=c.COMP_PERSON_CODE AND (r.APPROVE_DATE BETWEEN dbo.fnc_StrToDateTime(@YYYYMMDD_FROM + '000000') AND dbo.fnc_StrToDateTime(@YYYYMMDD_TO + '235959')) declare @id int declare @totalRows int = (select count(*) from tempWsGs1_001) declare @currentRow int = 0 declare @BussinessTypeTH VARCHAR(max) declare @BussinessTypeEN VARCHAR(max) while @currentRow < @totalRows begin set @id = @currentRow+1 declare @TAX_ID varchar(max) set @TAX_ID = (select top 1 tax_id from tempWsGs1_001 where id=@id) insert into tempWsGs1_002 select * from fnc_GetGS1MemberInfoForWebServiceByTaxID(@TAX_ID) set @currentRow = @currentRow +1 end drop table tempWsGs1_001 select * from tempWsGs1_002 drop table tempWsGs1_002 18:00:49 16 กุมภาพันธ์ 2561 :There is already an object named 'tempWsGs1_001' in the database. 18:00:49 16 กุมภาพันธ์ 2561 :try to logon with: GS1WS 18:00:49 16 กุมภาพันธ์ 2561 :getGS1changed=/*SELECT MB_MEMBER.MEMBER_CODE, MB_PRENAME.PRENAME_TH, MB_COMP_PERSON.COMP_PERSON_NAME_TH, MB_PRENAME.PRENAME_EN, MB_COMP_PERSON.COMP_PERSON_NAME_EN, MB_COMP_PERSON.TAX_ID, MB_MEMBER.REGIST_DATE, MB_MEMBER.MEMBER_MAIN_TYPE_CODE, MB_MEMBER.MEMBER_TYPE_CODE, MB_MEMBER.MEMBER_STATUS_CODE, MB_MEMBER_RETIRE.APPROVE_DATE FROM MB_MEMBER INNER JOIN MB_COMP_PERSON ON MB_MEMBER.COMP_PERSON_CODE = MB_COMP_PERSON.COMP_PERSON_CODE INNER JOIN MB_MEMBER_RETIRE ON MB_MEMBER.REGIST_CODE = MB_MEMBER_RETIRE.REGIST_CODE LEFT OUTER JOIN MB_PRENAME ON MB_COMP_PERSON.PREN_CODE = MB_PRENAME.PRENAME_CODE WHERE (MB_MEMBER.MEMBER_MAIN_GROUP_CODE = '300') AND (MB_MEMBER_RETIRE.APPROVE_DATE BETWEEN dbo.fnc_StrToDateTime(@YYYYMMDD_FROM + '000000') AND dbo.fnc_StrToDateTime(@YYYYMMDD_TO + '235959')) ORDER BY MB_MEMBER_RETIRE.APPROVE_DATE*/ --declare @YYYYMMDD_FROM varchar(max) = '20171101' --declare @YYYYMMDD_TO varchar(max) = '20171201' create table tempWsGs1_001 ( id int, tax_id varchar(max) ) create table tempWsGs1_002 ( MEMBER_CODE varchar(max) , TAX_ID varchar(max) , BDB_CODE varchar(max) , MEMBER_MAIN_TYPE_CODE varchar(max) , MEMBER_MAIN_TYPE_NAME varchar(max) , MEMBER_TYPE_CODE varchar(max) , MEMBER_TYPE_NAME varchar(max) , BUSSINESS_TYPE_TH varchar(max) , BUSSINESS_TYPE_EN varchar(max) , PRENAME_TH varchar(max) , COMP_PERSON_NAME_TH varchar(max) , PRENAME_EN varchar(max) , COMP_PERSON_NAME_EN varchar(max) , ADDR_TH varchar(max) , ADDR_EN varchar(max) , ZIP_CODE_TH varchar(max) , ZIP_CODE_EN varchar(max) , TELEPHONE_TH varchar(max) , TELEPHONE_EN varchar(max) , EMAIL_TH varchar(max) , EMAIL_EN varchar(max) , STATUS varchar(max) , REGIST_DATE varchar(max) , MEMBER_DATE varchar(max) , UPDATE_DATE varchar(max) , CompanyPrefix varchar(max) ) insert into tempWsGs1_001 select distinct ROW_NUMBER() over (order by r.approve_date) as id, c.TAX_ID as tax_id from MB_MEMBER m,MB_COMP_PERSON c,MB_MEMBER_RETIRE r where r.REGIST_CODE=m.REGIST_CODE and m.MEMBER_MAIN_GROUP_CODE='300' and m.COMP_PERSON_CODE=c.COMP_PERSON_CODE AND (r.APPROVE_DATE BETWEEN dbo.fnc_StrToDateTime(@YYYYMMDD_FROM + '000000') AND dbo.fnc_StrToDateTime(@YYYYMMDD_TO + '235959')) declare @id int declare @totalRows int = (select count(*) from tempWsGs1_001) declare @currentRow int = 0 declare @BussinessTypeTH VARCHAR(max) declare @BussinessTypeEN VARCHAR(max) while @currentRow < @totalRows begin set @id = @currentRow+1 declare @TAX_ID varchar(max) set @TAX_ID = (select top 1 tax_id from tempWsGs1_001 where id=@id) insert into tempWsGs1_002 select * from fnc_GetGS1MemberInfoForWebServiceByTaxID(@TAX_ID) set @currentRow = @currentRow +1 end drop table tempWsGs1_001 select * from tempWsGs1_002 drop table tempWsGs1_002 18:00:49 16 กุมภาพันธ์ 2561 :There is already an object named 'tempWsGs1_001' in the database. 18:04:11 16 กุมภาพันธ์ 2561 :Server was unable to process request. ---> Cannot open database "RDtmp" requested by the login. The login failed. 18:08:41 16 กุมภาพันธ์ 2561 :Server was unable to process request. ---> Cannot open database "RDtmp" requested by the login. The login failed. 18:13:02 16 กุมภาพันธ์ 2561 :There was no endpoint listening at https://rdws.rd.go.th/serviceRD3/vatserviceRD3.asmx that could accept the message. This is often caused by an incorrect address or SOAP action. See InnerException, if present, for more details. 18:25:39 16 กุมภาพันธ์ 2561 :Server was unable to process request. ---> Cannot open database "RDtmp" requested by the login. The login failed. 18:36:22 16 กุมภาพันธ์ 2561 :Server was unable to process request. ---> Cannot open database "RDtmp" requested by the login. The login failed. 19:00:51 16 กุมภาพันธ์ 2561 :Index was out of range. Must be non-negative and less than the size of the collection. Parameter name: index 19:00:51 16 กุมภาพันธ์ 2561 :try to logon with: GS1WS 19:00:51 16 กุมภาพันธ์ 2561 :getGS1changed=/*SELECT MB_MEMBER.MEMBER_CODE, MB_PRENAME.PRENAME_TH, MB_COMP_PERSON.COMP_PERSON_NAME_TH, MB_PRENAME.PRENAME_EN, MB_COMP_PERSON.COMP_PERSON_NAME_EN, MB_COMP_PERSON.TAX_ID, MB_MEMBER.REGIST_DATE, MB_MEMBER.MEMBER_MAIN_TYPE_CODE, MB_MEMBER.MEMBER_TYPE_CODE, MB_MEMBER.MEMBER_STATUS_CODE, MB_MEMBER_RETIRE.APPROVE_DATE FROM MB_MEMBER INNER JOIN MB_COMP_PERSON ON MB_MEMBER.COMP_PERSON_CODE = MB_COMP_PERSON.COMP_PERSON_CODE INNER JOIN MB_MEMBER_RETIRE ON MB_MEMBER.REGIST_CODE = MB_MEMBER_RETIRE.REGIST_CODE LEFT OUTER JOIN MB_PRENAME ON MB_COMP_PERSON.PREN_CODE = MB_PRENAME.PRENAME_CODE WHERE (MB_MEMBER.MEMBER_MAIN_GROUP_CODE = '300') AND (MB_MEMBER_RETIRE.APPROVE_DATE BETWEEN dbo.fnc_StrToDateTime(@YYYYMMDD_FROM + '000000') AND dbo.fnc_StrToDateTime(@YYYYMMDD_TO + '235959')) ORDER BY MB_MEMBER_RETIRE.APPROVE_DATE*/ --declare @YYYYMMDD_FROM varchar(max) = '20171101' --declare @YYYYMMDD_TO varchar(max) = '20171201' create table tempWsGs1_001 ( id int, tax_id varchar(max) ) create table tempWsGs1_002 ( MEMBER_CODE varchar(max) , TAX_ID varchar(max) , BDB_CODE varchar(max) , MEMBER_MAIN_TYPE_CODE varchar(max) , MEMBER_MAIN_TYPE_NAME varchar(max) , MEMBER_TYPE_CODE varchar(max) , MEMBER_TYPE_NAME varchar(max) , BUSSINESS_TYPE_TH varchar(max) , BUSSINESS_TYPE_EN varchar(max) , PRENAME_TH varchar(max) , COMP_PERSON_NAME_TH varchar(max) , PRENAME_EN varchar(max) , COMP_PERSON_NAME_EN varchar(max) , ADDR_TH varchar(max) , ADDR_EN varchar(max) , ZIP_CODE_TH varchar(max) , ZIP_CODE_EN varchar(max) , TELEPHONE_TH varchar(max) , TELEPHONE_EN varchar(max) , EMAIL_TH varchar(max) , EMAIL_EN varchar(max) , STATUS varchar(max) , REGIST_DATE varchar(max) , MEMBER_DATE varchar(max) , UPDATE_DATE varchar(max) , CompanyPrefix varchar(max) ) insert into tempWsGs1_001 select distinct ROW_NUMBER() over (order by r.approve_date) as id, c.TAX_ID as tax_id from MB_MEMBER m,MB_COMP_PERSON c,MB_MEMBER_RETIRE r where r.REGIST_CODE=m.REGIST_CODE and m.MEMBER_MAIN_GROUP_CODE='300' and m.COMP_PERSON_CODE=c.COMP_PERSON_CODE AND (r.APPROVE_DATE BETWEEN dbo.fnc_StrToDateTime(@YYYYMMDD_FROM + '000000') AND dbo.fnc_StrToDateTime(@YYYYMMDD_TO + '235959')) declare @id int declare @totalRows int = (select count(*) from tempWsGs1_001) declare @currentRow int = 0 declare @BussinessTypeTH VARCHAR(max) declare @BussinessTypeEN VARCHAR(max) while @currentRow < @totalRows begin set @id = @currentRow+1 declare @TAX_ID varchar(max) set @TAX_ID = (select top 1 tax_id from tempWsGs1_001 where id=@id) insert into tempWsGs1_002 select * from fnc_GetGS1MemberInfoForWebServiceByTaxID(@TAX_ID) set @currentRow = @currentRow +1 end drop table tempWsGs1_001 select * from tempWsGs1_002 drop table tempWsGs1_002 19:00:51 16 กุมภาพันธ์ 2561 :There is already an object named 'tempWsGs1_001' in the database. 19:06:46 16 กุมภาพันธ์ 2561 :Server was unable to process request. ---> Cannot open database "RDtmp" requested by the login. The login failed. 19:29:21 16 กุมภาพันธ์ 2561 :Server was unable to process request. ---> Cannot open database "RDtmp" requested by the login. The login failed. 20:00:48 16 กุมภาพันธ์ 2561 :Index was out of range. Must be non-negative and less than the size of the collection. Parameter name: index 20:00:48 16 กุมภาพันธ์ 2561 :try to logon with: GS1WS 20:00:48 16 กุมภาพันธ์ 2561 :getGS1changed=/*SELECT MB_MEMBER.MEMBER_CODE, MB_PRENAME.PRENAME_TH, MB_COMP_PERSON.COMP_PERSON_NAME_TH, MB_PRENAME.PRENAME_EN, MB_COMP_PERSON.COMP_PERSON_NAME_EN, MB_COMP_PERSON.TAX_ID, MB_MEMBER.REGIST_DATE, MB_MEMBER.MEMBER_MAIN_TYPE_CODE, MB_MEMBER.MEMBER_TYPE_CODE, MB_MEMBER.MEMBER_STATUS_CODE, MB_MEMBER_RETIRE.APPROVE_DATE FROM MB_MEMBER INNER JOIN MB_COMP_PERSON ON MB_MEMBER.COMP_PERSON_CODE = MB_COMP_PERSON.COMP_PERSON_CODE INNER JOIN MB_MEMBER_RETIRE ON MB_MEMBER.REGIST_CODE = MB_MEMBER_RETIRE.REGIST_CODE LEFT OUTER JOIN MB_PRENAME ON MB_COMP_PERSON.PREN_CODE = MB_PRENAME.PRENAME_CODE WHERE (MB_MEMBER.MEMBER_MAIN_GROUP_CODE = '300') AND (MB_MEMBER_RETIRE.APPROVE_DATE BETWEEN dbo.fnc_StrToDateTime(@YYYYMMDD_FROM + '000000') AND dbo.fnc_StrToDateTime(@YYYYMMDD_TO + '235959')) ORDER BY MB_MEMBER_RETIRE.APPROVE_DATE*/ --declare @YYYYMMDD_FROM varchar(max) = '20171101' --declare @YYYYMMDD_TO varchar(max) = '20171201' create table tempWsGs1_001 ( id int, tax_id varchar(max) ) create table tempWsGs1_002 ( MEMBER_CODE varchar(max) , TAX_ID varchar(max) , BDB_CODE varchar(max) , MEMBER_MAIN_TYPE_CODE varchar(max) , MEMBER_MAIN_TYPE_NAME varchar(max) , MEMBER_TYPE_CODE varchar(max) , MEMBER_TYPE_NAME varchar(max) , BUSSINESS_TYPE_TH varchar(max) , BUSSINESS_TYPE_EN varchar(max) , PRENAME_TH varchar(max) , COMP_PERSON_NAME_TH varchar(max) , PRENAME_EN varchar(max) , COMP_PERSON_NAME_EN varchar(max) , ADDR_TH varchar(max) , ADDR_EN varchar(max) , ZIP_CODE_TH varchar(max) , ZIP_CODE_EN varchar(max) , TELEPHONE_TH varchar(max) , TELEPHONE_EN varchar(max) , EMAIL_TH varchar(max) , EMAIL_EN varchar(max) , STATUS varchar(max) , REGIST_DATE varchar(max) , MEMBER_DATE varchar(max) , UPDATE_DATE varchar(max) , CompanyPrefix varchar(max) ) insert into tempWsGs1_001 select distinct ROW_NUMBER() over (order by r.approve_date) as id, c.TAX_ID as tax_id from MB_MEMBER m,MB_COMP_PERSON c,MB_MEMBER_RETIRE r where r.REGIST_CODE=m.REGIST_CODE and m.MEMBER_MAIN_GROUP_CODE='300' and m.COMP_PERSON_CODE=c.COMP_PERSON_CODE AND (r.APPROVE_DATE BETWEEN dbo.fnc_StrToDateTime(@YYYYMMDD_FROM + '000000') AND dbo.fnc_StrToDateTime(@YYYYMMDD_TO + '235959')) declare @id int declare @totalRows int = (select count(*) from tempWsGs1_001) declare @currentRow int = 0 declare @BussinessTypeTH VARCHAR(max) declare @BussinessTypeEN VARCHAR(max) while @currentRow < @totalRows begin set @id = @currentRow+1 declare @TAX_ID varchar(max) set @TAX_ID = (select top 1 tax_id from tempWsGs1_001 where id=@id) insert into tempWsGs1_002 select * from fnc_GetGS1MemberInfoForWebServiceByTaxID(@TAX_ID) set @currentRow = @currentRow +1 end drop table tempWsGs1_001 select * from tempWsGs1_002 drop table tempWsGs1_002 20:00:48 16 กุมภาพันธ์ 2561 :There is already an object named 'tempWsGs1_001' in the database. 20:09:08 16 กุมภาพันธ์ 2561 :Server was unable to process request. ---> Cannot open database "RDtmp" requested by the login. The login failed. 20:56:24 16 กุมภาพันธ์ 2561 :Index was out of range. Must be non-negative and less than the size of the collection. Parameter name: index 20:56:24 16 กุมภาพันธ์ 2561 :try to logon with: GS1WS 21:00:48 16 กุมภาพันธ์ 2561 :Index was out of range. Must be non-negative and less than the size of the collection. Parameter name: index 21:00:48 16 กุมภาพันธ์ 2561 :try to logon with: GS1WS 21:00:48 16 กุมภาพันธ์ 2561 :getGS1changed=/*SELECT MB_MEMBER.MEMBER_CODE, MB_PRENAME.PRENAME_TH, MB_COMP_PERSON.COMP_PERSON_NAME_TH, MB_PRENAME.PRENAME_EN, MB_COMP_PERSON.COMP_PERSON_NAME_EN, MB_COMP_PERSON.TAX_ID, MB_MEMBER.REGIST_DATE, MB_MEMBER.MEMBER_MAIN_TYPE_CODE, MB_MEMBER.MEMBER_TYPE_CODE, MB_MEMBER.MEMBER_STATUS_CODE, MB_MEMBER_RETIRE.APPROVE_DATE FROM MB_MEMBER INNER JOIN MB_COMP_PERSON ON MB_MEMBER.COMP_PERSON_CODE = MB_COMP_PERSON.COMP_PERSON_CODE INNER JOIN MB_MEMBER_RETIRE ON MB_MEMBER.REGIST_CODE = MB_MEMBER_RETIRE.REGIST_CODE LEFT OUTER JOIN MB_PRENAME ON MB_COMP_PERSON.PREN_CODE = MB_PRENAME.PRENAME_CODE WHERE (MB_MEMBER.MEMBER_MAIN_GROUP_CODE = '300') AND (MB_MEMBER_RETIRE.APPROVE_DATE BETWEEN dbo.fnc_StrToDateTime(@YYYYMMDD_FROM + '000000') AND dbo.fnc_StrToDateTime(@YYYYMMDD_TO + '235959')) ORDER BY MB_MEMBER_RETIRE.APPROVE_DATE*/ --declare @YYYYMMDD_FROM varchar(max) = '20171101' --declare @YYYYMMDD_TO varchar(max) = '20171201' create table tempWsGs1_001 ( id int, tax_id varchar(max) ) create table tempWsGs1_002 ( MEMBER_CODE varchar(max) , TAX_ID varchar(max) , BDB_CODE varchar(max) , MEMBER_MAIN_TYPE_CODE varchar(max) , MEMBER_MAIN_TYPE_NAME varchar(max) , MEMBER_TYPE_CODE varchar(max) , MEMBER_TYPE_NAME varchar(max) , BUSSINESS_TYPE_TH varchar(max) , BUSSINESS_TYPE_EN varchar(max) , PRENAME_TH varchar(max) , COMP_PERSON_NAME_TH varchar(max) , PRENAME_EN varchar(max) , COMP_PERSON_NAME_EN varchar(max) , ADDR_TH varchar(max) , ADDR_EN varchar(max) , ZIP_CODE_TH varchar(max) , ZIP_CODE_EN varchar(max) , TELEPHONE_TH varchar(max) , TELEPHONE_EN varchar(max) , EMAIL_TH varchar(max) , EMAIL_EN varchar(max) , STATUS varchar(max) , REGIST_DATE varchar(max) , MEMBER_DATE varchar(max) , UPDATE_DATE varchar(max) , CompanyPrefix varchar(max) ) insert into tempWsGs1_001 select distinct ROW_NUMBER() over (order by r.approve_date) as id, c.TAX_ID as tax_id from MB_MEMBER m,MB_COMP_PERSON c,MB_MEMBER_RETIRE r where r.REGIST_CODE=m.REGIST_CODE and m.MEMBER_MAIN_GROUP_CODE='300' and m.COMP_PERSON_CODE=c.COMP_PERSON_CODE AND (r.APPROVE_DATE BETWEEN dbo.fnc_StrToDateTime(@YYYYMMDD_FROM + '000000') AND dbo.fnc_StrToDateTime(@YYYYMMDD_TO + '235959')) declare @id int declare @totalRows int = (select count(*) from tempWsGs1_001) declare @currentRow int = 0 declare @BussinessTypeTH VARCHAR(max) declare @BussinessTypeEN VARCHAR(max) while @currentRow < @totalRows begin set @id = @currentRow+1 declare @TAX_ID varchar(max) set @TAX_ID = (select top 1 tax_id from tempWsGs1_001 where id=@id) insert into tempWsGs1_002 select * from fnc_GetGS1MemberInfoForWebServiceByTaxID(@TAX_ID) set @currentRow = @currentRow +1 end drop table tempWsGs1_001 select * from tempWsGs1_002 drop table tempWsGs1_002 21:00:48 16 กุมภาพันธ์ 2561 :There is already an object named 'tempWsGs1_001' in the database. 22:00:48 16 กุมภาพันธ์ 2561 :Index was out of range. Must be non-negative and less than the size of the collection. Parameter name: index 22:00:48 16 กุมภาพันธ์ 2561 :try to logon with: GS1WS 22:00:48 16 กุมภาพันธ์ 2561 :getGS1changed=/*SELECT MB_MEMBER.MEMBER_CODE, MB_PRENAME.PRENAME_TH, MB_COMP_PERSON.COMP_PERSON_NAME_TH, MB_PRENAME.PRENAME_EN, MB_COMP_PERSON.COMP_PERSON_NAME_EN, MB_COMP_PERSON.TAX_ID, MB_MEMBER.REGIST_DATE, MB_MEMBER.MEMBER_MAIN_TYPE_CODE, MB_MEMBER.MEMBER_TYPE_CODE, MB_MEMBER.MEMBER_STATUS_CODE, MB_MEMBER_RETIRE.APPROVE_DATE FROM MB_MEMBER INNER JOIN MB_COMP_PERSON ON MB_MEMBER.COMP_PERSON_CODE = MB_COMP_PERSON.COMP_PERSON_CODE INNER JOIN MB_MEMBER_RETIRE ON MB_MEMBER.REGIST_CODE = MB_MEMBER_RETIRE.REGIST_CODE LEFT OUTER JOIN MB_PRENAME ON MB_COMP_PERSON.PREN_CODE = MB_PRENAME.PRENAME_CODE WHERE (MB_MEMBER.MEMBER_MAIN_GROUP_CODE = '300') AND (MB_MEMBER_RETIRE.APPROVE_DATE BETWEEN dbo.fnc_StrToDateTime(@YYYYMMDD_FROM + '000000') AND dbo.fnc_StrToDateTime(@YYYYMMDD_TO + '235959')) ORDER BY MB_MEMBER_RETIRE.APPROVE_DATE*/ --declare @YYYYMMDD_FROM varchar(max) = '20171101' --declare @YYYYMMDD_TO varchar(max) = '20171201' create table tempWsGs1_001 ( id int, tax_id varchar(max) ) create table tempWsGs1_002 ( MEMBER_CODE varchar(max) , TAX_ID varchar(max) , BDB_CODE varchar(max) , MEMBER_MAIN_TYPE_CODE varchar(max) , MEMBER_MAIN_TYPE_NAME varchar(max) , MEMBER_TYPE_CODE varchar(max) , MEMBER_TYPE_NAME varchar(max) , BUSSINESS_TYPE_TH varchar(max) , BUSSINESS_TYPE_EN varchar(max) , PRENAME_TH varchar(max) , COMP_PERSON_NAME_TH varchar(max) , PRENAME_EN varchar(max) , COMP_PERSON_NAME_EN varchar(max) , ADDR_TH varchar(max) , ADDR_EN varchar(max) , ZIP_CODE_TH varchar(max) , ZIP_CODE_EN varchar(max) , TELEPHONE_TH varchar(max) , TELEPHONE_EN varchar(max) , EMAIL_TH varchar(max) , EMAIL_EN varchar(max) , STATUS varchar(max) , REGIST_DATE varchar(max) , MEMBER_DATE varchar(max) , UPDATE_DATE varchar(max) , CompanyPrefix varchar(max) ) insert into tempWsGs1_001 select distinct ROW_NUMBER() over (order by r.approve_date) as id, c.TAX_ID as tax_id from MB_MEMBER m,MB_COMP_PERSON c,MB_MEMBER_RETIRE r where r.REGIST_CODE=m.REGIST_CODE and m.MEMBER_MAIN_GROUP_CODE='300' and m.COMP_PERSON_CODE=c.COMP_PERSON_CODE AND (r.APPROVE_DATE BETWEEN dbo.fnc_StrToDateTime(@YYYYMMDD_FROM + '000000') AND dbo.fnc_StrToDateTime(@YYYYMMDD_TO + '235959')) declare @id int declare @totalRows int = (select count(*) from tempWsGs1_001) declare @currentRow int = 0 declare @BussinessTypeTH VARCHAR(max) declare @BussinessTypeEN VARCHAR(max) while @currentRow < @totalRows begin set @id = @currentRow+1 declare @TAX_ID varchar(max) set @TAX_ID = (select top 1 tax_id from tempWsGs1_001 where id=@id) insert into tempWsGs1_002 select * from fnc_GetGS1MemberInfoForWebServiceByTaxID(@TAX_ID) set @currentRow = @currentRow +1 end drop table tempWsGs1_001 select * from tempWsGs1_002 drop table tempWsGs1_002 22:00:48 16 กุมภาพันธ์ 2561 :There is already an object named 'tempWsGs1_001' in the database. 23:00:49 16 กุมภาพันธ์ 2561 :Index was out of range. Must be non-negative and less than the size of the collection. Parameter name: index 23:00:49 16 กุมภาพันธ์ 2561 :try to logon with: GS1WS 23:00:49 16 กุมภาพันธ์ 2561 :getGS1changed=/*SELECT MB_MEMBER.MEMBER_CODE, MB_PRENAME.PRENAME_TH, MB_COMP_PERSON.COMP_PERSON_NAME_TH, MB_PRENAME.PRENAME_EN, MB_COMP_PERSON.COMP_PERSON_NAME_EN, MB_COMP_PERSON.TAX_ID, MB_MEMBER.REGIST_DATE, MB_MEMBER.MEMBER_MAIN_TYPE_CODE, MB_MEMBER.MEMBER_TYPE_CODE, MB_MEMBER.MEMBER_STATUS_CODE, MB_MEMBER_RETIRE.APPROVE_DATE FROM MB_MEMBER INNER JOIN MB_COMP_PERSON ON MB_MEMBER.COMP_PERSON_CODE = MB_COMP_PERSON.COMP_PERSON_CODE INNER JOIN MB_MEMBER_RETIRE ON MB_MEMBER.REGIST_CODE = MB_MEMBER_RETIRE.REGIST_CODE LEFT OUTER JOIN MB_PRENAME ON MB_COMP_PERSON.PREN_CODE = MB_PRENAME.PRENAME_CODE WHERE (MB_MEMBER.MEMBER_MAIN_GROUP_CODE = '300') AND (MB_MEMBER_RETIRE.APPROVE_DATE BETWEEN dbo.fnc_StrToDateTime(@YYYYMMDD_FROM + '000000') AND dbo.fnc_StrToDateTime(@YYYYMMDD_TO + '235959')) ORDER BY MB_MEMBER_RETIRE.APPROVE_DATE*/ --declare @YYYYMMDD_FROM varchar(max) = '20171101' --declare @YYYYMMDD_TO varchar(max) = '20171201' create table tempWsGs1_001 ( id int, tax_id varchar(max) ) create table tempWsGs1_002 ( MEMBER_CODE varchar(max) , TAX_ID varchar(max) , BDB_CODE varchar(max) , MEMBER_MAIN_TYPE_CODE varchar(max) , MEMBER_MAIN_TYPE_NAME varchar(max) , MEMBER_TYPE_CODE varchar(max) , MEMBER_TYPE_NAME varchar(max) , BUSSINESS_TYPE_TH varchar(max) , BUSSINESS_TYPE_EN varchar(max) , PRENAME_TH varchar(max) , COMP_PERSON_NAME_TH varchar(max) , PRENAME_EN varchar(max) , COMP_PERSON_NAME_EN varchar(max) , ADDR_TH varchar(max) , ADDR_EN varchar(max) , ZIP_CODE_TH varchar(max) , ZIP_CODE_EN varchar(max) , TELEPHONE_TH varchar(max) , TELEPHONE_EN varchar(max) , EMAIL_TH varchar(max) , EMAIL_EN varchar(max) , STATUS varchar(max) , REGIST_DATE varchar(max) , MEMBER_DATE varchar(max) , UPDATE_DATE varchar(max) , CompanyPrefix varchar(max) ) insert into tempWsGs1_001 select distinct ROW_NUMBER() over (order by r.approve_date) as id, c.TAX_ID as tax_id from MB_MEMBER m,MB_COMP_PERSON c,MB_MEMBER_RETIRE r where r.REGIST_CODE=m.REGIST_CODE and m.MEMBER_MAIN_GROUP_CODE='300' and m.COMP_PERSON_CODE=c.COMP_PERSON_CODE AND (r.APPROVE_DATE BETWEEN dbo.fnc_StrToDateTime(@YYYYMMDD_FROM + '000000') AND dbo.fnc_StrToDateTime(@YYYYMMDD_TO + '235959')) declare @id int declare @totalRows int = (select count(*) from tempWsGs1_001) declare @currentRow int = 0 declare @BussinessTypeTH VARCHAR(max) declare @BussinessTypeEN VARCHAR(max) while @currentRow < @totalRows begin set @id = @currentRow+1 declare @TAX_ID varchar(max) set @TAX_ID = (select top 1 tax_id from tempWsGs1_001 where id=@id) insert into tempWsGs1_002 select * from fnc_GetGS1MemberInfoForWebServiceByTaxID(@TAX_ID) set @currentRow = @currentRow +1 end drop table tempWsGs1_001 select * from tempWsGs1_002 drop table tempWsGs1_002 23:00:49 16 กุมภาพันธ์ 2561 :There is already an object named 'tempWsGs1_001' in the database.