0:00:50 17 กุมภาพันธ์ 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
0:00:50 17 กุมภาพันธ์ 2561  :try to logon with: GS1WS
0:00:50 17 กุมภาพันธ์ 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:50 17 กุมภาพันธ์ 2561  :There is already an object named 'tempWsGs1_001' in the database.
1:00:48 17 กุมภาพันธ์ 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
1:00:48 17 กุมภาพันธ์ 2561  :try to logon with: GS1WS
1:00:48 17 กุมภาพันธ์ 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:00:48 17 กุมภาพันธ์ 2561  :There is already an object named 'tempWsGs1_001' in the database.
2:00:49 17 กุมภาพันธ์ 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
2:00:49 17 กุมภาพันธ์ 2561  :try to logon with: GS1WS
2:00:49 17 กุมภาพันธ์ 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:49 17 กุมภาพันธ์ 2561  :There is already an object named 'tempWsGs1_001' in the database.
3:00:48 17 กุมภาพันธ์ 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
3:00:48 17 กุมภาพันธ์ 2561  :try to logon with: GS1WS
3:00:48 17 กุมภาพันธ์ 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:48 17 กุมภาพันธ์ 2561  :There is already an object named 'tempWsGs1_001' in the database.
4:00:48 17 กุมภาพันธ์ 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
4:00:48 17 กุมภาพันธ์ 2561  :try to logon with: GS1WS
4:00:48 17 กุมภาพันธ์ 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:48 17 กุมภาพันธ์ 2561  :There is already an object named 'tempWsGs1_001' in the database.
5:00:48 17 กุมภาพันธ์ 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
5:00:48 17 กุมภาพันธ์ 2561  :try to logon with: GS1WS
5:00:48 17 กุมภาพันธ์ 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:48 17 กุมภาพันธ์ 2561  :There is already an object named 'tempWsGs1_001' in the database.
6:00:50 17 กุมภาพันธ์ 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
6:00:50 17 กุมภาพันธ์ 2561  :try to logon with: GS1WS
6:00:50 17 กุมภาพันธ์ 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:50 17 กุมภาพันธ์ 2561  :There is already an object named 'tempWsGs1_001' in the database.
7:00:52 17 กุมภาพันธ์ 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
7:00:52 17 กุมภาพันธ์ 2561  :try to logon with: GS1WS
7:00:52 17 กุมภาพันธ์ 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:52 17 กุมภาพันธ์ 2561  :There is already an object named 'tempWsGs1_001' in the database.
8:00:48 17 กุมภาพันธ์ 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
8:00:48 17 กุมภาพันธ์ 2561  :try to logon with: GS1WS
8:00:48 17 กุมภาพันธ์ 2561  :getGS1changed=/*SELECT        MB_MEMBER.MEMBER_CODE, MB_PRENAME.PRENAME_TH, MB_COMP_PERSON.COMP_PERSON_NAME_TH, MB_PRENAME.PRENAME_EN, MB_COMP_PERSON.COMP_PERSON_NAME_EN, 
                         MB_COMP_PERSON.TAX_ID, MB_MEMBER.REGIST_DATE, MB_MEMBER.MEMBER_MAIN_TYPE_CODE, MB_MEMBER.MEMBER_TYPE_CODE, MB_MEMBER.MEMBER_STATUS_CODE, MB_MEMBER_RETIRE.APPROVE_DATE
FROM            MB_MEMBER INNER JOIN
                         MB_COMP_PERSON ON MB_MEMBER.COMP_PERSON_CODE = MB_COMP_PERSON.COMP_PERSON_CODE INNER JOIN
                         MB_MEMBER_RETIRE ON MB_MEMBER.REGIST_CODE = MB_MEMBER_RETIRE.REGIST_CODE LEFT OUTER JOIN
                         MB_PRENAME ON MB_COMP_PERSON.PREN_CODE = MB_PRENAME.PRENAME_CODE
WHERE        (MB_MEMBER.MEMBER_MAIN_GROUP_CODE = '300') AND (MB_MEMBER_RETIRE.APPROVE_DATE BETWEEN dbo.fnc_StrToDateTime(@YYYYMMDD_FROM + '000000') AND dbo.fnc_StrToDateTime(@YYYYMMDD_TO + '235959'))
ORDER BY MB_MEMBER_RETIRE.APPROVE_DATE*/

--declare	@YYYYMMDD_FROM	varchar(max) = '20171101'
--declare	@YYYYMMDD_TO	varchar(max) = '20171201'

create table tempWsGs1_001
(
    id int,
	tax_id varchar(max)
)

create table tempWsGs1_002
(
    MEMBER_CODE varchar(max)
	, TAX_ID varchar(max)
	, BDB_CODE varchar(max)
	, MEMBER_MAIN_TYPE_CODE varchar(max)
	, MEMBER_MAIN_TYPE_NAME varchar(max)
	, MEMBER_TYPE_CODE varchar(max)
	, MEMBER_TYPE_NAME varchar(max)
	, BUSSINESS_TYPE_TH varchar(max)
	, BUSSINESS_TYPE_EN varchar(max)
    , PRENAME_TH varchar(max)
    , COMP_PERSON_NAME_TH varchar(max)
    , PRENAME_EN varchar(max)
    , COMP_PERSON_NAME_EN varchar(max)
	, ADDR_TH varchar(max)
	, ADDR_EN varchar(max)
    , ZIP_CODE_TH varchar(max)
	, ZIP_CODE_EN varchar(max)
	, TELEPHONE_TH varchar(max)
	, TELEPHONE_EN varchar(max)
	, EMAIL_TH varchar(max)
	, EMAIL_EN varchar(max)
	, STATUS varchar(max)
    , REGIST_DATE varchar(max)
	, MEMBER_DATE varchar(max)
	, UPDATE_DATE varchar(max)
	, CompanyPrefix varchar(max)
)

insert into tempWsGs1_001
select distinct ROW_NUMBER() over (order by r.approve_date) as id, c.TAX_ID as tax_id
from MB_MEMBER m,MB_COMP_PERSON c,MB_MEMBER_RETIRE r
where r.REGIST_CODE=m.REGIST_CODE and m.MEMBER_MAIN_GROUP_CODE='300' and m.COMP_PERSON_CODE=c.COMP_PERSON_CODE
		AND (r.APPROVE_DATE BETWEEN dbo.fnc_StrToDateTime(@YYYYMMDD_FROM + '000000') AND dbo.fnc_StrToDateTime(@YYYYMMDD_TO + '235959'))

declare @id int
declare @totalRows int = (select count(*) from tempWsGs1_001)
declare @currentRow int = 0
declare @BussinessTypeTH VARCHAR(max)
declare @BussinessTypeEN VARCHAR(max)

while @currentRow <  @totalRows  
begin 
    set @id = @currentRow+1

	declare @TAX_ID varchar(max)
	set @TAX_ID = (select top 1 tax_id from tempWsGs1_001 where id=@id)

	insert into tempWsGs1_002
	select * from fnc_GetGS1MemberInfoForWebServiceByTaxID(@TAX_ID)

    set @currentRow = @currentRow +1
