0:00:36 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
0:00:36 12 มีนาคม 2561  :try to logon with: GS1WS
0:00:36 12 มีนาคม 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
0:00:36 12 มีนาคม 2561  :There is already an object named 'tempWsGs1_001' in the database.
0:57:23 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
0:57:23 12 มีนาคม 2561  :try to logon with: GS1WS
1:16:44 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
1:16:44 12 มีนาคม 2561  :try to logon with: GS1WS
1:16:44 12 มีนาคม 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
1:16:44 12 มีนาคม 2561  :There is already an object named 'tempWsGs1_001' in the database.
2:00:39 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
2:00:39 12 มีนาคม 2561  :try to logon with: GS1WS
2:00:39 12 มีนาคม 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
2:00:39 12 มีนาคม 2561  :There is already an object named 'tempWsGs1_001' in the database.
3:00:34 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
3:00:34 12 มีนาคม 2561  :try to logon with: GS1WS
3:00:34 12 มีนาคม 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
3:00:34 12 มีนาคม 2561  :There is already an object named 'tempWsGs1_001' in the database.
4:00:35 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
4:00:35 12 มีนาคม 2561  :try to logon with: GS1WS
4:00:35 12 มีนาคม 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
4:00:35 12 มีนาคม 2561  :There is already an object named 'tempWsGs1_001' in the database.
5:00:34 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
5:00:34 12 มีนาคม 2561  :try to logon with: GS1WS
5:00:34 12 มีนาคม 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
5:00:34 12 มีนาคม 2561  :There is already an object named 'tempWsGs1_001' in the database.
6:00:34 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
6:00:34 12 มีนาคม 2561  :try to logon with: GS1WS
6:00:34 12 มีนาคม 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
6:00:34 12 มีนาคม 2561  :There is already an object named 'tempWsGs1_001' in the database.
7:00:34 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
7:00:34 12 มีนาคม 2561  :try to logon with: GS1WS
7:00:34 12 มีนาคม 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:00:34 12 มีนาคม 2561  :There is already an object named 'tempWsGs1_001' in the database.
8:00:34 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
8:00:34 12 มีนาคม 2561  :try to logon with: GS1WS
8:00:34 12 มีนาคม 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:34 12 มีนาคม 2561  :There is already an object named 'tempWsGs1_001' in the database.
8:59:29 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
8:59:29 12 มีนาคม 2561  :try to logon with: GS1WS
9:00:34 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
9:00:34 12 มีนาคม 2561  :try to logon with: GS1WS
9:00:34 12 มีนาคม 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:34 12 มีนาคม 2561  :There is already an object named 'tempWsGs1_001' in the database.
9:03:21 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
9:03:21 12 มีนาคม 2561  :try to logon with: GS1WS
9:03:21 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
9:03:21 12 มีนาคม 2561  :try to logon with: GS1WS
9:03:21 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
9:03:21 12 มีนาคม 2561  :try to logon with: GS1WS
9:03:22 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
9:03:22 12 มีนาคม 2561  :try to logon with: GS1WS
9:03:22 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
9:03:22 12 มีนาคม 2561  :try to logon with: GS1WS
9:03:22 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
9:03:22 12 มีนาคม 2561  :try to logon with: GS1WS
9:03:22 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
9:03:22 12 มีนาคม 2561  :try to logon with: GS1WS
9:03:22 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
9:03:22 12 มีนาคม 2561  :try to logon with: GS1WS
9:03:22 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
9:03:22 12 มีนาคม 2561  :try to logon with: GS1WS
9:03:23 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
9:03:23 12 มีนาคม 2561  :try to logon with: GS1WS
9:03:23 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
9:03:23 12 มีนาคม 2561  :try to logon with: GS1WS
9:03:23 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
9:03:23 12 มีนาคม 2561  :try to logon with: GS1WS
9:03:23 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
9:03:23 12 มีนาคม 2561  :try to logon with: GS1WS
9:03:23 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
9:03:23 12 มีนาคม 2561  :try to logon with: GS1WS
9:03:23 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
9:03:23 12 มีนาคม 2561  :try to logon with: GS1WS
9:03:23 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
9:03:23 12 มีนาคม 2561  :try to logon with: GS1WS
9:03:24 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
9:03:24 12 มีนาคม 2561  :try to logon with: GS1WS
9:03:24 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
9:03:24 12 มีนาคม 2561  :try to logon with: GS1WS
9:03:24 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
9:03:24 12 มีนาคม 2561  :try to logon with: GS1WS
9:03:24 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
9:03:24 12 มีนาคม 2561  :try to logon with: GS1WS
9:03:24 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
9:03:24 12 มีนาคม 2561  :try to logon with: GS1WS
9:03:24 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
9:03:24 12 มีนาคม 2561  :try to logon with: GS1WS
9:03:24 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
9:03:24 12 มีนาคม 2561  :try to logon with: GS1WS
9:03:24 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
9:03:24 12 มีนาคม 2561  :try to logon with: GS1WS
9:03:25 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
9:03:25 12 มีนาคม 2561  :try to logon with: GS1WS
9:03:25 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
9:03:25 12 มีนาคม 2561  :try to logon with: GS1WS
9:03:25 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
9:03:25 12 มีนาคม 2561  :try to logon with: GS1WS
9:03:25 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
9:03:25 12 มีนาคม 2561  :try to logon with: GS1WS
9:03:25 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
9:03:25 12 มีนาคม 2561  :try to logon with: GS1WS
9:03:25 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
9:03:25 12 มีนาคม 2561  :try to logon with: GS1WS
9:03:26 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
9:03:26 12 มีนาคม 2561  :try to logon with: GS1WS
9:03:26 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
9:03:26 12 มีนาคม 2561  :try to logon with: GS1WS
9:03:26 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
9:03:26 12 มีนาคม 2561  :try to logon with: GS1WS
9:03:26 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
9:03:26 12 มีนาคม 2561  :try to logon with: GS1WS
9:03:26 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
9:03:26 12 มีนาคม 2561  :try to logon with: GS1WS
9:03:26 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
9:03:26 12 มีนาคม 2561  :try to logon with: GS1WS
9:03:26 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
9:03:26 12 มีนาคม 2561  :try to logon with: GS1WS
9:03:27 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
9:03:27 12 มีนาคม 2561  :try to logon with: GS1WS
9:03:27 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
9:03:27 12 มีนาคม 2561  :try to logon with: GS1WS
9:03:27 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
9:03:27 12 มีนาคม 2561  :try to logon with: GS1WS
9:03:27 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
9:03:27 12 มีนาคม 2561  :try to logon with: GS1WS
9:03:27 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
9:03:27 12 มีนาคม 2561  :try to logon with: GS1WS
9:03:27 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
9:03:27 12 มีนาคม 2561  :try to logon with: GS1WS
9:03:27 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
9:03:27 12 มีนาคม 2561  :try to logon with: GS1WS
9:03:27 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
9:03:27 12 มีนาคม 2561  :try to logon with: GS1WS
9:03:28 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
9:03:28 12 มีนาคม 2561  :try to logon with: GS1WS
9:03:28 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
9:03:28 12 มีนาคม 2561  :try to logon with: GS1WS
9:03:28 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
9:03:28 12 มีนาคม 2561  :try to logon with: GS1WS
9:03:28 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
9:03:28 12 มีนาคม 2561  :try to logon with: GS1WS
9:03:28 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
9:03:28 12 มีนาคม 2561  :try to logon with: GS1WS
9:03:28 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
9:03:28 12 มีนาคม 2561  :try to logon with: GS1WS
9:03:28 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
9:03:28 12 มีนาคม 2561  :try to logon with: GS1WS
9:03:29 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
9:03:29 12 มีนาคม 2561  :try to logon with: GS1WS
9:03:29 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
9:03:29 12 มีนาคม 2561  :try to logon with: GS1WS
9:03:29 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
9:03:29 12 มีนาคม 2561  :try to logon with: GS1WS
9:03:29 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
9:03:29 12 มีนาคม 2561  :try to logon with: GS1WS
9:03:29 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
9:03:29 12 มีนาคม 2561  :try to logon with: GS1WS
9:03:29 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
9:03:29 12 มีนาคม 2561  :try to logon with: GS1WS
9:03:29 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
9:03:29 12 มีนาคม 2561  :try to logon with: GS1WS
9:03:29 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
9:03:29 12 มีนาคม 2561  :try to logon with: GS1WS
9:03:30 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
9:03:30 12 มีนาคม 2561  :try to logon with: GS1WS
9:03:30 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
9:03:30 12 มีนาคม 2561  :try to logon with: GS1WS
9:03:30 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
9:03:30 12 มีนาคม 2561  :try to logon with: GS1WS
9:03:30 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
9:03:30 12 มีนาคม 2561  :try to logon with: GS1WS
9:03:30 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
9:03:30 12 มีนาคม 2561  :try to logon with: GS1WS
9:03:30 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
9:03:30 12 มีนาคม 2561  :try to logon with: GS1WS
9:03:30 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
9:03:30 12 มีนาคม 2561  :try to logon with: GS1WS
9:08:13 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
9:08:13 12 มีนาคม 2561  :try to logon with: GS1WS
9:09:03 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
9:09:03 12 มีนาคม 2561  :try to logon with: GS1WS
9:09:04 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
9:09:04 12 มีนาคม 2561  :try to logon with: GS1WS
9:09:04 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
9:09:04 12 มีนาคม 2561  :try to logon with: GS1WS
9:09:04 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
9:09:04 12 มีนาคม 2561  :try to logon with: GS1WS
9:09:04 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
9:09:04 12 มีนาคม 2561  :try to logon with: GS1WS
9:09:04 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
9:09:04 12 มีนาคม 2561  :try to logon with: GS1WS
9:09:04 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
9:09:04 12 มีนาคม 2561  :try to logon with: GS1WS
9:09:04 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
9:09:04 12 มีนาคม 2561  :try to logon with: GS1WS
9:09:04 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
9:09:04 12 มีนาคม 2561  :try to logon with: GS1WS
9:09:05 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
9:09:05 12 มีนาคม 2561  :try to logon with: GS1WS
9:09:05 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
9:09:05 12 มีนาคม 2561  :try to logon with: GS1WS
9:09:05 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
9:09:05 12 มีนาคม 2561  :try to logon with: GS1WS
9:09:05 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
9:09:05 12 มีนาคม 2561  :try to logon with: GS1WS
9:09:05 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
9:09:05 12 มีนาคม 2561  :try to logon with: GS1WS
9:09:05 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
9:09:05 12 มีนาคม 2561  :try to logon with: GS1WS
9:09:05 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
9:09:05 12 มีนาคม 2561  :try to logon with: GS1WS
9:09:06 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
9:09:06 12 มีนาคม 2561  :try to logon with: GS1WS
9:09:06 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
9:09:06 12 มีนาคม 2561  :try to logon with: GS1WS
9:09:06 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
9:09:06 12 มีนาคม 2561  :try to logon with: GS1WS
9:09:06 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
9:09:06 12 มีนาคม 2561  :try to logon with: GS1WS
9:09:06 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
9:09:06 12 มีนาคม 2561  :try to logon with: GS1WS
9:09:06 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
9:09:06 12 มีนาคม 2561  :try to logon with: GS1WS
9:09:07 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
9:09:07 12 มีนาคม 2561  :try to logon with: GS1WS
9:09:07 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
9:09:07 12 มีนาคม 2561  :try to logon with: GS1WS
9:09:07 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
9:09:07 12 มีนาคม 2561  :try to logon with: GS1WS
9:09:07 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
9:09:07 12 มีนาคม 2561  :try to logon with: GS1WS
9:09:07 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
9:09:07 12 มีนาคม 2561  :try to logon with: GS1WS
9:09:07 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
9:09:07 12 มีนาคม 2561  :try to logon with: GS1WS
9:09:07 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
9:09:07 12 มีนาคม 2561  :try to logon with: GS1WS
9:09:08 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
9:09:08 12 มีนาคม 2561  :try to logon with: GS1WS
9:09:08 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
9:09:08 12 มีนาคม 2561  :try to logon with: GS1WS
9:09:08 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
9:09:08 12 มีนาคม 2561  :try to logon with: GS1WS
9:09:08 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
9:09:08 12 มีนาคม 2561  :try to logon with: GS1WS
9:09:08 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
9:09:08 12 มีนาคม 2561  :try to logon with: GS1WS
9:09:08 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
9:09:08 12 มีนาคม 2561  :try to logon with: GS1WS
9:09:08 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
9:09:08 12 มีนาคม 2561  :try to logon with: GS1WS
9:09:08 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
9:09:08 12 มีนาคม 2561  :try to logon with: GS1WS
9:09:09 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
9:09:09 12 มีนาคม 2561  :try to logon with: GS1WS
9:09:09 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
9:09:09 12 มีนาคม 2561  :try to logon with: GS1WS
9:09:09 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
9:09:09 12 มีนาคม 2561  :try to logon with: GS1WS
9:09:09 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
9:09:09 12 มีนาคม 2561  :try to logon with: GS1WS
9:09:09 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
9:09:09 12 มีนาคม 2561  :try to logon with: GS1WS
9:09:09 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
9:09:09 12 มีนาคม 2561  :try to logon with: GS1WS
9:09:09 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
9:09:09 12 มีนาคม 2561  :try to logon with: GS1WS
9:09:10 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
9:09:10 12 มีนาคม 2561  :try to logon with: GS1WS
9:09:10 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
9:09:10 12 มีนาคม 2561  :try to logon with: GS1WS
9:09:10 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
9:09:10 12 มีนาคม 2561  :try to logon with: GS1WS
9:09:10 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
9:09:10 12 มีนาคม 2561  :try to logon with: GS1WS
9:09:10 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
9:09:10 12 มีนาคม 2561  :try to logon with: GS1WS
9:09:10 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
9:09:10 12 มีนาคม 2561  :try to logon with: GS1WS
9:09:11 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
9:09:11 12 มีนาคม 2561  :try to logon with: GS1WS
9:09:11 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
9:09:11 12 มีนาคม 2561  :try to logon with: GS1WS
9:09:11 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
9:09:11 12 มีนาคม 2561  :try to logon with: GS1WS
9:09:11 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
9:09:11 12 มีนาคม 2561  :try to logon with: GS1WS
9:09:11 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
9:09:11 12 มีนาคม 2561  :try to logon with: GS1WS
9:09:11 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
9:09:11 12 มีนาคม 2561  :try to logon with: GS1WS
9:09:11 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
9:09:11 12 มีนาคม 2561  :try to logon with: GS1WS
9:09:12 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
9:09:12 12 มีนาคม 2561  :try to logon with: GS1WS
9:09:12 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
9:09:12 12 มีนาคม 2561  :try to logon with: GS1WS
9:09:12 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
9:09:12 12 มีนาคม 2561  :try to logon with: GS1WS
9:09:12 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
9:09:12 12 มีนาคม 2561  :try to logon with: GS1WS
9:09:12 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
9:09:12 12 มีนาคม 2561  :try to logon with: GS1WS
9:09:12 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
9:09:12 12 มีนาคม 2561  :try to logon with: GS1WS
9:09:12 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
9:09:12 12 มีนาคม 2561  :try to logon with: GS1WS
9:09:12 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
9:09:12 12 มีนาคม 2561  :try to logon with: GS1WS
9:09:13 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
9:09:13 12 มีนาคม 2561  :try to logon with: GS1WS
9:09:13 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
9:09:13 12 มีนาคม 2561  :try to logon with: GS1WS
9:11:23 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
9:11:23 12 มีนาคม 2561  :try to logon with: GS1WS
9:11:23 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
9:11:23 12 มีนาคม 2561  :try to logon with: GS1WS
9:11:23 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
9:11:23 12 มีนาคม 2561  :try to logon with: GS1WS
9:11:23 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
9:11:23 12 มีนาคม 2561  :try to logon with: GS1WS
9:11:23 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
9:11:23 12 มีนาคม 2561  :try to logon with: GS1WS
9:11:24 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
9:11:24 12 มีนาคม 2561  :try to logon with: GS1WS
9:11:24 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
9:11:24 12 มีนาคม 2561  :try to logon with: GS1WS
9:11:24 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
9:11:24 12 มีนาคม 2561  :try to logon with: GS1WS
9:11:24 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
9:11:24 12 มีนาคม 2561  :try to logon with: GS1WS
9:11:24 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
9:11:24 12 มีนาคม 2561  :try to logon with: GS1WS
9:11:25 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
9:11:25 12 มีนาคม 2561  :try to logon with: GS1WS
9:11:25 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
9:11:25 12 มีนาคม 2561  :try to logon with: GS1WS
9:11:25 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
9:11:25 12 มีนาคม 2561  :try to logon with: GS1WS
9:11:25 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
9:11:25 12 มีนาคม 2561  :try to logon with: GS1WS
9:11:25 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
9:11:25 12 มีนาคม 2561  :try to logon with: GS1WS
9:11:26 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
9:11:26 12 มีนาคม 2561  :try to logon with: GS1WS
9:11:26 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
9:11:26 12 มีนาคม 2561  :try to logon with: GS1WS
9:11:26 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
9:11:26 12 มีนาคม 2561  :try to logon with: GS1WS
9:11:26 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
9:11:26 12 มีนาคม 2561  :try to logon with: GS1WS
9:11:26 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
9:11:26 12 มีนาคม 2561  :try to logon with: GS1WS
9:11:26 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
9:11:26 12 มีนาคม 2561  :try to logon with: GS1WS
9:11:26 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
9:11:26 12 มีนาคม 2561  :try to logon with: GS1WS
9:11:27 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
9:11:27 12 มีนาคม 2561  :try to logon with: GS1WS
9:11:27 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
9:11:27 12 มีนาคม 2561  :try to logon with: GS1WS
9:11:27 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
9:11:27 12 มีนาคม 2561  :try to logon with: GS1WS
9:11:27 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
9:11:27 12 มีนาคม 2561  :try to logon with: GS1WS
9:11:27 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
9:11:27 12 มีนาคม 2561  :try to logon with: GS1WS
9:11:27 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
9:11:27 12 มีนาคม 2561  :try to logon with: GS1WS
9:11:27 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
9:11:27 12 มีนาคม 2561  :try to logon with: GS1WS
9:11:27 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
9:11:27 12 มีนาคม 2561  :try to logon with: GS1WS
9:11:28 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
9:11:28 12 มีนาคม 2561  :try to logon with: GS1WS
9:11:28 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
9:11:28 12 มีนาคม 2561  :try to logon with: GS1WS
9:11:28 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
9:11:28 12 มีนาคม 2561  :try to logon with: GS1WS
9:11:28 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
9:11:28 12 มีนาคม 2561  :try to logon with: GS1WS
9:11:28 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
9:11:28 12 มีนาคม 2561  :try to logon with: GS1WS
9:11:28 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
9:11:28 12 มีนาคม 2561  :try to logon with: GS1WS
9:11:28 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
9:11:28 12 มีนาคม 2561  :try to logon with: GS1WS
9:11:29 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
9:11:29 12 มีนาคม 2561  :try to logon with: GS1WS
9:11:29 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
9:11:29 12 มีนาคม 2561  :try to logon with: GS1WS
9:11:29 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
9:11:29 12 มีนาคม 2561  :try to logon with: GS1WS
9:11:29 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
9:11:29 12 มีนาคม 2561  :try to logon with: GS1WS
9:11:29 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
9:11:29 12 มีนาคม 2561  :try to logon with: GS1WS
9:11:29 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
9:11:29 12 มีนาคม 2561  :try to logon with: GS1WS
9:11:29 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
9:11:29 12 มีนาคม 2561  :try to logon with: GS1WS
9:11:29 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
9:11:29 12 มีนาคม 2561  :try to logon with: GS1WS
9:11:30 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
9:11:30 12 มีนาคม 2561  :try to logon with: GS1WS
9:11:30 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
9:11:30 12 มีนาคม 2561  :try to logon with: GS1WS
9:11:30 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
9:11:30 12 มีนาคม 2561  :try to logon with: GS1WS
9:11:30 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
9:11:30 12 มีนาคม 2561  :try to logon with: GS1WS
9:11:30 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
9:11:30 12 มีนาคม 2561  :try to logon with: GS1WS
9:11:30 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
9:11:30 12 มีนาคม 2561  :try to logon with: GS1WS
9:11:30 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
9:11:30 12 มีนาคม 2561  :try to logon with: GS1WS
9:11:30 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
9:11:30 12 มีนาคม 2561  :try to logon with: GS1WS
9:11:31 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
9:11:31 12 มีนาคม 2561  :try to logon with: GS1WS
9:11:31 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
9:11:31 12 มีนาคม 2561  :try to logon with: GS1WS
9:11:31 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
9:11:31 12 มีนาคม 2561  :try to logon with: GS1WS
9:11:31 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
9:11:31 12 มีนาคม 2561  :try to logon with: GS1WS
9:11:31 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
9:11:31 12 มีนาคม 2561  :try to logon with: GS1WS
9:11:31 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
9:11:31 12 มีนาคม 2561  :try to logon with: GS1WS
9:11:31 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
9:11:31 12 มีนาคม 2561  :try to logon with: GS1WS
9:11:32 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
9:11:32 12 มีนาคม 2561  :try to logon with: GS1WS
9:11:32 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
9:11:32 12 มีนาคม 2561  :try to logon with: GS1WS
9:11:32 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
9:11:32 12 มีนาคม 2561  :try to logon with: GS1WS
9:11:32 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
9:11:32 12 มีนาคม 2561  :try to logon with: GS1WS
9:11:32 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
9:11:32 12 มีนาคม 2561  :try to logon with: GS1WS
9:11:32 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
9:11:32 12 มีนาคม 2561  :try to logon with: GS1WS
9:11:32 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
9:11:32 12 มีนาคม 2561  :try to logon with: GS1WS
9:11:33 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
9:11:33 12 มีนาคม 2561  :try to logon with: GS1WS
9:13:44 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
9:13:44 12 มีนาคม 2561  :try to logon with: GS1WS
9:13:44 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
9:13:44 12 มีนาคม 2561  :try to logon with: GS1WS
9:13:44 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
9:13:44 12 มีนาคม 2561  :try to logon with: GS1WS
9:13:44 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
9:13:44 12 มีนาคม 2561  :try to logon with: GS1WS
9:13:45 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
9:13:45 12 มีนาคม 2561  :try to logon with: GS1WS
9:13:45 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
9:13:45 12 มีนาคม 2561  :try to logon with: GS1WS
9:13:45 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
9:13:45 12 มีนาคม 2561  :try to logon with: GS1WS
9:13:45 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
9:13:45 12 มีนาคม 2561  :try to logon with: GS1WS
9:13:45 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
9:13:45 12 มีนาคม 2561  :try to logon with: GS1WS
9:13:46 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
9:13:46 12 มีนาคม 2561  :try to logon with: GS1WS
9:13:46 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
9:13:46 12 มีนาคม 2561  :try to logon with: GS1WS
9:13:46 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
9:13:46 12 มีนาคม 2561  :try to logon with: GS1WS
9:13:46 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
9:13:46 12 มีนาคม 2561  :try to logon with: GS1WS
9:13:46 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
9:13:46 12 มีนาคม 2561  :try to logon with: GS1WS
9:13:46 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
9:13:46 12 มีนาคม 2561  :try to logon with: GS1WS
9:13:47 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
9:13:47 12 มีนาคม 2561  :try to logon with: GS1WS
9:13:47 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
9:13:47 12 มีนาคม 2561  :try to logon with: GS1WS
9:13:47 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
9:13:47 12 มีนาคม 2561  :try to logon with: GS1WS
9:13:47 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
9:13:47 12 มีนาคม 2561  :try to logon with: GS1WS
9:13:47 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
9:13:47 12 มีนาคม 2561  :try to logon with: GS1WS
9:13:47 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
9:13:47 12 มีนาคม 2561  :try to logon with: GS1WS
9:13:47 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
9:13:47 12 มีนาคม 2561  :try to logon with: GS1WS
9:13:47 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
9:13:47 12 มีนาคม 2561  :try to logon with: GS1WS
9:13:48 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
9:13:48 12 มีนาคม 2561  :try to logon with: GS1WS
9:13:48 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
9:13:48 12 มีนาคม 2561  :try to logon with: GS1WS
9:13:48 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
9:13:48 12 มีนาคม 2561  :try to logon with: GS1WS
9:13:48 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
9:13:48 12 มีนาคม 2561  :try to logon with: GS1WS
9:13:48 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
9:13:48 12 มีนาคม 2561  :try to logon with: GS1WS
9:13:48 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
9:13:48 12 มีนาคม 2561  :try to logon with: GS1WS
9:13:48 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
9:13:48 12 มีนาคม 2561  :try to logon with: GS1WS
9:13:48 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
9:13:48 12 มีนาคม 2561  :try to logon with: GS1WS
9:13:49 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
9:13:49 12 มีนาคม 2561  :try to logon with: GS1WS
9:13:49 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
9:13:49 12 มีนาคม 2561  :try to logon with: GS1WS
9:13:49 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
9:13:49 12 มีนาคม 2561  :try to logon with: GS1WS
9:13:49 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
9:13:49 12 มีนาคม 2561  :try to logon with: GS1WS
9:13:49 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
9:13:49 12 มีนาคม 2561  :try to logon with: GS1WS
9:13:49 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
9:13:49 12 มีนาคม 2561  :try to logon with: GS1WS
9:13:49 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
9:13:49 12 มีนาคม 2561  :try to logon with: GS1WS
9:13:50 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
9:13:50 12 มีนาคม 2561  :try to logon with: GS1WS
9:13:50 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
9:13:50 12 มีนาคม 2561  :try to logon with: GS1WS
9:13:50 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
9:13:50 12 มีนาคม 2561  :try to logon with: GS1WS
9:13:50 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
9:13:50 12 มีนาคม 2561  :try to logon with: GS1WS
9:13:50 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
9:13:50 12 มีนาคม 2561  :try to logon with: GS1WS
9:13:50 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
9:13:50 12 มีนาคม 2561  :try to logon with: GS1WS
9:13:50 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
9:13:50 12 มีนาคม 2561  :try to logon with: GS1WS
9:13:50 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
9:13:50 12 มีนาคม 2561  :try to logon with: GS1WS
9:13:51 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
9:13:51 12 มีนาคม 2561  :try to logon with: GS1WS
9:13:51 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
9:13:51 12 มีนาคม 2561  :try to logon with: GS1WS
9:13:51 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
9:13:51 12 มีนาคม 2561  :try to logon with: GS1WS
9:13:51 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
9:13:51 12 มีนาคม 2561  :try to logon with: GS1WS
9:13:51 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
9:13:51 12 มีนาคม 2561  :try to logon with: GS1WS
9:13:52 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
9:13:52 12 มีนาคม 2561  :try to logon with: GS1WS
9:13:52 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
9:13:52 12 มีนาคม 2561  :try to logon with: GS1WS
9:13:52 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
9:13:52 12 มีนาคม 2561  :try to logon with: GS1WS
9:13:52 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
9:13:52 12 มีนาคม 2561  :try to logon with: GS1WS
9:13:52 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
9:13:52 12 มีนาคม 2561  :try to logon with: GS1WS
9:13:52 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
9:13:52 12 มีนาคม 2561  :try to logon with: GS1WS
9:13:52 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
9:13:52 12 มีนาคม 2561  :try to logon with: GS1WS
9:13:52 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
9:13:52 12 มีนาคม 2561  :try to logon with: GS1WS
9:13:53 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
9:13:53 12 มีนาคม 2561  :try to logon with: GS1WS
9:13:53 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
9:13:53 12 มีนาคม 2561  :try to logon with: GS1WS
9:13:53 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
9:13:53 12 มีนาคม 2561  :try to logon with: GS1WS
9:13:53 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
9:13:53 12 มีนาคม 2561  :try to logon with: GS1WS
9:13:53 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
9:13:53 12 มีนาคม 2561  :try to logon with: GS1WS
9:13:53 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
9:13:53 12 มีนาคม 2561  :try to logon with: GS1WS
9:13:53 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
9:13:53 12 มีนาคม 2561  :try to logon with: GS1WS
9:13:54 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
9:13:54 12 มีนาคม 2561  :try to logon with: GS1WS
9:13:54 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
9:13:54 12 มีนาคม 2561  :try to logon with: GS1WS
9:15:31 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
9:15:31 12 มีนาคม 2561  :try to logon with: GS1WS
9:15:31 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
9:15:31 12 มีนาคม 2561  :try to logon with: GS1WS
9:15:31 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
9:15:31 12 มีนาคม 2561  :try to logon with: GS1WS
9:15:31 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
9:15:31 12 มีนาคม 2561  :try to logon with: GS1WS
9:15:31 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
9:15:31 12 มีนาคม 2561  :try to logon with: GS1WS
9:15:31 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
9:15:31 12 มีนาคม 2561  :try to logon with: GS1WS
9:15:32 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
9:15:32 12 มีนาคม 2561  :try to logon with: GS1WS
9:15:32 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
9:15:32 12 มีนาคม 2561  :try to logon with: GS1WS
9:15:32 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
9:15:32 12 มีนาคม 2561  :try to logon with: GS1WS
9:15:32 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
9:15:32 12 มีนาคม 2561  :try to logon with: GS1WS
9:15:32 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
9:15:32 12 มีนาคม 2561  :try to logon with: GS1WS
9:15:32 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
9:15:32 12 มีนาคม 2561  :try to logon with: GS1WS
9:15:32 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
9:15:32 12 มีนาคม 2561  :try to logon with: GS1WS
9:15:33 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
9:15:33 12 มีนาคม 2561  :try to logon with: GS1WS
9:15:33 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
9:15:33 12 มีนาคม 2561  :try to logon with: GS1WS
9:15:33 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
9:15:33 12 มีนาคม 2561  :try to logon with: GS1WS
9:15:33 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
9:15:33 12 มีนาคม 2561  :try to logon with: GS1WS
9:15:33 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
9:15:33 12 มีนาคม 2561  :try to logon with: GS1WS
9:15:33 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
9:15:33 12 มีนาคม 2561  :try to logon with: GS1WS
9:15:33 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
9:15:33 12 มีนาคม 2561  :try to logon with: GS1WS
9:15:34 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
9:15:34 12 มีนาคม 2561  :try to logon with: GS1WS
9:15:34 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
9:15:34 12 มีนาคม 2561  :try to logon with: GS1WS
9:15:34 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
9:15:34 12 มีนาคม 2561  :try to logon with: GS1WS
9:15:34 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
9:15:34 12 มีนาคม 2561  :try to logon with: GS1WS
9:15:34 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
9:15:34 12 มีนาคม 2561  :try to logon with: GS1WS
9:15:34 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
9:15:34 12 มีนาคม 2561  :try to logon with: GS1WS
9:15:34 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
9:15:34 12 มีนาคม 2561  :try to logon with: GS1WS
9:15:34 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
9:15:34 12 มีนาคม 2561  :try to logon with: GS1WS
9:15:35 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
9:15:35 12 มีนาคม 2561  :try to logon with: GS1WS
9:15:35 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
9:15:35 12 มีนาคม 2561  :try to logon with: GS1WS
9:15:35 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
9:15:35 12 มีนาคม 2561  :try to logon with: GS1WS
9:15:35 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
9:15:35 12 มีนาคม 2561  :try to logon with: GS1WS
9:15:35 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
9:15:35 12 มีนาคม 2561  :try to logon with: GS1WS
9:15:35 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
9:15:35 12 มีนาคม 2561  :try to logon with: GS1WS
9:15:35 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
9:15:35 12 มีนาคม 2561  :try to logon with: GS1WS
9:15:36 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
9:15:36 12 มีนาคม 2561  :try to logon with: GS1WS
9:15:36 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
9:15:36 12 มีนาคม 2561  :try to logon with: GS1WS
9:15:36 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
9:15:36 12 มีนาคม 2561  :try to logon with: GS1WS
9:15:37 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
9:15:37 12 มีนาคม 2561  :try to logon with: GS1WS
9:15:37 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
9:15:37 12 มีนาคม 2561  :try to logon with: GS1WS
9:15:37 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
9:15:37 12 มีนาคม 2561  :try to logon with: GS1WS
9:15:37 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
9:15:37 12 มีนาคม 2561  :try to logon with: GS1WS
9:15:37 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
9:15:37 12 มีนาคม 2561  :try to logon with: GS1WS
9:15:37 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
9:15:37 12 มีนาคม 2561  :try to logon with: GS1WS
9:15:37 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
9:15:37 12 มีนาคม 2561  :try to logon with: GS1WS
9:15:38 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
9:15:38 12 มีนาคม 2561  :try to logon with: GS1WS
9:15:38 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
9:15:38 12 มีนาคม 2561  :try to logon with: GS1WS
9:15:38 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
9:15:38 12 มีนาคม 2561  :try to logon with: GS1WS
9:15:38 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
9:15:38 12 มีนาคม 2561  :try to logon with: GS1WS
9:15:38 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
9:15:38 12 มีนาคม 2561  :try to logon with: GS1WS
9:15:38 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
9:15:38 12 มีนาคม 2561  :try to logon with: GS1WS
9:15:38 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
9:15:38 12 มีนาคม 2561  :try to logon with: GS1WS
9:15:39 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
9:15:39 12 มีนาคม 2561  :try to logon with: GS1WS
9:15:39 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
9:15:39 12 มีนาคม 2561  :try to logon with: GS1WS
9:15:39 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
9:15:39 12 มีนาคม 2561  :try to logon with: GS1WS
9:15:39 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
9:15:39 12 มีนาคม 2561  :try to logon with: GS1WS
9:15:39 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
9:15:39 12 มีนาคม 2561  :try to logon with: GS1WS
9:15:39 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
9:15:39 12 มีนาคม 2561  :try to logon with: GS1WS
9:15:39 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
9:15:39 12 มีนาคม 2561  :try to logon with: GS1WS
9:15:40 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
9:15:40 12 มีนาคม 2561  :try to logon with: GS1WS
9:15:40 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
9:15:40 12 มีนาคม 2561  :try to logon with: GS1WS
9:15:40 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
9:15:40 12 มีนาคม 2561  :try to logon with: GS1WS
9:15:40 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
9:15:40 12 มีนาคม 2561  :try to logon with: GS1WS
9:15:40 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
9:15:40 12 มีนาคม 2561  :try to logon with: GS1WS
9:15:40 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
9:15:40 12 มีนาคม 2561  :try to logon with: GS1WS
9:15:41 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
9:15:41 12 มีนาคม 2561  :try to logon with: GS1WS
9:15:41 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
9:15:41 12 มีนาคม 2561  :try to logon with: GS1WS
9:15:41 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
9:15:41 12 มีนาคม 2561  :try to logon with: GS1WS
9:17:23 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
9:17:23 12 มีนาคม 2561  :try to logon with: GS1WS
9:17:23 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
9:17:23 12 มีนาคม 2561  :try to logon with: GS1WS
9:17:23 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
9:17:23 12 มีนาคม 2561  :try to logon with: GS1WS
9:17:23 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
9:17:23 12 มีนาคม 2561  :try to logon with: GS1WS
9:17:23 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
9:17:23 12 มีนาคม 2561  :try to logon with: GS1WS
9:17:23 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
9:17:23 12 มีนาคม 2561  :try to logon with: GS1WS
9:17:24 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
9:17:24 12 มีนาคม 2561  :try to logon with: GS1WS
9:17:24 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
9:17:24 12 มีนาคม 2561  :try to logon with: GS1WS
9:17:24 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
9:17:24 12 มีนาคม 2561  :try to logon with: GS1WS
9:17:24 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
9:17:24 12 มีนาคม 2561  :try to logon with: GS1WS
9:17:24 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
9:17:24 12 มีนาคม 2561  :try to logon with: GS1WS
9:17:24 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
9:17:24 12 มีนาคม 2561  :try to logon with: GS1WS
9:17:24 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
9:17:24 12 มีนาคม 2561  :try to logon with: GS1WS
9:17:24 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
9:17:24 12 มีนาคม 2561  :try to logon with: GS1WS
9:17:25 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
9:17:25 12 มีนาคม 2561  :try to logon with: GS1WS
9:17:25 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
9:17:25 12 มีนาคม 2561  :try to logon with: GS1WS
9:17:25 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
9:17:25 12 มีนาคม 2561  :try to logon with: GS1WS
9:17:25 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
9:17:25 12 มีนาคม 2561  :try to logon with: GS1WS
9:17:25 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
9:17:25 12 มีนาคม 2561  :try to logon with: GS1WS
9:17:25 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
9:17:25 12 มีนาคม 2561  :try to logon with: GS1WS
9:17:25 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
9:17:25 12 มีนาคม 2561  :try to logon with: GS1WS
9:17:25 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
9:17:25 12 มีนาคม 2561  :try to logon with: GS1WS
9:17:26 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
9:17:26 12 มีนาคม 2561  :try to logon with: GS1WS
9:17:26 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
9:17:26 12 มีนาคม 2561  :try to logon with: GS1WS
9:17:26 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
9:17:26 12 มีนาคม 2561  :try to logon with: GS1WS
9:17:26 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
9:17:26 12 มีนาคม 2561  :try to logon with: GS1WS
9:17:26 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
9:17:26 12 มีนาคม 2561  :try to logon with: GS1WS
9:17:26 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
9:17:26 12 มีนาคม 2561  :try to logon with: GS1WS
9:17:26 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
9:17:26 12 มีนาคม 2561  :try to logon with: GS1WS
9:17:26 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
9:17:26 12 มีนาคม 2561  :try to logon with: GS1WS
9:17:26 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
9:17:26 12 มีนาคม 2561  :try to logon with: GS1WS
9:17:27 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
9:17:27 12 มีนาคม 2561  :try to logon with: GS1WS
9:17:27 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
9:17:27 12 มีนาคม 2561  :try to logon with: GS1WS
9:17:27 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
9:17:27 12 มีนาคม 2561  :try to logon with: GS1WS
9:17:27 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
9:17:27 12 มีนาคม 2561  :try to logon with: GS1WS
9:17:27 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
9:17:27 12 มีนาคม 2561  :try to logon with: GS1WS
9:17:27 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
9:17:27 12 มีนาคม 2561  :try to logon with: GS1WS
9:17:27 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
9:17:27 12 มีนาคม 2561  :try to logon with: GS1WS
9:17:27 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
9:17:27 12 มีนาคม 2561  :try to logon with: GS1WS
9:17:27 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
9:17:27 12 มีนาคม 2561  :try to logon with: GS1WS
9:17:28 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
9:17:28 12 มีนาคม 2561  :try to logon with: GS1WS
9:17:28 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
9:17:28 12 มีนาคม 2561  :try to logon with: GS1WS
9:17:28 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
9:17:28 12 มีนาคม 2561  :try to logon with: GS1WS
9:17:28 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
9:17:28 12 มีนาคม 2561  :try to logon with: GS1WS
9:17:28 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
9:17:28 12 มีนาคม 2561  :try to logon with: GS1WS
9:17:28 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
9:17:28 12 มีนาคม 2561  :try to logon with: GS1WS
9:17:28 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
9:17:28 12 มีนาคม 2561  :try to logon with: GS1WS
9:17:28 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
9:17:28 12 มีนาคม 2561  :try to logon with: GS1WS
9:17:29 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
9:17:29 12 มีนาคม 2561  :try to logon with: GS1WS
9:17:29 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
9:17:29 12 มีนาคม 2561  :try to logon with: GS1WS
9:17:29 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
9:17:29 12 มีนาคม 2561  :try to logon with: GS1WS
9:17:29 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
9:17:29 12 มีนาคม 2561  :try to logon with: GS1WS
9:17:29 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
9:17:29 12 มีนาคม 2561  :try to logon with: GS1WS
9:17:29 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
9:17:29 12 มีนาคม 2561  :try to logon with: GS1WS
9:17:29 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
9:17:29 12 มีนาคม 2561  :try to logon with: GS1WS
9:17:29 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
9:17:29 12 มีนาคม 2561  :try to logon with: GS1WS
9:17:30 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
9:17:30 12 มีนาคม 2561  :try to logon with: GS1WS
9:17:30 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
9:17:30 12 มีนาคม 2561  :try to logon with: GS1WS
9:17:30 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
9:17:30 12 มีนาคม 2561  :try to logon with: GS1WS
9:17:30 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
9:17:30 12 มีนาคม 2561  :try to logon with: GS1WS
9:17:30 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
9:17:30 12 มีนาคม 2561  :try to logon with: GS1WS
9:17:30 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
9:17:30 12 มีนาคม 2561  :try to logon with: GS1WS
9:17:30 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
9:17:30 12 มีนาคม 2561  :try to logon with: GS1WS
9:17:30 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
9:17:30 12 มีนาคม 2561  :try to logon with: GS1WS
9:17:30 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
9:17:30 12 มีนาคม 2561  :try to logon with: GS1WS
9:17:31 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
9:17:31 12 มีนาคม 2561  :try to logon with: GS1WS
9:17:31 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
9:17:31 12 มีนาคม 2561  :try to logon with: GS1WS
9:17:31 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
9:17:31 12 มีนาคม 2561  :try to logon with: GS1WS
9:18:59 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
9:18:59 12 มีนาคม 2561  :try to logon with: GS1WS
9:18:59 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
9:18:59 12 มีนาคม 2561  :try to logon with: GS1WS
9:18:59 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
9:18:59 12 มีนาคม 2561  :try to logon with: GS1WS
9:18:59 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
9:18:59 12 มีนาคม 2561  :try to logon with: GS1WS
9:19:00 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
9:19:00 12 มีนาคม 2561  :try to logon with: GS1WS
9:19:00 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
9:19:00 12 มีนาคม 2561  :try to logon with: GS1WS
9:19:00 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
9:19:00 12 มีนาคม 2561  :try to logon with: GS1WS
9:19:00 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
9:19:00 12 มีนาคม 2561  :try to logon with: GS1WS
9:19:00 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
9:19:00 12 มีนาคม 2561  :try to logon with: GS1WS
9:19:00 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
9:19:00 12 มีนาคม 2561  :try to logon with: GS1WS
9:19:00 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
9:19:00 12 มีนาคม 2561  :try to logon with: GS1WS
9:19:01 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
9:19:01 12 มีนาคม 2561  :try to logon with: GS1WS
9:19:01 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
9:19:01 12 มีนาคม 2561  :try to logon with: GS1WS
9:19:01 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
9:19:01 12 มีนาคม 2561  :try to logon with: GS1WS
9:19:01 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
9:19:01 12 มีนาคม 2561  :try to logon with: GS1WS
9:19:01 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
9:19:01 12 มีนาคม 2561  :try to logon with: GS1WS
9:19:01 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
9:19:01 12 มีนาคม 2561  :try to logon with: GS1WS
9:19:01 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
9:19:01 12 มีนาคม 2561  :try to logon with: GS1WS
9:19:01 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
9:19:01 12 มีนาคม 2561  :try to logon with: GS1WS
9:19:01 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
9:19:01 12 มีนาคม 2561  :try to logon with: GS1WS
9:19:02 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
9:19:02 12 มีนาคม 2561  :try to logon with: GS1WS
9:19:02 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
9:19:02 12 มีนาคม 2561  :try to logon with: GS1WS
9:19:02 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
9:19:02 12 มีนาคม 2561  :try to logon with: GS1WS
9:19:02 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
9:19:02 12 มีนาคม 2561  :try to logon with: GS1WS
9:19:02 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
9:19:02 12 มีนาคม 2561  :try to logon with: GS1WS
9:19:02 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
9:19:02 12 มีนาคม 2561  :try to logon with: GS1WS
9:19:02 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
9:19:02 12 มีนาคม 2561  :try to logon with: GS1WS
9:19:02 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
9:19:02 12 มีนาคม 2561  :try to logon with: GS1WS
9:19:02 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
9:19:02 12 มีนาคม 2561  :try to logon with: GS1WS
9:19:03 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
9:19:03 12 มีนาคม 2561  :try to logon with: GS1WS
9:19:03 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
9:19:03 12 มีนาคม 2561  :try to logon with: GS1WS
9:20:54 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
9:20:54 12 มีนาคม 2561  :try to logon with: GS1WS
9:21:28 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
9:21:28 12 มีนาคม 2561  :try to logon with: GS1WS
9:21:28 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
9:21:28 12 มีนาคม 2561  :try to logon with: GS1WS
9:21:28 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
9:21:28 12 มีนาคม 2561  :try to logon with: GS1WS
9:21:28 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
9:21:28 12 มีนาคม 2561  :try to logon with: GS1WS
9:21:28 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
9:21:28 12 มีนาคม 2561  :try to logon with: GS1WS
9:21:28 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
9:21:28 12 มีนาคม 2561  :try to logon with: GS1WS
9:21:28 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
9:21:28 12 มีนาคม 2561  :try to logon with: GS1WS
9:21:29 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
9:21:29 12 มีนาคม 2561  :try to logon with: GS1WS
9:21:29 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
9:21:29 12 มีนาคม 2561  :try to logon with: GS1WS
9:21:29 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
9:21:29 12 มีนาคม 2561  :try to logon with: GS1WS
9:21:29 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
9:21:29 12 มีนาคม 2561  :try to logon with: GS1WS
9:21:29 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
9:21:29 12 มีนาคม 2561  :try to logon with: GS1WS
9:21:29 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
9:21:29 12 มีนาคม 2561  :try to logon with: GS1WS
9:21:29 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
9:21:29 12 มีนาคม 2561  :try to logon with: GS1WS
9:21:29 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
9:21:29 12 มีนาคม 2561  :try to logon with: GS1WS
9:21:30 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
9:21:30 12 มีนาคม 2561  :try to logon with: GS1WS
9:21:30 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
9:21:30 12 มีนาคม 2561  :try to logon with: GS1WS
9:21:30 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
9:21:30 12 มีนาคม 2561  :try to logon with: GS1WS
9:21:30 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
9:21:30 12 มีนาคม 2561  :try to logon with: GS1WS
9:21:30 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
9:21:30 12 มีนาคม 2561  :try to logon with: GS1WS
9:21:30 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
9:21:30 12 มีนาคม 2561  :try to logon with: GS1WS
9:21:30 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
9:21:30 12 มีนาคม 2561  :try to logon with: GS1WS
9:21:30 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
9:21:30 12 มีนาคม 2561  :try to logon with: GS1WS
9:21:31 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
9:21:31 12 มีนาคม 2561  :try to logon with: GS1WS
9:21:31 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
9:21:31 12 มีนาคม 2561  :try to logon with: GS1WS
9:21:31 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
9:21:31 12 มีนาคม 2561  :try to logon with: GS1WS
9:21:31 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
9:21:31 12 มีนาคม 2561  :try to logon with: GS1WS
9:21:31 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
9:21:31 12 มีนาคม 2561  :try to logon with: GS1WS
9:21:31 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
9:21:31 12 มีนาคม 2561  :try to logon with: GS1WS
9:21:31 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
9:21:31 12 มีนาคม 2561  :try to logon with: GS1WS
9:21:31 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
9:21:31 12 มีนาคม 2561  :try to logon with: GS1WS
10:00:34 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
10:00:34 12 มีนาคม 2561  :try to logon with: GS1WS
10:00:34 12 มีนาคม 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:34 12 มีนาคม 2561  :There is already an object named 'tempWsGs1_001' in the database.
10:09:19 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
10:09:19 12 มีนาคม 2561  :try to logon with: GS1WS
10:21:15 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
10:21:15 12 มีนาคม 2561  :try to logon with: GS1WS
10:22:23 12 มีนาคม 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:45:23 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
10:45:23 12 มีนาคม 2561  :try to logon with: GS1WS
10:55:12 12 มีนาคม 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.
11:00:36 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
11:00:36 12 มีนาคม 2561  :try to logon with: GS1WS
11:00:36 12 มีนาคม 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:36 12 มีนาคม 2561  :There is already an object named 'tempWsGs1_001' in the database.
11:00:39 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
11:00:39 12 มีนาคม 2561  :try to logon with: GS1WS
11:01:34 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
11:01:34 12 มีนาคม 2561  :try to logon with: GS1WS
11:01:56 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
11:01:56 12 มีนาคม 2561  :try to logon with: GS1WS
11:02:44 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
11:02:44 12 มีนาคม 2561  :try to logon with: GS1WS
11:02:58 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
11:02:58 12 มีนาคม 2561  :try to logon with: GS1WS
11:04:34 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
11:04:34 12 มีนาคม 2561  :try to logon with: GS1WS
11:05:22 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
11:05:22 12 มีนาคม 2561  :try to logon with: GS1WS
11:07:50 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
11:07:50 12 มีนาคม 2561  :try to logon with: GS1WS
11:09:12 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
11:09:12 12 มีนาคม 2561  :try to logon with: GS1WS
11:15:52 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
11:15:52 12 มีนาคม 2561  :try to logon with: GS1WS
11:17:19 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
11:17:19 12 มีนาคม 2561  :try to logon with: GS1WS
11:17:35 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
11:17:35 12 มีนาคม 2561  :try to logon with: GS1WS
11:17:52 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
11:17:52 12 มีนาคม 2561  :try to logon with: GS1WS
11:18:08 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
11:18:08 12 มีนาคม 2561  :try to logon with: GS1WS
11:19:56 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
11:19:56 12 มีนาคม 2561  :try to logon with: GS1WS
11:21:03 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
11:21:03 12 มีนาคม 2561  :try to logon with: GS1WS
11:30:56 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
11:30:56 12 มีนาคม 2561  :try to logon with: GS1WS
11:42:09 12 มีนาคม 2561  :Server was unable to process request. ---> Cannot open database "RDtmp" requested by the login. The login failed.
12:00:42 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
12:00:42 12 มีนาคม 2561  :try to logon with: GS1WS
12:00:42 12 มีนาคม 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:42 12 มีนาคม 2561  :There is already an object named 'tempWsGs1_001' in the database.
12:16:33 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
12:16:33 12 มีนาคม 2561  :try to logon with: GS1WS
12:38:37 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
12:38:37 12 มีนาคม 2561  :try to logon with: GS1WS
12:50:39 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
12:50:39 12 มีนาคม 2561  :try to logon with: GS1WS
13:00:19 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
13:00:19 12 มีนาคม 2561  :try to logon with: GS1WS
13:00:34 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
13:00:34 12 มีนาคม 2561  :try to logon with: GS1WS
13:00:34 12 มีนาคม 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:34 12 มีนาคม 2561  :There is already an object named 'tempWsGs1_001' in the database.
13:08:13 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
13:08:13 12 มีนาคม 2561  :try to logon with: GS1WS
13:09:18 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
13:09:18 12 มีนาคม 2561  :try to logon with: GS1WS
13:10:05 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
13:10:05 12 มีนาคม 2561  :try to logon with: GS1WS
13:11:49 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
13:11:49 12 มีนาคม 2561  :try to logon with: GS1WS
13:12:02 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
13:12:02 12 มีนาคม 2561  :try to logon with: GS1WS
13:13:49 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
13:13:49 12 มีนาคม 2561  :try to logon with: GS1WS
13:22:18 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
13:22:18 12 มีนาคม 2561  :try to logon with: GS1WS
13:24:53 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
13:24:53 12 มีนาคม 2561  :try to logon with: GS1WS
13:28:16 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
13:28:16 12 มีนาคม 2561  :try to logon with: GS1WS
13:35:03 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
13:35:03 12 มีนาคม 2561  :try to logon with: GS1WS
13:38:05 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
13:38:05 12 มีนาคม 2561  :try to logon with: GS1WS
13:38:48 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
13:38:48 12 มีนาคม 2561  :try to logon with: GS1WS
13:40:28 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
13:40:28 12 มีนาคม 2561  :try to logon with: GS1WS
13:44:30 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
13:44:30 12 มีนาคม 2561  :try to logon with: GS1WS
13:49:14 12 มีนาคม 2561  :Server was unable to process request. ---> Cannot open database "RDtmp" requested by the login. The login failed.
13:49:36 12 มีนาคม 2561  :Server was unable to process request. ---> Cannot open database "RDtmp" requested by the login. The login failed.
14:00:34 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
14:00:34 12 มีนาคม 2561  :try to logon with: GS1WS
14:00:34 12 มีนาคม 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:34 12 มีนาคม 2561  :There is already an object named 'tempWsGs1_001' in the database.
14:18:22 12 มีนาคม 2561  :Server was unable to process request. ---> Cannot open database "RDtmp" requested by the login. The login failed.
14:23:14 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
14:23:15 12 มีนาคม 2561  :try to logon with: GS1WS
14:28:17 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
14:28:17 12 มีนาคม 2561  :try to logon with: GS1WS
14:48:50 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
14:48:50 12 มีนาคม 2561  :try to logon with: GS1WS
14:51:28 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
14:51:28 12 มีนาคม 2561  :try to logon with: GS1WS
14:56:05 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
14:56:05 12 มีนาคม 2561  :try to logon with: GS1WS
15:00:34 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
15:00:34 12 มีนาคม 2561  :try to logon with: GS1WS
15:00:34 12 มีนาคม 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:34 12 มีนาคม 2561  :There is already an object named 'tempWsGs1_001' in the database.
15:01:26 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
15:01:26 12 มีนาคม 2561  :try to logon with: GS1WS
15:10:12 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
15:10:12 12 มีนาคม 2561  :try to logon with: GS1WS
15:12:33 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
15:12:33 12 มีนาคม 2561  :try to logon with: GS1WS
15:14:50 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
15:14:50 12 มีนาคม 2561  :try to logon with: GS1WS
15:15:04 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
15:15:04 12 มีนาคม 2561  :try to logon with: GS1WS
15:20:48 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
15:20:48 12 มีนาคม 2561  :try to logon with: GS1WS
15:23:27 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
15:23:27 12 มีนาคม 2561  :try to logon with: GS1WS
15:25:31 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
15:25:31 12 มีนาคม 2561  :try to logon with: GS1WS
15:31:24 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
15:31:24 12 มีนาคม 2561  :try to logon with: GS1WS
15:32:19 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
15:32:19 12 มีนาคม 2561  :try to logon with: GS1WS
15:35:19 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
15:35:19 12 มีนาคม 2561  :try to logon with: GS1WS
15:37:02 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
15:37:02 12 มีนาคม 2561  :try to logon with: GS1WS
15:40:11 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
15:40:11 12 มีนาคม 2561  :try to logon with: GS1WS
15:43:14 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
15:43:14 12 มีนาคม 2561  :try to logon with: GS1WS
15:48:29 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
15:48:29 12 มีนาคม 2561  :try to logon with: GS1WS
15:53:39 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
15:53:39 12 มีนาคม 2561  :try to logon with: GS1WS
16:00:38 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
16:00:38 12 มีนาคม 2561  :try to logon with: GS1WS
16:00:38 12 มีนาคม 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:38 12 มีนาคม 2561  :There is already an object named 'tempWsGs1_001' in the database.
16:02:04 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
16:02:04 12 มีนาคม 2561  :try to logon with: GS1WS
16:07:13 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
16:07:13 12 มีนาคม 2561  :try to logon with: GS1WS
16:07:20 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
16:07:20 12 มีนาคม 2561  :try to logon with: GS1WS
16:13:23 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
16:13:23 12 มีนาคม 2561  :try to logon with: GS1WS
16:17:22 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
16:17:22 12 มีนาคม 2561  :try to logon with: GS1WS
16:20:21 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
16:20:21 12 มีนาคม 2561  :try to logon with: GS1WS
16:20:58 12 มีนาคม 2561  :Server was unable to process request. ---> [DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied.
16:22:43 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
16:22:43 12 มีนาคม 2561  :try to logon with: GS1WS
16:24:48 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
16:24:48 12 มีนาคม 2561  :try to logon with: GS1WS
16:27:38 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
16:27:38 12 มีนาคม 2561  :try to logon with: GS1WS
16:29:32 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
16:29:32 12 มีนาคม 2561  :try to logon with: GS1WS
16:31:48 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
16:31:48 12 มีนาคม 2561  :try to logon with: GS1WS
16:34:00 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
16:34:00 12 มีนาคม 2561  :try to logon with: GS1WS
16:37:23 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
16:37:23 12 มีนาคม 2561  :try to logon with: GS1WS
16:39:22 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
16:39:22 12 มีนาคม 2561  :try to logon with: GS1WS
16:40:01 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
16:40:01 12 มีนาคม 2561  :try to logon with: GS1WS
16:42:25 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
16:42:25 12 มีนาคม 2561  :try to logon with: GS1WS
16:43:45 12 มีนาคม 2561  :SUCCESS // INSERT INTO TR_TRANS_BOOK_MAS (COURSE_CODE, OWNER_DIV_CODE, TRAINEE_CODE, BOOK_PERSON_NUMB, REGIST_CODE,                          TAX_ID, ADDR_NOTE, ATTN_NAME_TH, ATTN_NAME_EN, ADDR1TH_NO, ADDR1TH_MOO, ADDR1TH_SOI, ADDR1TH_ROAD, ADDR1TH_SUB_DISTRICT, ADDR1TH_DISTRICT, ADDR1TH_PROVINCE_NAME,                          ADDR1EN_NO, ADDR1EN_MOO, ADDR1EN_SOI, ADDR1EN_ROAD, ADDR1EN_SUB_DISTRICT, ADDR1EN_DISTRICT, ADDR1EN_PROVINCE_NAME, ADDR1_POSTCODE, ADDR1_TELEPHONE, ADDR1_FAX,                          ADDR2TH_NO, ADDR2TH_MOO, ADDR2TH_SOI, ADDR2TH_ROAD, ADDR2TH_SUB_DISTRICT, ADDR2TH_DISTRICT, ADDR2TH_PROVINCE_NAME, ADDR2EN_NO, ADDR2EN_MOO, ADDR2EN_SOI,                          ADDR2EN_ROAD, ADDR2EN_SUB_DISTRICT, ADDR2EN_DISTRICT, ADDR2EN_PROVINCE_NAME, ADDR2_POSTCODE, ADDR2_TELEPHONE, ADDR2_FAX, TRAINEE_TYPE_CODE  ,SEQ) VALUES        (@p0,@p1,@p2,@p3,@p4,@p5,@p6,@p7,@p8,@p9,@p10,@p11,@p12,@p13,@p14,@p15,@p16,@p17,@p18,@p19,@p20,@p21,@p22,@p23,@p24,@p25,@p26,@p27,@p28,@p29,@p30,@p31,@p32,@p33,@p34,@p35,@p36,@p37,@p38,@p39,@p40,@p41,@p42,@p43  ,@p44) 
16:43:48 12 มีนาคม 2561  :SUCCESS // INSERT INTO TR_TRANS_BOOK_DET (COURSE_CODE, OWNER_DIV_CODE, TRAINEE_CODE, P_SEQ_NO, FLAG_CONFIRM, TRAIN_COST_AMNT, APPLY_DATE,SEQ) VALUES (@p0,@p1,@p2,@p3,@p4,@p5,getdate(),@p6)
16:44:52 12 มีนาคม 2561  :SUCCESS // UPDATE TR_TRANS_BOOK_DET Set DISCOUNT_AMNT = @p0, FLAG_CONFIRM='Y' WHERE COURSE_CODE=@p1 AND OWNER_DIV_CODE=@p2 AND TRAINEE_CODE=@p3 AND P_SEQ_NO=@p4
16:44:56 12 มีนาคม 2561  :SUCCESS // UPDATE TR_TRANS_BOOK_DET SET   PERSON_TRAINEE_PREN = @p4, PERSON_TRAINEE_FNAM = @p5, PERSON_TRAINEE_LNAM = @p6, PERSON_TRAINEE_POSI = @p7,                         BILL_TYPE_CODE = @p8, PAY_TYPE_CODE = @p9, APPLY_DATE = @p10, CANCEL_DATE = @p11, FLAG_CONFIRM = @p12, TRAIN_COST_AMNT = @p13, REMARK = @p14,                          DISC_AMT_BY_TYPE = @p15, DISC_AMT_BY_NUMB = @p16, TRAINEE_TELEPHONE = @p17, TRAINEE_EMAIL = @p18 WHERE        (COURSE_CODE = @p0) And (TRAINEE_CODE = @p1) AND (SEQ = @p2) and (P_SEQ_NO = @p3) 
16:45:19 12 มีนาคม 2561  :SUCCESS // UPDATE TR_TRANS_BOOK_DET SET   PERSON_TRAINEE_PREN = @p4, PERSON_TRAINEE_FNAM = @p5, PERSON_TRAINEE_LNAM = @p6, PERSON_TRAINEE_POSI = @p7,                         BILL_TYPE_CODE = @p8, PAY_TYPE_CODE = @p9, APPLY_DATE = @p10, CANCEL_DATE = @p11, FLAG_CONFIRM = @p12, TRAIN_COST_AMNT = @p13, REMARK = @p14,                          DISC_AMT_BY_TYPE = @p15, DISC_AMT_BY_NUMB = @p16, TRAINEE_TELEPHONE = @p17, TRAINEE_EMAIL = @p18 WHERE        (COURSE_CODE = @p0) And (TRAINEE_CODE = @p1) AND (SEQ = @p2) and (P_SEQ_NO = @p3) 
16:45:25 12 มีนาคม 2561  :SUCCESS // INSERT INTO FIN_DOC_RUNNING (OU_CODE,DIV_CODE,BUDGET_YEAR,PERIOD,SUB_TYPE,DOC_RUNNING_NO,CR_BY,CR_DATE,PROG_ID) VALUES (@p0,@p1,@p2,@p3,@p4,@p5,@p6,@p7,@p8)
16:45:26 12 มีนาคม 2561  :SUCCESS // INSERT INTO FIN_PN_IV_DETAIL (OU_CODE,DIV_CODE,SUB_TYPE,TRAN_NO,SEQ,REF_SEQ,SUB_SECTION_CODE,QTY,U_PRICE,U_PRICE_VAT,U_PRICE_INC_VAT,NET_U_PRICE,NET_U_PRICE_VAT,NET_U_PRICE_INC_VAT,DISC_AMT,DISC_AMT_VAT,DISC_AMT_INC_VAT,TOTAL,TOTAL_VAT,SUM_TOTAL,U_PRICE_EX,U_PRICE_VAT_EX,U_PRICE_INC_VAT_EX,NET_U_PRICE_EX,NET_U_PRICE_VAT_EX,NET_U_PRICE_INC_VAT_EX,DISC_AMT_EX,DISC_AMT_VAT_EX,DISC_AMT_INC_VAT_EX,TOTAL_EX,TOTAL_VAT_EX,SUM_TOTAL_EX,TOP_DISC_AMT,NOTE,PROG_ID,MB_YEAR,BAL_AMT,DN_AMT,CN_AMT,PAY_AMT,RN_AMT,BUDGET_YEAR,PAY_AMT_EX,BAL_AMT_EX,DEBIT_NOTE_TERM) VALUES (@p0,@p1,@p2,@p3,@p4,@p5,@p6,@p7,@p8,@p9,@p10,@p11,@p12,@p13,@p14,@p15,@p16,@p17,@p18,@p19,@p20,@p21,@p22,@p23,@p24,@p25,@p26,@p27,@p28,@p29,@p30,@p31,@p32,@p33,@p34,@p35,@p36,@p37,@p38,@p39,@p40,@p41,@p42,@p43,@p44)
16:45:26 12 มีนาคม 2561  :SUCCESS // INSERT INTO FIN_PN_IV_HEAD (OU_CODE,DIV_CODE,TRAN_NO,TRAN_DATE,TRAN_TYPE,TRAN_SUB_TYPE,BUDGET_YEAR,BUDGET_PERIOD,ATV_CODE,CURR_CODE,VAT_RATE,U_PRICE,U_PRICE_VAT,U_PRICE_INC_VAT,NET_U_PRICE,NET_U_PRICE_VAT,NET_U_PRICE_INC_VAT,DISC_AMT,DISC_AMT_VAT,DISC_AMT_INC_VAT,TOTAL,TOTAL_VAT,SUM_TOTAL,U_PRICE_EX,U_PRICE_VAT_EX,U_PRICE_INC_VAT_EX,NET_U_PRICE_EX,NET_U_PRICE_VAT_EX,NET_U_PRICE_INC_VAT_EX,DISC_AMT_EX,DISC_AMT_VAT_EX,DISC_AMT_INC_VAT_EX,TOTAL_EX,TOTAL_VAT_EX,SUM_TOTAL_EX,EX_RATE,TOP_DISC_AMT,TOP_DISC_NOTE,GRAND_AMT,PAY_AMT,BAL_AMT,PAY_AMT_EX,BAL_AMT_EX,NOTE,CANCEL_FLAG,CANCEL_REASON,CANCEL_BY,PRINT_NUM,CR_BY,CR_DATE,UPD_BY,UPD_DATE,PROG_ID,MB_MEMBER_CODE,AR_CODE,COMP_PERSON_CODE,CR_TERM,DUE_DATE,VAT_TYPE,RN_AMT,TAX_ID,POST_INVOICE_FLAG,INNER_NOTE,CANCEL_REJECT_REASON,POST_INVOICE_REJECT_REASON,TELEPHONE1,TELEPHONE2,FAX1,FAX2,ATTN_NAME_TH,ATTN_NAME_EN,BRANCH_NAME_TH,BRANCH_NAME_EN,COMP_PERSON_NAME_TH,COMP_PERSON_NAME_EN,ADDR_TAXINVOICE_1_TH,ADDR_TAXINVOICE_2_TH,ADDR_TAXINVOICE_3_TH,ADDR_TAXINVOICE_1_EN,ADDR_TAXINVOICE_2_EN,ADDR_TAXINVOICE_3_EN,ADDR_DELIVERY_1_TH,ADDR_DELIVERY_2_TH,ADDR_DELIVERY_3_TH,ADDR_DELIVERY_1_EN,ADDR_DELIVERY_2_EN,ADDR_DELIVERY_3_EN,EXCHANGE_FLAG,REGIST_CODE) VALUES (@p0,@p1,@p2,@p3,@p4,@p5,@p6,@p7,@p8,@p9,@p10,@p11,@p12,@p13,@p14,@p15,@p16,@p17,@p18,@p19,@p20,@p21,@p22,@p23,@p24,@p25,@p26,@p27,@p28,@p29,@p30,@p31,@p32,@p33,@p34,@p35,@p36,@p37,@p38,@p39,@p40,@p41,@p42,@p43,@p44,@p45,@p46,@p47,@p48,@p49,@p50,@p51,@p52,@p53,@p54,@p55,@p56,@p57,@p58,@p59,@p60,@p61,@p62,@p63,@p64,@p65,@p66,@p67,@p68,@p69,@p70,@p71,@p72,@p73,@p74,@p75,@p76,@p77,@p78,@p79,@p80,@p81,@p82,@p83,@p84,@p85,@p86,@p87,@p88)
16:45:26 12 มีนาคม 2561  :SUCCESS // UPDATE TR_TRANS_BOOK_DET SET DISCOUNT_AMNT = @p0, TRAIN_COST_AMNT = @p1, TRAINEE_RATE_AMNT = @p2 WHERE COURSE_CODE = @p3 AND OWNER_DIV_CODE = @p4 AND TRAINEE_CODE = @p5 AND P_SEQ_NO=@p6
16:45:26 12 มีนาคม 2561  :SUCCESS // UPDATE TR_TRANS_BOOK_MAS SET TRANSFER_FLAG = @p0, TRAN_NO=@p1 WHERE COURSE_CODE = @p2 AND OWNER_DIV_CODE = @p3 AND TRAINEE_CODE = @p4 AND SEQ = @p5 
16:46:06 12 มีนาคม 2561  :SUCCESS // INSERT INTO TR_TRANS_BOOK_MAS (COURSE_CODE, OWNER_DIV_CODE, TRAINEE_CODE, BOOK_PERSON_NUMB, REGIST_CODE,                          TAX_ID, ADDR_NOTE, ATTN_NAME_TH, ATTN_NAME_EN, ADDR1TH_NO, ADDR1TH_MOO, ADDR1TH_SOI, ADDR1TH_ROAD, ADDR1TH_SUB_DISTRICT, ADDR1TH_DISTRICT, ADDR1TH_PROVINCE_NAME,                          ADDR1EN_NO, ADDR1EN_MOO, ADDR1EN_SOI, ADDR1EN_ROAD, ADDR1EN_SUB_DISTRICT, ADDR1EN_DISTRICT, ADDR1EN_PROVINCE_NAME, ADDR1_POSTCODE, ADDR1_TELEPHONE, ADDR1_FAX,                          ADDR2TH_NO, ADDR2TH_MOO, ADDR2TH_SOI, ADDR2TH_ROAD, ADDR2TH_SUB_DISTRICT, ADDR2TH_DISTRICT, ADDR2TH_PROVINCE_NAME, ADDR2EN_NO, ADDR2EN_MOO, ADDR2EN_SOI,                          ADDR2EN_ROAD, ADDR2EN_SUB_DISTRICT, ADDR2EN_DISTRICT, ADDR2EN_PROVINCE_NAME, ADDR2_POSTCODE, ADDR2_TELEPHONE, ADDR2_FAX, TRAINEE_TYPE_CODE  ,SEQ) VALUES        (@p0,@p1,@p2,@p3,@p4,@p5,@p6,@p7,@p8,@p9,@p10,@p11,@p12,@p13,@p14,@p15,@p16,@p17,@p18,@p19,@p20,@p21,@p22,@p23,@p24,@p25,@p26,@p27,@p28,@p29,@p30,@p31,@p32,@p33,@p34,@p35,@p36,@p37,@p38,@p39,@p40,@p41,@p42,@p43  ,@p44) 
16:46:23 12 มีนาคม 2561  :SUCCESS // INSERT INTO TR_TRANS_BOOK_DET (COURSE_CODE, OWNER_DIV_CODE, TRAINEE_CODE, P_SEQ_NO, FLAG_CONFIRM, TRAIN_COST_AMNT, APPLY_DATE,SEQ) VALUES (@p0,@p1,@p2,@p3,@p4,@p5,getdate(),@p6)
16:46:41 12 มีนาคม 2561  :SUCCESS // UPDATE TR_TRANS_BOOK_DET Set DISCOUNT_AMNT = @p0, FLAG_CONFIRM='Y' WHERE COURSE_CODE=@p1 AND OWNER_DIV_CODE=@p2 AND TRAINEE_CODE=@p3 AND P_SEQ_NO=@p4
16:46:59 12 มีนาคม 2561  :SUCCESS // UPDATE TR_TRANS_BOOK_DET SET   PERSON_TRAINEE_PREN = @p4, PERSON_TRAINEE_FNAM = @p5, PERSON_TRAINEE_LNAM = @p6, PERSON_TRAINEE_POSI = @p7,                         BILL_TYPE_CODE = @p8, PAY_TYPE_CODE = @p9, APPLY_DATE = @p10, CANCEL_DATE = @p11, FLAG_CONFIRM = @p12, TRAIN_COST_AMNT = @p13, REMARK = @p14,                          DISC_AMT_BY_TYPE = @p15, DISC_AMT_BY_NUMB = @p16, TRAINEE_TELEPHONE = @p17, TRAINEE_EMAIL = @p18 WHERE        (COURSE_CODE = @p0) And (TRAINEE_CODE = @p1) AND (SEQ = @p2) and (P_SEQ_NO = @p3) 
16:47:03 12 มีนาคม 2561  :SUCCESS // INSERT INTO FIN_DOC_RUNNING (OU_CODE,DIV_CODE,BUDGET_YEAR,PERIOD,SUB_TYPE,DOC_RUNNING_NO,CR_BY,CR_DATE,PROG_ID) VALUES (@p0,@p1,@p2,@p3,@p4,@p5,@p6,@p7,@p8)
16:47:03 12 มีนาคม 2561  :SUCCESS // INSERT INTO FIN_PN_IV_DETAIL (OU_CODE,DIV_CODE,SUB_TYPE,TRAN_NO,SEQ,REF_SEQ,SUB_SECTION_CODE,QTY,U_PRICE,U_PRICE_VAT,U_PRICE_INC_VAT,NET_U_PRICE,NET_U_PRICE_VAT,NET_U_PRICE_INC_VAT,DISC_AMT,DISC_AMT_VAT,DISC_AMT_INC_VAT,TOTAL,TOTAL_VAT,SUM_TOTAL,U_PRICE_EX,U_PRICE_VAT_EX,U_PRICE_INC_VAT_EX,NET_U_PRICE_EX,NET_U_PRICE_VAT_EX,NET_U_PRICE_INC_VAT_EX,DISC_AMT_EX,DISC_AMT_VAT_EX,DISC_AMT_INC_VAT_EX,TOTAL_EX,TOTAL_VAT_EX,SUM_TOTAL_EX,TOP_DISC_AMT,NOTE,PROG_ID,MB_YEAR,BAL_AMT,DN_AMT,CN_AMT,PAY_AMT,RN_AMT,BUDGET_YEAR,PAY_AMT_EX,BAL_AMT_EX,DEBIT_NOTE_TERM) VALUES (@p0,@p1,@p2,@p3,@p4,@p5,@p6,@p7,@p8,@p9,@p10,@p11,@p12,@p13,@p14,@p15,@p16,@p17,@p18,@p19,@p20,@p21,@p22,@p23,@p24,@p25,@p26,@p27,@p28,@p29,@p30,@p31,@p32,@p33,@p34,@p35,@p36,@p37,@p38,@p39,@p40,@p41,@p42,@p43,@p44)
16:47:03 12 มีนาคม 2561  :SUCCESS // INSERT INTO FIN_PN_IV_HEAD (OU_CODE,DIV_CODE,TRAN_NO,TRAN_DATE,TRAN_TYPE,TRAN_SUB_TYPE,BUDGET_YEAR,BUDGET_PERIOD,ATV_CODE,CURR_CODE,VAT_RATE,U_PRICE,U_PRICE_VAT,U_PRICE_INC_VAT,NET_U_PRICE,NET_U_PRICE_VAT,NET_U_PRICE_INC_VAT,DISC_AMT,DISC_AMT_VAT,DISC_AMT_INC_VAT,TOTAL,TOTAL_VAT,SUM_TOTAL,U_PRICE_EX,U_PRICE_VAT_EX,U_PRICE_INC_VAT_EX,NET_U_PRICE_EX,NET_U_PRICE_VAT_EX,NET_U_PRICE_INC_VAT_EX,DISC_AMT_EX,DISC_AMT_VAT_EX,DISC_AMT_INC_VAT_EX,TOTAL_EX,TOTAL_VAT_EX,SUM_TOTAL_EX,EX_RATE,TOP_DISC_AMT,TOP_DISC_NOTE,GRAND_AMT,PAY_AMT,BAL_AMT,PAY_AMT_EX,BAL_AMT_EX,NOTE,CANCEL_FLAG,CANCEL_REASON,CANCEL_BY,PRINT_NUM,CR_BY,CR_DATE,UPD_BY,UPD_DATE,PROG_ID,MB_MEMBER_CODE,AR_CODE,COMP_PERSON_CODE,CR_TERM,DUE_DATE,VAT_TYPE,RN_AMT,TAX_ID,POST_INVOICE_FLAG,INNER_NOTE,CANCEL_REJECT_REASON,POST_INVOICE_REJECT_REASON,TELEPHONE1,TELEPHONE2,FAX1,FAX2,ATTN_NAME_TH,ATTN_NAME_EN,BRANCH_NAME_TH,BRANCH_NAME_EN,COMP_PERSON_NAME_TH,COMP_PERSON_NAME_EN,ADDR_TAXINVOICE_1_TH,ADDR_TAXINVOICE_2_TH,ADDR_TAXINVOICE_3_TH,ADDR_TAXINVOICE_1_EN,ADDR_TAXINVOICE_2_EN,ADDR_TAXINVOICE_3_EN,ADDR_DELIVERY_1_TH,ADDR_DELIVERY_2_TH,ADDR_DELIVERY_3_TH,ADDR_DELIVERY_1_EN,ADDR_DELIVERY_2_EN,ADDR_DELIVERY_3_EN,EXCHANGE_FLAG,REGIST_CODE) VALUES (@p0,@p1,@p2,@p3,@p4,@p5,@p6,@p7,@p8,@p9,@p10,@p11,@p12,@p13,@p14,@p15,@p16,@p17,@p18,@p19,@p20,@p21,@p22,@p23,@p24,@p25,@p26,@p27,@p28,@p29,@p30,@p31,@p32,@p33,@p34,@p35,@p36,@p37,@p38,@p39,@p40,@p41,@p42,@p43,@p44,@p45,@p46,@p47,@p48,@p49,@p50,@p51,@p52,@p53,@p54,@p55,@p56,@p57,@p58,@p59,@p60,@p61,@p62,@p63,@p64,@p65,@p66,@p67,@p68,@p69,@p70,@p71,@p72,@p73,@p74,@p75,@p76,@p77,@p78,@p79,@p80,@p81,@p82,@p83,@p84,@p85,@p86,@p87,@p88)
16:47:04 12 มีนาคม 2561  :SUCCESS // UPDATE TR_TRANS_BOOK_DET SET DISCOUNT_AMNT = @p0, TRAIN_COST_AMNT = @p1, TRAINEE_RATE_AMNT = @p2 WHERE COURSE_CODE = @p3 AND OWNER_DIV_CODE = @p4 AND TRAINEE_CODE = @p5 AND P_SEQ_NO=@p6
16:47:04 12 มีนาคม 2561  :SUCCESS // UPDATE TR_TRANS_BOOK_MAS SET TRANSFER_FLAG = @p0, TRAN_NO=@p1 WHERE COURSE_CODE = @p2 AND OWNER_DIV_CODE = @p3 AND TRAINEE_CODE = @p4 AND SEQ = @p5 
16:47:21 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
16:47:21 12 มีนาคม 2561  :try to logon with: GS1WS
16:51:30 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
16:51:30 12 มีนาคม 2561  :try to logon with: GS1WS
16:54:29 12 มีนาคม 2561  :SUCCESS // INSERT INTO TR_TRANS_BOOK_MAS (COURSE_CODE, OWNER_DIV_CODE, TRAINEE_CODE, BOOK_PERSON_NUMB, REGIST_CODE,                          TAX_ID, ADDR_NOTE, ATTN_NAME_TH, ATTN_NAME_EN, ADDR1TH_NO, ADDR1TH_MOO, ADDR1TH_SOI, ADDR1TH_ROAD, ADDR1TH_SUB_DISTRICT, ADDR1TH_DISTRICT, ADDR1TH_PROVINCE_NAME,                          ADDR1EN_NO, ADDR1EN_MOO, ADDR1EN_SOI, ADDR1EN_ROAD, ADDR1EN_SUB_DISTRICT, ADDR1EN_DISTRICT, ADDR1EN_PROVINCE_NAME, ADDR1_POSTCODE, ADDR1_TELEPHONE, ADDR1_FAX,                          ADDR2TH_NO, ADDR2TH_MOO, ADDR2TH_SOI, ADDR2TH_ROAD, ADDR2TH_SUB_DISTRICT, ADDR2TH_DISTRICT, ADDR2TH_PROVINCE_NAME, ADDR2EN_NO, ADDR2EN_MOO, ADDR2EN_SOI,                          ADDR2EN_ROAD, ADDR2EN_SUB_DISTRICT, ADDR2EN_DISTRICT, ADDR2EN_PROVINCE_NAME, ADDR2_POSTCODE, ADDR2_TELEPHONE, ADDR2_FAX, TRAINEE_TYPE_CODE  ,SEQ) VALUES        (@p0,@p1,@p2,@p3,@p4,@p5,@p6,@p7,@p8,@p9,@p10,@p11,@p12,@p13,@p14,@p15,@p16,@p17,@p18,@p19,@p20,@p21,@p22,@p23,@p24,@p25,@p26,@p27,@p28,@p29,@p30,@p31,@p32,@p33,@p34,@p35,@p36,@p37,@p38,@p39,@p40,@p41,@p42,@p43  ,@p44) 
16:54:32 12 มีนาคม 2561  :SUCCESS // INSERT INTO TR_TRANS_BOOK_DET (COURSE_CODE, OWNER_DIV_CODE, TRAINEE_CODE, P_SEQ_NO, FLAG_CONFIRM, TRAIN_COST_AMNT, APPLY_DATE,SEQ) VALUES (@p0,@p1,@p2,@p3,@p4,@p5,getdate(),@p6)
16:54:44 12 มีนาคม 2561  :SUCCESS // UPDATE TR_TRANS_BOOK_DET Set DISCOUNT_AMNT = @p0, FLAG_CONFIRM='Y' WHERE COURSE_CODE=@p1 AND OWNER_DIV_CODE=@p2 AND TRAINEE_CODE=@p3 AND P_SEQ_NO=@p4
16:54:52 12 มีนาคม 2561  :SUCCESS // UPDATE TR_TRANS_BOOK_DET Set DISCOUNT_AMNT = @p0, FLAG_CONFIRM='Y' WHERE COURSE_CODE=@p1 AND OWNER_DIV_CODE=@p2 AND TRAINEE_CODE=@p3 AND P_SEQ_NO=@p4
16:55:13 12 มีนาคม 2561  :SUCCESS // UPDATE TR_TRANS_BOOK_DET SET   PERSON_TRAINEE_PREN = @p4, PERSON_TRAINEE_FNAM = @p5, PERSON_TRAINEE_LNAM = @p6, PERSON_TRAINEE_POSI = @p7,                         BILL_TYPE_CODE = @p8, PAY_TYPE_CODE = @p9, APPLY_DATE = @p10, CANCEL_DATE = @p11, FLAG_CONFIRM = @p12, TRAIN_COST_AMNT = @p13, REMARK = @p14,                          DISC_AMT_BY_TYPE = @p15, DISC_AMT_BY_NUMB = @p16, TRAINEE_TELEPHONE = @p17, TRAINEE_EMAIL = @p18 WHERE        (COURSE_CODE = @p0) And (TRAINEE_CODE = @p1) AND (SEQ = @p2) and (P_SEQ_NO = @p3) 
16:55:17 12 มีนาคม 2561  :SUCCESS // INSERT INTO FIN_DOC_RUNNING (OU_CODE,DIV_CODE,BUDGET_YEAR,PERIOD,SUB_TYPE,DOC_RUNNING_NO,CR_BY,CR_DATE,PROG_ID) VALUES (@p0,@p1,@p2,@p3,@p4,@p5,@p6,@p7,@p8)
16:55:18 12 มีนาคม 2561  :SUCCESS // INSERT INTO FIN_PN_IV_DETAIL (OU_CODE,DIV_CODE,SUB_TYPE,TRAN_NO,SEQ,REF_SEQ,SUB_SECTION_CODE,QTY,U_PRICE,U_PRICE_VAT,U_PRICE_INC_VAT,NET_U_PRICE,NET_U_PRICE_VAT,NET_U_PRICE_INC_VAT,DISC_AMT,DISC_AMT_VAT,DISC_AMT_INC_VAT,TOTAL,TOTAL_VAT,SUM_TOTAL,U_PRICE_EX,U_PRICE_VAT_EX,U_PRICE_INC_VAT_EX,NET_U_PRICE_EX,NET_U_PRICE_VAT_EX,NET_U_PRICE_INC_VAT_EX,DISC_AMT_EX,DISC_AMT_VAT_EX,DISC_AMT_INC_VAT_EX,TOTAL_EX,TOTAL_VAT_EX,SUM_TOTAL_EX,TOP_DISC_AMT,NOTE,PROG_ID,MB_YEAR,BAL_AMT,DN_AMT,CN_AMT,PAY_AMT,RN_AMT,BUDGET_YEAR,PAY_AMT_EX,BAL_AMT_EX,DEBIT_NOTE_TERM) VALUES (@p0,@p1,@p2,@p3,@p4,@p5,@p6,@p7,@p8,@p9,@p10,@p11,@p12,@p13,@p14,@p15,@p16,@p17,@p18,@p19,@p20,@p21,@p22,@p23,@p24,@p25,@p26,@p27,@p28,@p29,@p30,@p31,@p32,@p33,@p34,@p35,@p36,@p37,@p38,@p39,@p40,@p41,@p42,@p43,@p44)
16:55:18 12 มีนาคม 2561  :SUCCESS // INSERT INTO FIN_PN_IV_HEAD (OU_CODE,DIV_CODE,TRAN_NO,TRAN_DATE,TRAN_TYPE,TRAN_SUB_TYPE,BUDGET_YEAR,BUDGET_PERIOD,ATV_CODE,CURR_CODE,VAT_RATE,U_PRICE,U_PRICE_VAT,U_PRICE_INC_VAT,NET_U_PRICE,NET_U_PRICE_VAT,NET_U_PRICE_INC_VAT,DISC_AMT,DISC_AMT_VAT,DISC_AMT_INC_VAT,TOTAL,TOTAL_VAT,SUM_TOTAL,U_PRICE_EX,U_PRICE_VAT_EX,U_PRICE_INC_VAT_EX,NET_U_PRICE_EX,NET_U_PRICE_VAT_EX,NET_U_PRICE_INC_VAT_EX,DISC_AMT_EX,DISC_AMT_VAT_EX,DISC_AMT_INC_VAT_EX,TOTAL_EX,TOTAL_VAT_EX,SUM_TOTAL_EX,EX_RATE,TOP_DISC_AMT,TOP_DISC_NOTE,GRAND_AMT,PAY_AMT,BAL_AMT,PAY_AMT_EX,BAL_AMT_EX,NOTE,CANCEL_FLAG,CANCEL_REASON,CANCEL_BY,PRINT_NUM,CR_BY,CR_DATE,UPD_BY,UPD_DATE,PROG_ID,MB_MEMBER_CODE,AR_CODE,COMP_PERSON_CODE,CR_TERM,DUE_DATE,VAT_TYPE,RN_AMT,TAX_ID,POST_INVOICE_FLAG,INNER_NOTE,CANCEL_REJECT_REASON,POST_INVOICE_REJECT_REASON,TELEPHONE1,TELEPHONE2,FAX1,FAX2,ATTN_NAME_TH,ATTN_NAME_EN,BRANCH_NAME_TH,BRANCH_NAME_EN,COMP_PERSON_NAME_TH,COMP_PERSON_NAME_EN,ADDR_TAXINVOICE_1_TH,ADDR_TAXINVOICE_2_TH,ADDR_TAXINVOICE_3_TH,ADDR_TAXINVOICE_1_EN,ADDR_TAXINVOICE_2_EN,ADDR_TAXINVOICE_3_EN,ADDR_DELIVERY_1_TH,ADDR_DELIVERY_2_TH,ADDR_DELIVERY_3_TH,ADDR_DELIVERY_1_EN,ADDR_DELIVERY_2_EN,ADDR_DELIVERY_3_EN,EXCHANGE_FLAG,REGIST_CODE) VALUES (@p0,@p1,@p2,@p3,@p4,@p5,@p6,@p7,@p8,@p9,@p10,@p11,@p12,@p13,@p14,@p15,@p16,@p17,@p18,@p19,@p20,@p21,@p22,@p23,@p24,@p25,@p26,@p27,@p28,@p29,@p30,@p31,@p32,@p33,@p34,@p35,@p36,@p37,@p38,@p39,@p40,@p41,@p42,@p43,@p44,@p45,@p46,@p47,@p48,@p49,@p50,@p51,@p52,@p53,@p54,@p55,@p56,@p57,@p58,@p59,@p60,@p61,@p62,@p63,@p64,@p65,@p66,@p67,@p68,@p69,@p70,@p71,@p72,@p73,@p74,@p75,@p76,@p77,@p78,@p79,@p80,@p81,@p82,@p83,@p84,@p85,@p86,@p87,@p88)
16:55:18 12 มีนาคม 2561  :SUCCESS // UPDATE TR_TRANS_BOOK_DET SET DISCOUNT_AMNT = @p0, TRAIN_COST_AMNT = @p1, TRAINEE_RATE_AMNT = @p2 WHERE COURSE_CODE = @p3 AND OWNER_DIV_CODE = @p4 AND TRAINEE_CODE = @p5 AND P_SEQ_NO=@p6
16:55:18 12 มีนาคม 2561  :SUCCESS // UPDATE TR_TRANS_BOOK_MAS SET TRANSFER_FLAG = @p0, TRAN_NO=@p1 WHERE COURSE_CODE = @p2 AND OWNER_DIV_CODE = @p3 AND TRAINEE_CODE = @p4 AND SEQ = @p5 
16:55:28 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
16:55:28 12 มีนาคม 2561  :try to logon with: GS1WS
16:55:51 12 มีนาคม 2561  :SUCCESS // INSERT INTO MB_MEMBER (OU_CODE, DIV_CODE, REGIST_CODE, MEMBER_MAIN_GROUP_CODE, MEMBER_GROUP_CODE, MEMBER_MAIN_TYPE_CODE, MEMBER_TYPE_CODE, REGIST_DATE, CR_BY, CR_DATE, MEMBER_STATUS_CODE, COMP_PERSON_CODE, STATUS_TYPE, MEMBER_CODE, ADVISOR_CODE, MEMBER_DATE) VALUES (@p0,@p1,@p2,@p3,@p4,@p5,@p6,@p7,@p8,@p9,@p10,@p11,@p12,@p13,@p14,@p15)
16:55:51 12 มีนาคม 2561  :SUCCESS // INSERT INTO MB_COMP_PERSON (OU_CODE, COMP_PERSON_CODE, COMP_PERSON_TYPE_CODE, COMP_PERSON_NAME_TH, COMP_PERSON_NAME_EN, CR_BY, CR_DATE) VALUES (@p0,@p1,@p2,@p3,@p4,@p5,@p6)
16:58:47 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
16:58:47 12 มีนาคม 2561  :try to logon with: GS1WS
16:59:48 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
16:59:48 12 มีนาคม 2561  :try to logon with: GS1WS
17:00:39 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
17:00:39 12 มีนาคม 2561  :try to logon with: GS1WS
17:00:39 12 มีนาคม 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:39 12 มีนาคม 2561  :There is already an object named 'tempWsGs1_001' in the database.
17:05:16 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
17:05:16 12 มีนาคม 2561  :try to logon with: GS1WS
17:07:06 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
17:07:06 12 มีนาคม 2561  :try to logon with: GS1WS
17:07:55 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
17:07:55 12 มีนาคม 2561  :try to logon with: GS1WS
17:09:08 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
17:09:08 12 มีนาคม 2561  :try to logon with: GS1WS
17:09:28 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
17:09:28 12 มีนาคม 2561  :try to logon with: GS1WS
17:11:40 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
17:11:40 12 มีนาคม 2561  :try to logon with: GS1WS
17:14:20 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
17:14:20 12 มีนาคม 2561  :try to logon with: GS1WS
17:16:31 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
17:16:31 12 มีนาคม 2561  :try to logon with: GS1WS
17:18:05 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
17:18:05 12 มีนาคม 2561  :try to logon with: GS1WS
17:18:13 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
17:18:13 12 มีนาคม 2561  :try to logon with: GS1WS
17:25:47 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
17:25:47 12 มีนาคม 2561  :try to logon with: GS1WS
17:28:18 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
17:28:18 12 มีนาคม 2561  :try to logon with: GS1WS
17:31:02 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
17:31:02 12 มีนาคม 2561  :try to logon with: GS1WS
17:33:08 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
17:33:08 12 มีนาคม 2561  :try to logon with: GS1WS
17:35:11 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
17:35:11 12 มีนาคม 2561  :try to logon with: GS1WS
17:37:48 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
17:37:48 12 มีนาคม 2561  :try to logon with: GS1WS
17:39:49 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
17:39:49 12 มีนาคม 2561  :try to logon with: GS1WS
17:41:49 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
17:41:49 12 มีนาคม 2561  :try to logon with: GS1WS
17:44:00 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
17:44:00 12 มีนาคม 2561  :try to logon with: GS1WS
17:46:01 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
17:46:01 12 มีนาคม 2561  :try to logon with: GS1WS
17:48:25 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
17:48:25 12 มีนาคม 2561  :try to logon with: GS1WS
17:53:36 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
17:53:36 12 มีนาคม 2561  :try to logon with: GS1WS
17:57:52 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
17:57:52 12 มีนาคม 2561  :try to logon with: GS1WS
17:59:01 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
17:59:01 12 มีนาคม 2561  :try to logon with: GS1WS
18:00:38 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
18:00:38 12 มีนาคม 2561  :try to logon with: GS1WS
18:00:38 12 มีนาคม 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:38 12 มีนาคม 2561  :There is already an object named 'tempWsGs1_001' in the database.
18:01:00 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
18:01:00 12 มีนาคม 2561  :try to logon with: GS1WS
18:03:20 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
18:03:20 12 มีนาคม 2561  :try to logon with: GS1WS
18:06:40 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
18:06:40 12 มีนาคม 2561  :try to logon with: GS1WS
18:08:28 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
18:08:28 12 มีนาคม 2561  :try to logon with: GS1WS
18:10:29 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
18:10:29 12 มีนาคม 2561  :try to logon with: GS1WS
18:13:11 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
18:13:11 12 มีนาคม 2561  :try to logon with: GS1WS
18:21:01 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
18:21:01 12 มีนาคม 2561  :try to logon with: GS1WS
18:25:25 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
18:25:25 12 มีนาคม 2561  :try to logon with: GS1WS
18:42:45 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
18:42:45 12 มีนาคม 2561  :try to logon with: GS1WS
18:46:46 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
18:46:46 12 มีนาคม 2561  :try to logon with: GS1WS
19:00:39 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
19:00:39 12 มีนาคม 2561  :try to logon with: GS1WS
19:00:39 12 มีนาคม 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:39 12 มีนาคม 2561  :There is already an object named 'tempWsGs1_001' in the database.
19:28:02 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
19:28:02 12 มีนาคม 2561  :try to logon with: GS1WS
20:00:38 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
20:00:38 12 มีนาคม 2561  :try to logon with: GS1WS
20:00:38 12 มีนาคม 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:38 12 มีนาคม 2561  :There is already an object named 'tempWsGs1_001' in the database.
21:00:38 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
21:00:38 12 มีนาคม 2561  :try to logon with: GS1WS
21:00:38 12 มีนาคม 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:38 12 มีนาคม 2561  :There is already an object named 'tempWsGs1_001' in the database.
22:00:39 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
22:00:39 12 มีนาคม 2561  :try to logon with: GS1WS
22:00:39 12 มีนาคม 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:39 12 มีนาคม 2561  :There is already an object named 'tempWsGs1_001' in the database.
22:56:44 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
22:56:44 12 มีนาคม 2561  :try to logon with: GS1WS
23:00:39 12 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
23:00:39 12 มีนาคม 2561  :try to logon with: GS1WS
23:00:39 12 มีนาคม 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:39 12 มีนาคม 2561  :There is already an object named 'tempWsGs1_001' in the database.