end  

drop table tempWsGs1_001
select * from tempWsGs1_002
drop table tempWsGs1_002
8:00:48 17 กุมภาพันธ์ 2561  :There is already an object named 'tempWsGs1_001' in the database.
9:00:48 17 กุมภาพันธ์ 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
9:00:48 17 กุมภาพันธ์ 2561  :try to logon with: GS1WS
9:00:48 17 กุมภาพันธ์ 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:48 17 กุมภาพันธ์ 2561  :There is already an object named 'tempWsGs1_001' in the database.
10:00:50 17 กุมภาพันธ์ 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
10:00:50 17 กุมภาพันธ์ 2561  :try to logon with: GS1WS
10:00:50 17 กุมภาพันธ์ 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:50 17 กุมภาพันธ์ 2561  :There is already an object named 'tempWsGs1_001' in the database.
11:00:48 17 กุมภาพันธ์ 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
11:00:48 17 กุมภาพันธ์ 2561  :try to logon with: GS1WS
11:00:48 17 กุมภาพันธ์ 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:48 17 กุมภาพันธ์ 2561  :There is already an object named 'tempWsGs1_001' in the database.
11:29:51 17 กุมภาพันธ์ 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
11:29:51 17 กุมภาพันธ์ 2561  :try to logon with: GS1WS
11:30:43 17 กุมภาพันธ์ 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
11:30:43 17 กุมภาพันธ์ 2561  :try to logon with: GS1WS
11:32:57 17 กุมภาพันธ์ 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
11:32:57 17 กุมภาพันธ์ 2561  :try to logon with: GS1WS
11:34:34 17 กุมภาพันธ์ 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
11:34:34 17 กุมภาพันธ์ 2561  :try to logon with: GS1WS
12:00:48 17 กุมภาพันธ์ 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
12:00:48 17 กุมภาพันธ์ 2561  :try to logon with: GS1WS
12:00:48 17 กุมภาพันธ์ 2561  :getGS1changed=/*SELECT        MB_MEMBER.MEMBER_CODE, MB_PRENAME.PRENAME_TH, MB_COMP_PERSON.COMP_PERSON_NAME_TH, MB_PRENAME.PRENAME_EN, MB_COMP_PERSON.COMP_PERSON_NAME_EN, 
                         MB_COMP_PERSON.TAX_ID, MB_MEMBER.REGIST_DATE, MB_MEMBER.MEMBER_MAIN_TYPE_CODE, MB_MEMBER.MEMBER_TYPE_CODE, MB_MEMBER.MEMBER_STATUS_CODE, MB_MEMBER_RETIRE.APPROVE_DATE
FROM            MB_MEMBER INNER JOIN
                         MB_COMP_PERSON ON MB_MEMBER.COMP_PERSON_CODE = MB_COMP_PERSON.COMP_PERSON_CODE INNER JOIN
                         MB_MEMBER_RETIRE ON MB_MEMBER.REGIST_CODE = MB_MEMBER_RETIRE.REGIST_CODE LEFT OUTER JOIN
                         MB_PRENAME ON MB_COMP_PERSON.PREN_CODE = MB_PRENAME.PRENAME_CODE
WHERE        (MB_MEMBER.MEMBER_MAIN_GROUP_CODE = '300') AND (MB_MEMBER_RETIRE.APPROVE_DATE BETWEEN dbo.fnc_StrToDateTime(@YYYYMMDD_FROM + '000000') AND dbo.fnc_StrToDateTime(@YYYYMMDD_TO + '235959'))
ORDER BY MB_MEMBER_RETIRE.APPROVE_DATE*/

--declare	@YYYYMMDD_FROM	varchar(max) = '20171101'
--declare	@YYYYMMDD_TO	varchar(max) = '20171201'

create table tempWsGs1_001
(
    id int,
	tax_id varchar(max)
)

create table tempWsGs1_002
(
    MEMBER_CODE varchar(max)
	, TAX_ID varchar(max)
	, BDB_CODE varchar(max)
	, MEMBER_MAIN_TYPE_CODE varchar(max)
	, MEMBER_MAIN_TYPE_NAME varchar(max)
	, MEMBER_TYPE_CODE varchar(max)
	, MEMBER_TYPE_NAME varchar(max)
	, BUSSINESS_TYPE_TH varchar(max)
	, BUSSINESS_TYPE_EN varchar(max)
    , PRENAME_TH varchar(max)
    , COMP_PERSON_NAME_TH varchar(max)
    , PRENAME_EN varchar(max)
    , COMP_PERSON_NAME_EN varchar(max)
	, ADDR_TH varchar(max)
	, ADDR_EN varchar(max)
    , ZIP_CODE_TH varchar(max)
	, ZIP_CODE_EN varchar(max)
	, TELEPHONE_TH varchar(max)
	, TELEPHONE_EN varchar(max)
	, EMAIL_TH varchar(max)
	, EMAIL_EN varchar(max)
	, STATUS varchar(max)
    , REGIST_DATE varchar(max)
	, MEMBER_DATE varchar(max)
	, UPDATE_DATE varchar(max)
	, CompanyPrefix varchar(max)
)

insert into tempWsGs1_001
select distinct ROW_NUMBER() over (order by r.approve_date) as id, c.TAX_ID as tax_id
from MB_MEMBER m,MB_COMP_PERSON c,MB_MEMBER_RETIRE r
where r.REGIST_CODE=m.REGIST_CODE and m.MEMBER_MAIN_GROUP_CODE='300' and m.COMP_PERSON_CODE=c.COMP_PERSON_CODE
		AND (r.APPROVE_DATE BETWEEN dbo.fnc_StrToDateTime(@YYYYMMDD_FROM + '000000') AND dbo.fnc_StrToDateTime(@YYYYMMDD_TO + '235959'))

declare @id int
declare @totalRows int = (select count(*) from tempWsGs1_001)
declare @currentRow int = 0
declare @BussinessTypeTH VARCHAR(max)
declare @BussinessTypeEN VARCHAR(max)

while @currentRow <  @totalRows  
begin 
    set @id = @currentRow+1

	declare @TAX_ID varchar(max)
	set @TAX_ID = (select top 1 tax_id from tempWsGs1_001 where id=@id)

	insert into tempWsGs1_002
	select * from fnc_GetGS1MemberInfoForWebServiceByTaxID(@TAX_ID)

    set @currentRow = @currentRow +1
end  

drop table tempWsGs1_001
select * from tempWsGs1_002
drop table tempWsGs1_002
12:00:48 17 กุมภาพันธ์ 2561  :There is already an object named 'tempWsGs1_001' in the database.
13:00:54 17 กุมภาพันธ์ 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
13:00:54 17 กุมภาพันธ์ 2561  :try to logon with: GS1WS
13:00:54 17 กุมภาพันธ์ 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:54 17 กุมภาพันธ์ 2561  :There is already an object named 'tempWsGs1_001' in the database.
13:58:46 17 กุมภาพันธ์ 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
13:58:46 17 กุมภาพันธ์ 2561  :try to logon with: GS1WS
14:00:52 17 กุมภาพันธ์ 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
14:00:52 17 กุมภาพันธ์ 2561  :try to logon with: GS1WS
14:00:52 17 กุมภาพันธ์ 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:52 17 กุมภาพันธ์ 2561  :There is already an object named 'tempWsGs1_001' in the database.
14:02:31 17 กุมภาพันธ์ 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
14:02:31 17 กุมภาพันธ์ 2561  :try to logon with: GS1WS
14:03:29 17 กุมภาพันธ์ 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
14:03:29 17 กุมภาพันธ์ 2561  :try to logon with: GS1WS
14:22:20 17 กุมภาพันธ์ 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
14:22:20 17 กุมภาพันธ์ 2561  :try to logon with: GS1WS
14:28:35 17 กุมภาพันธ์ 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
14:28:35 17 กุมภาพันธ์ 2561  :try to logon with: GS1WS
15:00:52 17 กุมภาพันธ์ 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
15:00:52 17 กุมภาพันธ์ 2561  :try to logon with: GS1WS
15:00:52 17 กุมภาพันธ์ 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:52 17 กุมภาพันธ์ 2561  :There is already an object named 'tempWsGs1_001' in the database.
15:04:42 17 กุมภาพันธ์ 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
15:04:42 17 กุมภาพันธ์ 2561  :try to logon with: GS1WS
15:05:15 17 กุมภาพันธ์ 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
15:05:15 17 กุมภาพันธ์ 2561  :try to logon with: GS1WS
15:07:31 17 กุมภาพันธ์ 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
15:07:31 17 กุมภาพันธ์ 2561  :try to logon with: GS1WS
15:18:41 17 กุมภาพันธ์ 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
15:18:41 17 กุมภาพันธ์ 2561  :try to logon with: GS1WS
15:31:56 17 กุมภาพันธ์ 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
15:31:56 17 กุมภาพันธ์ 2561  :try to logon with: GS1WS
15:38:06 17 กุมภาพันธ์ 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
15:38:06 17 กุมภาพันธ์ 2561  :try to logon with: GS1WS
16:00:48 17 กุมภาพันธ์ 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
16:00:48 17 กุมภาพันธ์ 2561  :try to logon with: GS1WS
16:00:48 17 กุมภาพันธ์ 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:48 17 กุมภาพันธ์ 2561  :There is already an object named 'tempWsGs1_001' in the database.
16:09:25 17 กุมภาพันธ์ 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
16:09:25 17 กุมภาพันธ์ 2561  :try to logon with: GS1WS
16:14:14 17 กุมภาพันธ์ 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
16:14:14 17 กุมภาพันธ์ 2561  :try to logon with: GS1WS
16:17:03 17 กุมภาพันธ์ 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
16:17:03 17 กุมภาพันธ์ 2561  :try to logon with: GS1WS
16:18:44 17 กุมภาพันธ์ 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
16:18:44 17 กุมภาพันธ์ 2561  :try to logon with: GS1WS
16:19:39 17 กุมภาพันธ์ 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
16:19:39 17 กุมภาพันธ์ 2561  :try to logon with: GS1WS
16:20:18 17 กุมภาพันธ์ 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
16:20:18 17 กุมภาพันธ์ 2561  :try to logon with: GS1WS
16:21:02 17 กุมภาพันธ์ 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
16:21:02 17 กุมภาพันธ์ 2561  :try to logon with: GS1WS
16:22:08 17 กุมภาพันธ์ 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
16:22:08 17 กุมภาพันธ์ 2561  :try to logon with: GS1WS
16:23:04 17 กุมภาพันธ์ 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
16:23:04 17 กุมภาพันธ์ 2561  :try to logon with: GS1WS
16:23:53 17 กุมภาพันธ์ 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
16:23:53 17 กุมภาพันธ์ 2561  :try to logon with: GS1WS
16:24:42 17 กุมภาพันธ์ 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
16:24:42 17 กุมภาพันธ์ 2561  :try to logon with: GS1WS
16:25:28 17 กุมภาพันธ์ 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
16:25:28 17 กุมภาพันธ์ 2561  :try to logon with: GS1WS
16:25:30 17 กุมภาพันธ์ 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
16:25:30 17 กุมภาพันธ์ 2561  :try to logon with: GS1WS
16:26:37 17 กุมภาพันธ์ 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
16:26:37 17 กุมภาพันธ์ 2561  :try to logon with: GS1WS
16:27:37 17 กุมภาพันธ์ 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
16:27:37 17 กุมภาพันธ์ 2561  :try to logon with: GS1WS
16:28:24 17 กุมภาพันธ์ 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
16:28:24 17 กุมภาพันธ์ 2561  :try to logon with: GS1WS
16:29:14 17 กุมภาพันธ์ 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
16:29:14 17 กุมภาพันธ์ 2561  :try to logon with: GS1WS
16:30:11 17 กุมภาพันธ์ 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
16:30:11 17 กุมภาพันธ์ 2561  :try to logon with: GS1WS
16:31:01 17 กุมภาพันธ์ 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
16:31:01 17 กุมภาพันธ์ 2561  :try to logon with: GS1WS
16:31:52 17 กุมภาพันธ์ 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
16:31:52 17 กุมภาพันธ์ 2561  :try to logon with: GS1WS
16:32:32 17 กุมภาพันธ์ 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
16:32:32 17 กุมภาพันธ์ 2561  :try to logon with: GS1WS
16:33:30 17 กุมภาพันธ์ 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
16:33:30 17 กุมภาพันธ์ 2561  :try to logon with: GS1WS
16:34:36 17 กุมภาพันธ์ 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
16:34:36 17 กุมภาพันธ์ 2561  :try to logon with: GS1WS
16:36:17 17 กุมภาพันธ์ 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
16:36:17 17 กุมภาพันธ์ 2561  :try to logon with: GS1WS
16:37:19 17 กุมภาพันธ์ 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
16:37:19 17 กุมภาพันธ์ 2561  :try to logon with: GS1WS
16:38:34 17 กุมภาพันธ์ 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
16:38:34 17 กุมภาพันธ์ 2561  :try to logon with: GS1WS
16:39:42 17 กุมภาพันธ์ 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
16:39:42 17 กุมภาพันธ์ 2561  :try to logon with: GS1WS
16:41:17 17 กุมภาพันธ์ 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
16:41:17 17 กุมภาพันธ์ 2561  :try to logon with: GS1WS
16:42:15 17 กุมภาพันธ์ 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
16:42:15 17 กุมภาพันธ์ 2561  :try to logon with: GS1WS
16:43:38 17 กุมภาพันธ์ 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
16:43:38 17 กุมภาพันธ์ 2561  :try to logon with: GS1WS
16:44:33 17 กุมภาพันธ์ 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
16:44:33 17 กุมภาพันธ์ 2561  :try to logon with: GS1WS
16:45:36 17 กุมภาพันธ์ 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
16:45:36 17 กุมภาพันธ์ 2561  :try to logon with: GS1WS
16:46:51 17 กุมภาพันธ์ 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
16:46:51 17 กุมภาพันธ์ 2561  :try to logon with: GS1WS
16:47:45 17 กุมภาพันธ์ 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
16:47:45 17 กุมภาพันธ์ 2561  :try to logon with: GS1WS
16:47:55 17 กุมภาพันธ์ 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
16:47:55 17 กุมภาพันธ์ 2561  :try to logon with: GS1WS
16:49:21 17 กุมภาพันธ์ 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
16:49:21 17 กุมภาพันธ์ 2561  :try to logon with: GS1WS
16:50:10 17 กุมภาพันธ์ 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
16:50:10 17 กุมภาพันธ์ 2561  :try to logon with: GS1WS
16:51:09 17 กุมภาพันธ์ 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
16:51:09 17 กุมภาพันธ์ 2561  :try to logon with: GS1WS
16:52:06 17 กุมภาพันธ์ 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
16:52:06 17 กุมภาพันธ์ 2561  :try to logon with: GS1WS
16:53:05 17 กุมภาพันธ์ 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
16:53:05 17 กุมภาพันธ์ 2561  :try to logon with: GS1WS
16:54:08 17 กุมภาพันธ์ 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
16:54:08 17 กุมภาพันธ์ 2561  :try to logon with: GS1WS
16:55:10 17 กุมภาพันธ์ 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
16:55:10 17 กุมภาพันธ์ 2561  :try to logon with: GS1WS
16:55:55 17 กุมภาพันธ์ 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
16:55:55 17 กุมภาพันธ์ 2561  :try to logon with: GS1WS
16:56:37 17 กุมภาพันธ์ 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
16:56:37 17 กุมภาพันธ์ 2561  :try to logon with: GS1WS
16:57:39 17 กุมภาพันธ์ 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
16:57:39 17 กุมภาพันธ์ 2561  :try to logon with: GS1WS
16:58:20 17 กุมภาพันธ์ 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
16:58:20 17 กุมภาพันธ์ 2561  :try to logon with: GS1WS
17:00:48 17 กุมภาพันธ์ 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
17:00:48 17 กุมภาพันธ์ 2561  :try to logon with: GS1WS
17:00:48 17 กุมภาพันธ์ 2561  :getGS1changed=/*SELECT        MB_MEMBER.MEMBER_CODE, MB_PRENAME.PRENAME_TH, MB_COMP_PERSON.COMP_PERSON_NAME_TH, MB_PRENAME.PRENAME_EN, MB_COMP_PERSON.COMP_PERSON_NAME_EN, 
                         MB_COMP_PERSON.TAX_ID, MB_MEMBER.REGIST_DATE, MB_MEMBER.MEMBER_MAIN_TYPE_CODE, MB_MEMBER.MEMBER_TYPE_CODE, MB_MEMBER.MEMBER_STATUS_CODE, MB_MEMBER_RETIRE.APPROVE_DATE
FROM            MB_MEMBER INNER JOIN
                         MB_COMP_PERSON ON MB_MEMBER.COMP_PERSON_CODE = MB_COMP_PERSON.COMP_PERSON_CODE INNER JOIN
                         MB_MEMBER_RETIRE ON MB_MEMBER.REGIST_CODE = MB_MEMBER_RETIRE.REGIST_CODE LEFT OUTER JOIN
                         MB_PRENAME ON MB_COMP_PERSON.PREN_CODE = MB_PRENAME.PRENAME_CODE
WHERE        (MB_MEMBER.MEMBER_MAIN_GROUP_CODE = '300') AND (MB_MEMBER_RETIRE.APPROVE_DATE BETWEEN dbo.fnc_StrToDateTime(@YYYYMMDD_FROM + '000000') AND dbo.fnc_StrToDateTime(@YYYYMMDD_TO + '235959'))
ORDER BY MB_MEMBER_RETIRE.APPROVE_DATE*/

--declare	@YYYYMMDD_FROM	varchar(max) = '20171101'
--declare	@YYYYMMDD_TO	varchar(max) = '20171201'

create table tempWsGs1_001
(
    id int,
	tax_id varchar(max)
)

create table tempWsGs1_002
(
    MEMBER_CODE varchar(max)
	, TAX_ID varchar(max)
	, BDB_CODE varchar(max)
	, MEMBER_MAIN_TYPE_CODE varchar(max)
	, MEMBER_MAIN_TYPE_NAME varchar(max)
	, MEMBER_TYPE_CODE varchar(max)
	, MEMBER_TYPE_NAME varchar(max)
	, BUSSINESS_TYPE_TH varchar(max)
	, BUSSINESS_TYPE_EN varchar(max)
    , PRENAME_TH varchar(max)
    , COMP_PERSON_NAME_TH varchar(max)
    , PRENAME_EN varchar(max)
    , COMP_PERSON_NAME_EN varchar(max)
	, ADDR_TH varchar(max)
	, ADDR_EN varchar(max)
    , ZIP_CODE_TH varchar(max)
	, ZIP_CODE_EN varchar(max)
	, TELEPHONE_TH varchar(max)
	, TELEPHONE_EN varchar(max)
	, EMAIL_TH varchar(max)
	, EMAIL_EN varchar(max)
	, STATUS varchar(max)
    , REGIST_DATE varchar(max)
	, MEMBER_DATE varchar(max)
	, UPDATE_DATE varchar(max)
	, CompanyPrefix varchar(max)
)

insert into tempWsGs1_001
select distinct ROW_NUMBER() over (order by r.approve_date) as id, c.TAX_ID as tax_id
from MB_MEMBER m,MB_COMP_PERSON c,MB_MEMBER_RETIRE r
where r.REGIST_CODE=m.REGIST_CODE and m.MEMBER_MAIN_GROUP_CODE='300' and m.COMP_PERSON_CODE=c.COMP_PERSON_CODE
		AND (r.APPROVE_DATE BETWEEN dbo.fnc_StrToDateTime(@YYYYMMDD_FROM + '000000') AND dbo.fnc_StrToDateTime(@YYYYMMDD_TO + '235959'))

declare @id int
declare @totalRows int = (select count(*) from tempWsGs1_001)
declare @currentRow int = 0
declare @BussinessTypeTH VARCHAR(max)
declare @BussinessTypeEN VARCHAR(max)

while @currentRow <  @totalRows  
begin 
    set @id = @currentRow+1

	declare @TAX_ID varchar(max)
	set @TAX_ID = (select top 1 tax_id from tempWsGs1_001 where id=@id)

	insert into tempWsGs1_002
	select * from fnc_GetGS1MemberInfoForWebServiceByTaxID(@TAX_ID)

    set @currentRow = @currentRow +1
end  

drop table tempWsGs1_001
select * from tempWsGs1_002
drop table tempWsGs1_002
17:00:48 17 กุมภาพันธ์ 2561  :There is already an object named 'tempWsGs1_001' in the database.
17:06:07 17 กุมภาพันธ์ 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
17:06:07 17 กุมภาพันธ์ 2561  :try to logon with: GS1WS
17:07:17 17 กุมภาพันธ์ 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
17:07:17 17 กุมภาพันธ์ 2561  :try to logon with: GS1WS
17:08:11 17 กุมภาพันธ์ 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
17:08:11 17 กุมภาพันธ์ 2561  :try to logon with: GS1WS
17:09:10 17 กุมภาพันธ์ 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
17:09:10 17 กุมภาพันธ์ 2561  :try to logon with: GS1WS
17:10:04 17 กุมภาพันธ์ 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
17:10:04 17 กุมภาพันธ์ 2561  :try to logon with: GS1WS
17:10:55 17 กุมภาพันธ์ 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
17:10:55 17 กุมภาพันธ์ 2561  :try to logon with: GS1WS
17:14:02 17 กุมภาพันธ์ 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
17:14:02 17 กุมภาพันธ์ 2561  :try to logon with: GS1WS
17:15:21 17 กุมภาพันธ์ 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
17:15:21 17 กุมภาพันธ์ 2561  :try to logon with: GS1WS
17:17:12 17 กุมภาพันธ์ 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
17:17:12 17 กุมภาพันธ์ 2561  :try to logon with: GS1WS
17:18:40 17 กุมภาพันธ์ 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
17:18:40 17 กุมภาพันธ์ 2561  :try to logon with: GS1WS
17:20:46 17 กุมภาพันธ์ 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
17:20:46 17 กุมภาพันธ์ 2561  :try to logon with: GS1WS
17:25:34 17 กุมภาพันธ์ 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
17:25:34 17 กุมภาพันธ์ 2561  :try to logon with: GS1WS
17:28:04 17 กุมภาพันธ์ 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
17:28:04 17 กุมภาพันธ์ 2561  :try to logon with: GS1WS
17:29:58 17 กุมภาพันธ์ 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
17:29:58 17 กุมภาพันธ์ 2561  :try to logon with: GS1WS
17:31:40 17 กุมภาพันธ์ 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
17:31:40 17 กุมภาพันธ์ 2561  :try to logon with: GS1WS
17:37:40 17 กุมภาพันธ์ 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
17:37:40 17 กุมภาพันธ์ 2561  :try to logon with: GS1WS
17:39:00 17 กุมภาพันธ์ 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
17:39:00 17 กุมภาพันธ์ 2561  :try to logon with: GS1WS
17:39:50 17 กุมภาพันธ์ 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
17:39:50 17 กุมภาพันธ์ 2561  :try to logon with: GS1WS
17:41:01 17 กุมภาพันธ์ 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
17:41:01 17 กุมภาพันธ์ 2561  :try to logon with: GS1WS
17:43:03 17 กุมภาพันธ์ 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
17:43:03 17 กุมภาพันธ์ 2561  :try to logon with: GS1WS
17:43:57 17 กุมภาพันธ์ 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
17:43:57 17 กุมภาพันธ์ 2561  :try to logon with: GS1WS
17:44:52 17 กุมภาพันธ์ 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
17:44:52 17 กุมภาพันธ์ 2561  :try to logon with: GS1WS
17:46:02 17 กุมภาพันธ์ 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
17:46:02 17 กุมภาพันธ์ 2561  :try to logon with: GS1WS
17:47:03 17 กุมภาพันธ์ 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
17:47:03 17 กุมภาพันธ์ 2561  :try to logon with: GS1WS
17:48:00 17 กุมภาพันธ์ 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
17:48:00 17 กุมภาพันธ์ 2561  :try to logon with: GS1WS
17:48:54 17 กุมภาพันธ์ 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
17:48:54 17 กุมภาพันธ์ 2561  :try to logon with: GS1WS
17:50:13 17 กุมภาพันธ์ 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
17:50:13 17 กุมภาพันธ์ 2561  :try to logon with: GS1WS
17:51:27 17 กุมภาพันธ์ 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
17:51:27 17 กุมภาพันธ์ 2561  :try to logon with: GS1WS
17:52:26 17 กุมภาพันธ์ 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
17:52:26 17 กุมภาพันธ์ 2561  :try to logon with: GS1WS
17:53:21 17 กุมภาพันธ์ 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
17:53:21 17 กุมภาพันธ์ 2561  :try to logon with: GS1WS
17:54:18 17 กุมภาพันธ์ 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
17:54:18 17 กุมภาพันธ์ 2561  :try to logon with: GS1WS
17:55:25 17 กุมภาพันธ์ 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
17:55:25 17 กุมภาพันธ์ 2561  :try to logon with: GS1WS
18:00:51 17 กุมภาพันธ์ 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
18:00:51 17 กุมภาพันธ์ 2561  :try to logon with: GS1WS
18:00:51 17 กุมภาพันธ์ 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:51 17 กุมภาพันธ์ 2561  :There is already an object named 'tempWsGs1_001' in the database.
19:00:50 17 กุมภาพันธ์ 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
19:00:50 17 กุมภาพันธ์ 2561  :try to logon with: GS1WS
19:00:50 17 กุมภาพันธ์ 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:50 17 กุมภาพันธ์ 2561  :There is already an object named 'tempWsGs1_001' in the database.
19:07:41 17 กุมภาพันธ์ 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
19:07:41 17 กุมภาพันธ์ 2561  :try to logon with: GS1WS
19:08:30 17 กุมภาพันธ์ 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
19:08:30 17 กุมภาพันธ์ 2561  :try to logon with: GS1WS
19:09:42 17 กุมภาพันธ์ 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
19:09:42 17 กุมภาพันธ์ 2561  :try to logon with: GS1WS
19:10:46 17 กุมภาพันธ์ 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
19:10:46 17 กุมภาพันธ์ 2561  :try to logon with: GS1WS
19:11:21 17 กุมภาพันธ์ 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
19:11:21 17 กุมภาพันธ์ 2561  :try to logon with: GS1WS
19:11:44 17 กุมภาพันธ์ 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
19:11:44 17 กุมภาพันธ์ 2561  :try to logon with: GS1WS
19:12:11 17 กุมภาพันธ์ 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
19:12:11 17 กุมภาพันธ์ 2561  :try to logon with: GS1WS
19:12:35 17 กุมภาพันธ์ 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
19:12:35 17 กุมภาพันธ์ 2561  :try to logon with: GS1WS
19:13:02 17 กุมภาพันธ์ 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
19:13:02 17 กุมภาพันธ์ 2561  :try to logon with: GS1WS
19:13:26 17 กุมภาพันธ์ 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
19:13:26 17 กุมภาพันธ์ 2561  :try to logon with: GS1WS
19:13:50 17 กุมภาพันธ์ 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
19:13:50 17 กุมภาพันธ์ 2561  :try to logon with: GS1WS
19:14:14 17 กุมภาพันธ์ 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
19:14:14 17 กุมภาพันธ์ 2561  :try to logon with: GS1WS
19:14:39 17 กุมภาพันธ์ 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
19:14:39 17 กุมภาพันธ์ 2561  :try to logon with: GS1WS
19:15:07 17 กุมภาพันธ์ 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
19:15:07 17 กุมภาพันธ์ 2561  :try to logon with: GS1WS
19:15:32 17 กุมภาพันธ์ 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
19:15:32 17 กุมภาพันธ์ 2561  :try to logon with: GS1WS
19:16:10 17 กุมภาพันธ์ 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
19:16:10 17 กุมภาพันธ์ 2561  :try to logon with: GS1WS
19:16:34 17 กุมภาพันธ์ 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
19:16:34 17 กุมภาพันธ์ 2561  :try to logon with: GS1WS
19:16:59 17 กุมภาพันธ์ 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
19:16:59 17 กุมภาพันธ์ 2561  :try to logon with: GS1WS
19:17:26 17 กุมภาพันธ์ 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
19:17:26 17 กุมภาพันธ์ 2561  :try to logon with: GS1WS
19:18:18 17 กุมภาพันธ์ 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
19:18:18 17 กุมภาพันธ์ 2561  :try to logon with: GS1WS
19:18:42 17 กุมภาพันธ์ 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
19:18:42 17 กุมภาพันธ์ 2561  :try to logon with: GS1WS
19:19:11 17 กุมภาพันธ์ 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
19:19:11 17 กุมภาพันธ์ 2561  :try to logon with: GS1WS
19:19:41 17 กุมภาพันธ์ 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
19:19:41 17 กุมภาพันธ์ 2561  :try to logon with: GS1WS
19:20:12 17 กุมภาพันธ์ 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
19:20:12 17 กุมภาพันธ์ 2561  :try to logon with: GS1WS
19:20:45 17 กุมภาพันธ์ 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
19:20:45 17 กุมภาพันธ์ 2561  :try to logon with: GS1WS
19:27:50 17 กุมภาพันธ์ 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
19:27:50 17 กุมภาพันธ์ 2561  :try to logon with: GS1WS
20:00:49 17 กุมภาพันธ์ 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
20:00:49 17 กุมภาพันธ์ 2561  :try to logon with: GS1WS
20:00:49 17 กุมภาพันธ์ 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:49 17 กุมภาพันธ์ 2561  :There is already an object named 'tempWsGs1_001' in the database.
20:20:46 17 กุมภาพันธ์ 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
20:20:46 17 กุมภาพันธ์ 2561  :try to logon with: GS1WS
20:30:38 17 กุมภาพันธ์ 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
20:30:38 17 กุมภาพันธ์ 2561  :try to logon with: GS1WS
20:31:06 17 กุมภาพันธ์ 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
20:31:06 17 กุมภาพันธ์ 2561  :try to logon with: GS1WS
20:35:52 17 กุมภาพันธ์ 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
20:35:52 17 กุมภาพันธ์ 2561  :try to logon with: GS1WS
20:36:54 17 กุมภาพันธ์ 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
20:36:54 17 กุมภาพันธ์ 2561  :try to logon with: GS1WS
20:37:24 17 กุมภาพันธ์ 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
20:37:24 17 กุมภาพันธ์ 2561  :try to logon with: GS1WS
20:45:27 17 กุมภาพันธ์ 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
20:45:27 17 กุมภาพันธ์ 2561  :try to logon with: GS1WS
20:48:11 17 กุมภาพันธ์ 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
20:48:11 17 กุมภาพันธ์ 2561  :try to logon with: GS1WS
20:48:27 17 กุมภาพันธ์ 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
20:48:27 17 กุมภาพันธ์ 2561  :try to logon with: GS1WS
20:57:45 17 กุมภาพันธ์ 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
20:57:45 17 กุมภาพันธ์ 2561  :try to logon with: GS1WS
21:00:48 17 กุมภาพันธ์ 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
21:00:48 17 กุมภาพันธ์ 2561  :try to logon with: GS1WS
21:00:48 17 กุมภาพันธ์ 2561  :getGS1changed=/*SELECT        MB_MEMBER.MEMBER_CODE, MB_PRENAME.PRENAME_TH, MB_COMP_PERSON.COMP_PERSON_NAME_TH, MB_PRENAME.PRENAME_EN, MB_COMP_PERSON.COMP_PERSON_NAME_EN, 
                         MB_COMP_PERSON.TAX_ID, MB_MEMBER.REGIST_DATE, MB_MEMBER.MEMBER_MAIN_TYPE_CODE, MB_MEMBER.MEMBER_TYPE_CODE, MB_MEMBER.MEMBER_STATUS_CODE, MB_MEMBER_RETIRE.APPROVE_DATE
FROM            MB_MEMBER INNER JOIN
                         MB_COMP_PERSON ON MB_MEMBER.COMP_PERSON_CODE = MB_COMP_PERSON.COMP_PERSON_CODE INNER JOIN
                         MB_MEMBER_RETIRE ON MB_MEMBER.REGIST_CODE = MB_MEMBER_RETIRE.REGIST_CODE LEFT OUTER JOIN
                         MB_PRENAME ON MB_COMP_PERSON.PREN_CODE = MB_PRENAME.PRENAME_CODE
WHERE        (MB_MEMBER.MEMBER_MAIN_GROUP_CODE = '300') AND (MB_MEMBER_RETIRE.APPROVE_DATE BETWEEN dbo.fnc_StrToDateTime(@YYYYMMDD_FROM + '000000') AND dbo.fnc_StrToDateTime(@YYYYMMDD_TO + '235959'))
ORDER BY MB_MEMBER_RETIRE.APPROVE_DATE*/

--declare	@YYYYMMDD_FROM	varchar(max) = '20171101'
--declare	@YYYYMMDD_TO	varchar(max) = '20171201'

create table tempWsGs1_001
(
    id int,
	tax_id varchar(max)
)

create table tempWsGs1_002
(
    MEMBER_CODE varchar(max)
	, TAX_ID varchar(max)
	, BDB_CODE varchar(max)
	, MEMBER_MAIN_TYPE_CODE varchar(max)
	, MEMBER_MAIN_TYPE_NAME varchar(max)
	, MEMBER_TYPE_CODE varchar(max)
	, MEMBER_TYPE_NAME varchar(max)
	, BUSSINESS_TYPE_TH varchar(max)
	, BUSSINESS_TYPE_EN varchar(max)
    , PRENAME_TH varchar(max)
    , COMP_PERSON_NAME_TH varchar(max)
    , PRENAME_EN varchar(max)
    , COMP_PERSON_NAME_EN varchar(max)
	, ADDR_TH varchar(max)
	, ADDR_EN varchar(max)
    , ZIP_CODE_TH varchar(max)
	, ZIP_CODE_EN varchar(max)
	, TELEPHONE_TH varchar(max)
	, TELEPHONE_EN varchar(max)
	, EMAIL_TH varchar(max)
	, EMAIL_EN varchar(max)
	, STATUS varchar(max)
    , REGIST_DATE varchar(max)
	, MEMBER_DATE varchar(max)
	, UPDATE_DATE varchar(max)
	, CompanyPrefix varchar(max)
)

insert into tempWsGs1_001
select distinct ROW_NUMBER() over (order by r.approve_date) as id, c.TAX_ID as tax_id
from MB_MEMBER m,MB_COMP_PERSON c,MB_MEMBER_RETIRE r
where r.REGIST_CODE=m.REGIST_CODE and m.MEMBER_MAIN_GROUP_CODE='300' and m.COMP_PERSON_CODE=c.COMP_PERSON_CODE
		AND (r.APPROVE_DATE BETWEEN dbo.fnc_StrToDateTime(@YYYYMMDD_FROM + '000000') AND dbo.fnc_StrToDateTime(@YYYYMMDD_TO + '235959'))

declare @id int
declare @totalRows int = (select count(*) from tempWsGs1_001)
declare @currentRow int = 0
declare @BussinessTypeTH VARCHAR(max)
declare @BussinessTypeEN VARCHAR(max)

while @currentRow <  @totalRows  
begin 
    set @id = @currentRow+1

	declare @TAX_ID varchar(max)
	set @TAX_ID = (select top 1 tax_id from tempWsGs1_001 where id=@id)

	insert into tempWsGs1_002
	select * from fnc_GetGS1MemberInfoForWebServiceByTaxID(@TAX_ID)

    set @currentRow = @currentRow +1
end  

drop table tempWsGs1_001
select * from tempWsGs1_002
drop table tempWsGs1_002
21:00:48 17 กุมภาพันธ์ 2561  :There is already an object named 'tempWsGs1_001' in the database.
21:01:37 17 กุมภาพันธ์ 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
21:01:37 17 กุมภาพันธ์ 2561  :try to logon with: GS1WS
21:06:16 17 กุมภาพันธ์ 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
21:06:16 17 กุมภาพันธ์ 2561  :try to logon with: GS1WS
21:06:16 17 กุมภาพันธ์ 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
21:06:16 17 กุมภาพันธ์ 2561  :try to logon with: GS1WS
21:09:03 17 กุมภาพันธ์ 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
21:09:03 17 กุมภาพันธ์ 2561  :try to logon with: GS1WS
21:10:47 17 กุมภาพันธ์ 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
21:10:47 17 กุมภาพันธ์ 2561  :try to logon with: GS1WS
21:11:21 17 กุมภาพันธ์ 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
21:11:21 17 กุมภาพันธ์ 2561  :try to logon with: GS1WS
21:11:42 17 กุมภาพันธ์ 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
21:11:42 17 กุมภาพันธ์ 2561  :try to logon with: GS1WS
21:12:51 17 กุมภาพันธ์ 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
21:12:51 17 กุมภาพันธ์ 2561  :try to logon with: GS1WS
21:13:48 17 กุมภาพันธ์ 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
21:13:48 17 กุมภาพันธ์ 2561  :try to logon with: GS1WS
21:16:20 17 กุมภาพันธ์ 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
21:16:20 17 กุมภาพันธ์ 2561  :try to logon with: GS1WS
21:19:41 17 กุมภาพันธ์ 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
21:19:41 17 กุมภาพันธ์ 2561  :try to logon with: GS1WS
21:22:44 17 กุมภาพันธ์ 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
21:22:44 17 กุมภาพันธ์ 2561  :try to logon with: GS1WS
21:25:10 17 กุมภาพันธ์ 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
21:25:10 17 กุมภาพันธ์ 2561  :try to logon with: GS1WS
21:28:12 17 กุมภาพันธ์ 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
21:28:12 17 กุมภาพันธ์ 2561  :try to logon with: GS1WS
21:32:22 17 กุมภาพันธ์ 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
21:32:22 17 กุมภาพันธ์ 2561  :try to logon with: GS1WS
21:32:51 17 กุมภาพันธ์ 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
21:32:51 17 กุมภาพันธ์ 2561  :try to logon with: GS1WS
21:35:07 17 กุมภาพันธ์ 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
21:35:07 17 กุมภาพันธ์ 2561  :try to logon with: GS1WS
21:37:54 17 กุมภาพันธ์ 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
21:37:54 17 กุมภาพันธ์ 2561  :try to logon with: GS1WS
21:38:34 17 กุมภาพันธ์ 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
21:38:34 17 กุมภาพันธ์ 2561  :try to logon with: GS1WS
21:41:21 17 กุมภาพันธ์ 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
21:41:21 17 กุมภาพันธ์ 2561  :try to logon with: GS1WS
21:41:34 17 กุมภาพันธ์ 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
21:41:34 17 กุมภาพันธ์ 2561  :try to logon with: GS1WS
21:42:00 17 กุมภาพันธ์ 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
21:42:00 17 กุมภาพันธ์ 2561  :try to logon with: GS1WS
21:43:45 17 กุมภาพันธ์ 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
21:43:45 17 กุมภาพันธ์ 2561  :try to logon with: GS1WS
21:45:37 17 กุมภาพันธ์ 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
21:45:37 17 กุมภาพันธ์ 2561  :try to logon with: GS1WS
21:45:50 17 กุมภาพันธ์ 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
21:45:50 17 กุมภาพันธ์ 2561  :try to logon with: GS1WS
21:48:54 17 กุมภาพันธ์ 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
21:48:54 17 กุมภาพันธ์ 2561  :try to logon with: GS1WS
21:54:57 17 กุมภาพันธ์ 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
21:54:57 17 กุมภาพันธ์ 2561  :try to logon with: GS1WS
22:00:31 17 กุมภาพันธ์ 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
22:00:31 17 กุมภาพันธ์ 2561  :try to logon with: GS1WS
22:00:48 17 กุมภาพันธ์ 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
22:00:48 17 กุมภาพันธ์ 2561  :try to logon with: GS1WS
22:00:48 17 กุมภาพันธ์ 2561  :getGS1changed=/*SELECT        MB_MEMBER.MEMBER_CODE, MB_PRENAME.PRENAME_TH, MB_COMP_PERSON.COMP_PERSON_NAME_TH, MB_PRENAME.PRENAME_EN, MB_COMP_PERSON.COMP_PERSON_NAME_EN, 
                         MB_COMP_PERSON.TAX_ID, MB_MEMBER.REGIST_DATE, MB_MEMBER.MEMBER_MAIN_TYPE_CODE, MB_MEMBER.MEMBER_TYPE_CODE, MB_MEMBER.MEMBER_STATUS_CODE, MB_MEMBER_RETIRE.APPROVE_DATE
FROM            MB_MEMBER INNER JOIN
                         MB_COMP_PERSON ON MB_MEMBER.COMP_PERSON_CODE = MB_COMP_PERSON.COMP_PERSON_CODE INNER JOIN
                         MB_MEMBER_RETIRE ON MB_MEMBER.REGIST_CODE = MB_MEMBER_RETIRE.REGIST_CODE LEFT OUTER JOIN
                         MB_PRENAME ON MB_COMP_PERSON.PREN_CODE = MB_PRENAME.PRENAME_CODE
WHERE        (MB_MEMBER.MEMBER_MAIN_GROUP_CODE = '300') AND (MB_MEMBER_RETIRE.APPROVE_DATE BETWEEN dbo.fnc_StrToDateTime(@YYYYMMDD_FROM + '000000') AND dbo.fnc_StrToDateTime(@YYYYMMDD_TO + '235959'))
ORDER BY MB_MEMBER_RETIRE.APPROVE_DATE*/

--declare	@YYYYMMDD_FROM	varchar(max) = '20171101'
--declare	@YYYYMMDD_TO	varchar(max) = '20171201'

create table tempWsGs1_001
(
    id int,
	tax_id varchar(max)
)

create table tempWsGs1_002
(
    MEMBER_CODE varchar(max)
	, TAX_ID varchar(max)
	, BDB_CODE varchar(max)
	, MEMBER_MAIN_TYPE_CODE varchar(max)
	, MEMBER_MAIN_TYPE_NAME varchar(max)
	, MEMBER_TYPE_CODE varchar(max)
	, MEMBER_TYPE_NAME varchar(max)
	, BUSSINESS_TYPE_TH varchar(max)
	, BUSSINESS_TYPE_EN varchar(max)
    , PRENAME_TH varchar(max)
    , COMP_PERSON_NAME_TH varchar(max)
    , PRENAME_EN varchar(max)
    , COMP_PERSON_NAME_EN varchar(max)
	, ADDR_TH varchar(max)
	, ADDR_EN varchar(max)
    , ZIP_CODE_TH varchar(max)
	, ZIP_CODE_EN varchar(max)
	, TELEPHONE_TH varchar(max)
	, TELEPHONE_EN varchar(max)
	, EMAIL_TH varchar(max)
	, EMAIL_EN varchar(max)
	, STATUS varchar(max)
    , REGIST_DATE varchar(max)
	, MEMBER_DATE varchar(max)
	, UPDATE_DATE varchar(max)
	, CompanyPrefix varchar(max)
)

insert into tempWsGs1_001
select distinct ROW_NUMBER() over (order by r.approve_date) as id, c.TAX_ID as tax_id
from MB_MEMBER m,MB_COMP_PERSON c,MB_MEMBER_RETIRE r
where r.REGIST_CODE=m.REGIST_CODE and m.MEMBER_MAIN_GROUP_CODE='300' and m.COMP_PERSON_CODE=c.COMP_PERSON_CODE
		AND (r.APPROVE_DATE BETWEEN dbo.fnc_StrToDateTime(@YYYYMMDD_FROM + '000000') AND dbo.fnc_StrToDateTime(@YYYYMMDD_TO + '235959'))

declare @id int
declare @totalRows int = (select count(*) from tempWsGs1_001)
declare @currentRow int = 0
declare @BussinessTypeTH VARCHAR(max)
declare @BussinessTypeEN VARCHAR(max)

while @currentRow <  @totalRows  
begin 
    set @id = @currentRow+1

	declare @TAX_ID varchar(max)
	set @TAX_ID = (select top 1 tax_id from tempWsGs1_001 where id=@id)

	insert into tempWsGs1_002
	select * from fnc_GetGS1MemberInfoForWebServiceByTaxID(@TAX_ID)

    set @currentRow = @currentRow +1
end  

drop table tempWsGs1_001
select * from tempWsGs1_002
drop table tempWsGs1_002
22:00:48 17 กุมภาพันธ์ 2561  :There is already an object named 'tempWsGs1_001' in the database.
22:03:35 17 กุมภาพันธ์ 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
22:03:35 17 กุมภาพันธ์ 2561  :try to logon with: GS1WS
22:05:59 17 กุมภาพันธ์ 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
22:05:59 17 กุมภาพันธ์ 2561  :try to logon with: GS1WS
22:23:08 17 กุมภาพันธ์ 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
22:23:08 17 กุมภาพันธ์ 2561  :try to logon with: GS1WS
22:31:42 17 กุมภาพันธ์ 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
22:31:42 17 กุมภาพันธ์ 2561  :try to logon with: GS1WS
22:35:36 17 กุมภาพันธ์ 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
22:35:36 17 กุมภาพันธ์ 2561  :try to logon with: GS1WS
22:41:21 17 กุมภาพันธ์ 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
22:41:21 17 กุมภาพันธ์ 2561  :try to logon with: GS1WS
22:44:04 17 กุมภาพันธ์ 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
22:44:04 17 กุมภาพันธ์ 2561  :try to logon with: GS1WS
22:46:29 17 กุมภาพันธ์ 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
22:46:29 17 กุมภาพันธ์ 2561  :try to logon with: GS1WS
22:49:04 17 กุมภาพันธ์ 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
22:49:04 17 กุมภาพันธ์ 2561  :try to logon with: GS1WS
22:51:32 17 กุมภาพันธ์ 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
22:51:32 17 กุมภาพันธ์ 2561  :try to logon with: GS1WS
22:54:08 17 กุมภาพันธ์ 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
22:54:08 17 กุมภาพันธ์ 2561  :try to logon with: GS1WS
22:56:44 17 กุมภาพันธ์ 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
22:56:44 17 กุมภาพันธ์ 2561  :try to logon with: GS1WS
23:00:52 17 กุมภาพันธ์ 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
23:00:52 17 กุมภาพันธ์ 2561  :try to logon with: GS1WS
23:00:52 17 กุมภาพันธ์ 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:52 17 กุมภาพันธ์ 2561  :There is already an object named 'tempWsGs1_001' in the database.
23:04:32 17 กุมภาพันธ์ 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
23:04:32 17 กุมภาพันธ์ 2561  :try to logon with: GS1WS
23:14:40 17 กุมภาพันธ์ 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
23:14:40 17 กุมภาพันธ์ 2561  :try to logon with: GS1WS
23:17:31 17 กุมภาพันธ์ 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
23:17:31 17 กุมภาพันธ์ 2561  :try to logon with: GS1WS
23:20:05 17 กุมภาพันธ์ 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
23:20:05 17 กุมภาพันธ์ 2561  :try to logon with: GS1WS
23:23:01 17 กุมภาพันธ์ 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
23:23:01 17 กุมภาพันธ์ 2561  :try to logon with: GS1WS
23:25:42 17 กุมภาพันธ์ 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
23:25:42 17 กุมภาพันธ์ 2561  :try to logon with: GS1WS
23:28:23 17 กุมภาพันธ์ 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
23:28:23 17 กุมภาพันธ์ 2561  :try to logon with: GS1WS
23:34:15 17 กุมภาพันธ์ 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
23:34:15 17 กุมภาพันธ์ 2561  :try to logon with: GS1WS
23:47:46 17 กุมภาพันธ์ 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
23:47:46 17 กุมภาพันธ์ 2561  :try to logon with: GS1WS
23:58:39 17 กุมภาพันธ์ 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
23:58:39 17 กุมภาพันธ์ 2561  :try to logon with: GS1WS