0:07:34 6 มิถุนายน 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
0:07:34 6 มิถุนายน 2561  :try to logon with: GS1WS
0:07:34 6 มิถุนายน 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
0:07:34 6 มิถุนายน 2561  :try to logon with: GS1WS
0:59:43 6 มิถุนายน 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
0:59:43 6 มิถุนายน 2561  :try to logon with: GS1WS
0:59:43 6 มิถุนายน 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:59:43 6 มิถุนายน 2561  :There is already an object named 'tempWsGs1_001' in the database.
0:59:43 6 มิถุนายน 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
0:59:43 6 มิถุนายน 2561  :try to logon with: GS1WS
0:59:43 6 มิถุนายน 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:59:43 6 มิถุนายน 2561  :There is already an object named 'tempWsGs1_001' in the database.
1:55:34 6 มิถุนายน 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
1:55:34 6 มิถุนายน 2561  :try to logon with: GS1WS
1:55:34 6 มิถุนายน 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
1:55:34 6 มิถุนายน 2561  :try to logon with: GS1WS
1:59:42 6 มิถุนายน 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
1:59:42 6 มิถุนายน 2561  :try to logon with: GS1WS
1:59:42 6 มิถุนายน 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:59:42 6 มิถุนายน 2561  :There is already an object named 'tempWsGs1_001' in the database.
1:59:42 6 มิถุนายน 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
1:59:42 6 มิถุนายน 2561  :try to logon with: GS1WS
1:59:42 6 มิถุนายน 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:59:42 6 มิถุนายน 2561  :There is already an object named 'tempWsGs1_001' in the database.
2:59:43 6 มิถุนายน 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
2:59:43 6 มิถุนายน 2561  :try to logon with: GS1WS
2:59:43 6 มิถุนายน 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:59:43 6 มิถุนายน 2561  :There is already an object named 'tempWsGs1_001' in the database.
2:59:43 6 มิถุนายน 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
2:59:43 6 มิถุนายน 2561  :try to logon with: GS1WS
2:59:43 6 มิถุนายน 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:59:43 6 มิถุนายน 2561  :There is already an object named 'tempWsGs1_001' in the database.
3:59:42 6 มิถุนายน 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
3:59:42 6 มิถุนายน 2561  :try to logon with: GS1WS
3:59:42 6 มิถุนายน 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
3:59:42 6 มิถุนายน 2561  :try to logon with: GS1WS
3:59:42 6 มิถุนายน 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:59:42 6 มิถุนายน 2561  :There is already an object named 'tempWsGs1_001' in the database.
3:59:42 6 มิถุนายน 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:59:42 6 มิถุนายน 2561  :There is already an object named 'tempWsGs1_001' in the database.
4:59:43 6 มิถุนายน 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
4:59:43 6 มิถุนายน 2561  :try to logon with: GS1WS
4:59:43 6 มิถุนายน 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:59:43 6 มิถุนายน 2561  :There is already an object named 'tempWsGs1_001' in the database.
4:59:43 6 มิถุนายน 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
4:59:43 6 มิถุนายน 2561  :try to logon with: GS1WS
4:59:43 6 มิถุนายน 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:59:43 6 มิถุนายน 2561  :There is already an object named 'tempWsGs1_001' in the database.
5:59:42 6 มิถุนายน 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
5:59:42 6 มิถุนายน 2561  :try to logon with: GS1WS
5:59:42 6 มิถุนายน 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:59:42 6 มิถุนายน 2561  :There is already an object named 'tempWsGs1_001' in the database.
5:59:43 6 มิถุนายน 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
5:59:43 6 มิถุนายน 2561  :try to logon with: GS1WS
5:59:43 6 มิถุนายน 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:59:43 6 มิถุนายน 2561  :There is already an object named 'tempWsGs1_001' in the database.
6:59:43 6 มิถุนายน 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
6:59:43 6 มิถุนายน 2561  :try to logon with: GS1WS
6:59:43 6 มิถุนายน 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:59:43 6 มิถุนายน 2561  :There is already an object named 'tempWsGs1_001' in the database.
6:59:43 6 มิถุนายน 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
6:59:43 6 มิถุนายน 2561  :try to logon with: GS1WS
6:59:43 6 มิถุนายน 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:59:43 6 มิถุนายน 2561  :There is already an object named 'tempWsGs1_001' in the database.
7:59:42 6 มิถุนายน 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
7:59:42 6 มิถุนายน 2561  :try to logon with: GS1WS
7:59:42 6 มิถุนายน 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
7:59:42 6 มิถุนายน 2561  :try to logon with: GS1WS
7:59:42 6 มิถุนายน 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:59:42 6 มิถุนายน 2561  :There is already an object named 'tempWsGs1_001' in the database.
7:59:42 6 มิถุนายน 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:59:42 6 มิถุนายน 2561  :There is already an object named 'tempWsGs1_001' in the database.
8:59:42 6 มิถุนายน 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
8:59:42 6 มิถุนายน 2561  :try to logon with: GS1WS
8:59:42 6 มิถุนายน 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:59:42 6 มิถุนายน 2561  :There is already an object named 'tempWsGs1_001' in the database.
8:59:43 6 มิถุนายน 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
8:59:43 6 มิถุนายน 2561  :try to logon with: GS1WS
8:59:43 6 มิถุนายน 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:59:43 6 มิถุนายน 2561  :There is already an object named 'tempWsGs1_001' in the database.
9:36:42 6 มิถุนายน 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
9:36:42 6 มิถุนายน 2561  :try to logon with: GS1WS
9:36:42 6 มิถุนายน 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
9:36:42 6 มิถุนายน 2561  :try to logon with: GS1WS
9:37:45 6 มิถุนายน 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
9:37:45 6 มิถุนายน 2561  :try to logon with: GS1WS
9:37:45 6 มิถุนายน 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
9:37:45 6 มิถุนายน 2561  :try to logon with: GS1WS
9:40:11 6 มิถุนายน 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
9:40:11 6 มิถุนายน 2561  :try to logon with: GS1WS
9:40:11 6 มิถุนายน 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
9:40:11 6 มิถุนายน 2561  :try to logon with: GS1WS
9:42:24 6 มิถุนายน 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
9:42:24 6 มิถุนายน 2561  :try to logon with: GS1WS
9:42:24 6 มิถุนายน 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
9:42:24 6 มิถุนายน 2561  :try to logon with: GS1WS
9:44:32 6 มิถุนายน 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
9:44:32 6 มิถุนายน 2561  :try to logon with: GS1WS
9:44:33 6 มิถุนายน 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
9:44:33 6 มิถุนายน 2561  :try to logon with: GS1WS
9:45:19 6 มิถุนายน 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
9:45:19 6 มิถุนายน 2561  :try to logon with: GS1WS
9:45:20 6 มิถุนายน 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
9:45:20 6 มิถุนายน 2561  :try to logon with: GS1WS
9:59:42 6 มิถุนายน 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
9:59:42 6 มิถุนายน 2561  :try to logon with: GS1WS
9:59:42 6 มิถุนายน 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:59:42 6 มิถุนายน 2561  :There is already an object named 'tempWsGs1_001' in the database.
9:59:42 6 มิถุนายน 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
9:59:42 6 มิถุนายน 2561  :try to logon with: GS1WS
9:59:42 6 มิถุนายน 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:59:42 6 มิถุนายน 2561  :There is already an object named 'tempWsGs1_001' in the database.
10:09:36 6 มิถุนายน 2561  :Server was unable to process request. ---> Cannot open database "RDtmp" requested by the login. The login failed.
10:11:02 6 มิถุนายน 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
10:11:02 6 มิถุนายน 2561  :try to logon with: GS1WS
10:11:02 6 มิถุนายน 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
10:11:02 6 มิถุนายน 2561  :try to logon with: GS1WS
10:13:57 6 มิถุนายน 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
10:13:57 6 มิถุนายน 2561  :try to logon with: GS1WS
10:13:57 6 มิถุนายน 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
10:13:57 6 มิถุนายน 2561  :try to logon with: GS1WS
10:16:23 6 มิถุนายน 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
10:16:23 6 มิถุนายน 2561  :try to logon with: GS1WS
10:16:24 6 มิถุนายน 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
10:16:24 6 มิถุนายน 2561  :try to logon with: GS1WS
10:17:29 6 มิถุนายน 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
10:17:29 6 มิถุนายน 2561  :try to logon with: GS1WS
10:17:29 6 มิถุนายน 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
10:17:29 6 มิถุนายน 2561  :try to logon with: GS1WS
10:18:17 6 มิถุนายน 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
10:18:17 6 มิถุนายน 2561  :try to logon with: GS1WS
10:18:17 6 มิถุนายน 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
10:18:17 6 มิถุนายน 2561  :try to logon with: GS1WS
10:23:35 6 มิถุนายน 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
10:23:35 6 มิถุนายน 2561  :try to logon with: GS1WS
10:23:36 6 มิถุนายน 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
10:23:36 6 มิถุนายน 2561  :try to logon with: GS1WS
10:30:50 6 มิถุนายน 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
10:30:50 6 มิถุนายน 2561  :try to logon with: GS1WS
10:30:50 6 มิถุนายน 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
10:30:50 6 มิถุนายน 2561  :try to logon with: GS1WS
10:31:41 6 มิถุนายน 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
10:31:41 6 มิถุนายน 2561  :try to logon with: GS1WS
10:31:41 6 มิถุนายน 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
10:31:41 6 มิถุนายน 2561  :try to logon with: GS1WS
10:41:00 6 มิถุนายน 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
10:41:00 6 มิถุนายน 2561  :try to logon with: GS1WS
10:41:00 6 มิถุนายน 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
10:41:00 6 มิถุนายน 2561  :try to logon with: GS1WS
10:51:13 6 มิถุนายน 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
10:51:13 6 มิถุนายน 2561  :try to logon with: GS1WS
10:51:14 6 มิถุนายน 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
10:51:14 6 มิถุนายน 2561  :try to logon with: GS1WS
10:52:16 6 มิถุนายน 2561  :Server was unable to process request. ---> Cannot open database "RDtmp" requested by the login. The login failed.
10:59:42 6 มิถุนายน 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
10:59:42 6 มิถุนายน 2561  :try to logon with: GS1WS
10:59:42 6 มิถุนายน 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:59:42 6 มิถุนายน 2561  :There is already an object named 'tempWsGs1_001' in the database.
10:59:43 6 มิถุนายน 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
10:59:43 6 มิถุนายน 2561  :try to logon with: GS1WS
10:59:43 6 มิถุนายน 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:59:43 6 มิถุนายน 2561  :There is already an object named 'tempWsGs1_001' in the database.
11:08:59 6 มิถุนายน 2561  :Server was unable to process request. ---> Cannot open database "RDtmp" requested by the login. The login failed.
11:13:40 6 มิถุนายน 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
11:13:40 6 มิถุนายน 2561  :try to logon with: GS1WS
11:13:41 6 มิถุนายน 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
11:13:41 6 มิถุนายน 2561  :try to logon with: GS1WS
11:45:18 6 มิถุนายน 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
11:45:18 6 มิถุนายน 2561  :try to logon with: GS1WS
11:45:18 6 มิถุนายน 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
11:45:18 6 มิถุนายน 2561  :try to logon with: GS1WS
11:51:46 6 มิถุนายน 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
11:51:46 6 มิถุนายน 2561  :try to logon with: GS1WS
11:51:46 6 มิถุนายน 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
11:51:46 6 มิถุนายน 2561  :try to logon with: GS1WS
11:51:46 6 มิถุนายน 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
11:51:46 6 มิถุนายน 2561  :try to logon with: GS1WS
11:51:47 6 มิถุนายน 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
11:51:47 6 มิถุนายน 2561  :try to logon with: GS1WS
11:51:52 6 มิถุนายน 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
11:51:52 6 มิถุนายน 2561  :try to logon with: GS1WS
11:51:52 6 มิถุนายน 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:51:52 6 มิถุนายน 2561  :There is already an object named 'tempWsGs1_001' in the database.
11:57:24 6 มิถุนายน 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
11:57:24 6 มิถุนายน 2561  :try to logon with: GS1WS
11:57:24 6 มิถุนายน 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
11:57:24 6 มิถุนายน 2561  :try to logon with: GS1WS
11:57:52 6 มิถุนายน 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
11:57:52 6 มิถุนายน 2561  :try to logon with: GS1WS
11:57:52 6 มิถุนายน 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
11:57:52 6 มิถุนายน 2561  :try to logon with: GS1WS
11:59:42 6 มิถุนายน 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
11:59:42 6 มิถุนายน 2561  :try to logon with: GS1WS
11:59:42 6 มิถุนายน 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:59:42 6 มิถุนายน 2561  :There is already an object named 'tempWsGs1_001' in the database.
11:59:42 6 มิถุนายน 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
11:59:42 6 มิถุนายน 2561  :try to logon with: GS1WS
11:59:42 6 มิถุนายน 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:59:42 6 มิถุนายน 2561  :There is already an object named 'tempWsGs1_001' in the database.
11:59:53 6 มิถุนายน 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
11:59:53 6 มิถุนายน 2561  :try to logon with: GS1WS
11:59:53 6 มิถุนายน 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
11:59:53 6 มิถุนายน 2561  :try to logon with: GS1WS
12:06:28 6 มิถุนายน 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
12:06:28 6 มิถุนายน 2561  :try to logon with: GS1WS
12:06:28 6 มิถุนายน 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
12:06:28 6 มิถุนายน 2561  :try to logon with: GS1WS
12:07:10 6 มิถุนายน 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
12:07:10 6 มิถุนายน 2561  :try to logon with: GS1WS
12:07:11 6 มิถุนายน 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
12:07:11 6 มิถุนายน 2561  :try to logon with: GS1WS
12:08:07 6 มิถุนายน 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
12:08:07 6 มิถุนายน 2561  :try to logon with: GS1WS
12:08:08 6 มิถุนายน 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
12:08:08 6 มิถุนายน 2561  :try to logon with: GS1WS
12:10:10 6 มิถุนายน 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
12:10:10 6 มิถุนายน 2561  :try to logon with: GS1WS
12:10:11 6 มิถุนายน 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
12:10:11 6 มิถุนายน 2561  :try to logon with: GS1WS
12:10:36 6 มิถุนายน 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
12:10:36 6 มิถุนายน 2561  :try to logon with: GS1WS
12:10:36 6 มิถุนายน 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
12:10:36 6 มิถุนายน 2561  :try to logon with: GS1WS
12:11:00 6 มิถุนายน 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
12:11:00 6 มิถุนายน 2561  :try to logon with: GS1WS
12:11:00 6 มิถุนายน 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
12:11:00 6 มิถุนายน 2561  :try to logon with: GS1WS
12:22:28 6 มิถุนายน 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
12:22:28 6 มิถุนายน 2561  :try to logon with: GS1WS
12:22:28 6 มิถุนายน 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
12:22:28 6 มิถุนายน 2561  :try to logon with: GS1WS
12:45:23 6 มิถุนายน 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
12:45:23 6 มิถุนายน 2561  :try to logon with: GS1WS
12:45:23 6 มิถุนายน 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
12:45:23 6 มิถุนายน 2561  :try to logon with: GS1WS
12:59:42 6 มิถุนายน 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
12:59:42 6 มิถุนายน 2561  :try to logon with: GS1WS
12:59:42 6 มิถุนายน 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:59:42 6 มิถุนายน 2561  :There is already an object named 'tempWsGs1_001' in the database.
12:59:44 6 มิถุนายน 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
12:59:44 6 มิถุนายน 2561  :try to logon with: GS1WS
12:59:44 6 มิถุนายน 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:59:44 6 มิถุนายน 2561  :There is already an object named 'tempWsGs1_001' in the database.
13:07:16 6 มิถุนายน 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
13:07:16 6 มิถุนายน 2561  :try to logon with: GS1WS
13:07:17 6 มิถุนายน 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
13:07:17 6 มิถุนายน 2561  :try to logon with: GS1WS
13:07:47 6 มิถุนายน 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
13:07:47 6 มิถุนายน 2561  :try to logon with: GS1WS
13:07:47 6 มิถุนายน 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
13:07:47 6 มิถุนายน 2561  :try to logon with: GS1WS
13:08:42 6 มิถุนายน 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
13:08:42 6 มิถุนายน 2561  :try to logon with: GS1WS
13:08:42 6 มิถุนายน 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
13:08:42 6 มิถุนายน 2561  :try to logon with: GS1WS
13:14:11 6 มิถุนายน 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
13:14:11 6 มิถุนายน 2561  :try to logon with: GS1WS
13:14:11 6 มิถุนายน 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
13:14:11 6 มิถุนายน 2561  :try to logon with: GS1WS
13:14:41 6 มิถุนายน 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
13:14:41 6 มิถุนายน 2561  :try to logon with: GS1WS
13:14:41 6 มิถุนายน 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
13:14:41 6 มิถุนายน 2561  :try to logon with: GS1WS
13:15:29 6 มิถุนายน 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
13:15:29 6 มิถุนายน 2561  :try to logon with: GS1WS
13:15:30 6 มิถุนายน 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
13:15:30 6 มิถุนายน 2561  :try to logon with: GS1WS
13:18:21 6 มิถุนายน 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
13:18:21 6 มิถุนายน 2561  :try to logon with: GS1WS
13:18:22 6 มิถุนายน 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
13:18:22 6 มิถุนายน 2561  :try to logon with: GS1WS
13:18:51 6 มิถุนายน 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
13:18:51 6 มิถุนายน 2561  :try to logon with: GS1WS
13:18:51 6 มิถุนายน 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
13:18:51 6 มิถุนายน 2561  :try to logon with: GS1WS
13:19:43 6 มิถุนายน 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
13:19:43 6 มิถุนายน 2561  :try to logon with: GS1WS
13:19:43 6 มิถุนายน 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
13:19:43 6 มิถุนายน 2561  :try to logon with: GS1WS
13:38:44 6 มิถุนายน 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
13:38:44 6 มิถุนายน 2561  :try to logon with: GS1WS
13:38:44 6 มิถุนายน 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
13:38:44 6 มิถุนายน 2561  :try to logon with: GS1WS
13:59:42 6 มิถุนายน 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
13:59:42 6 มิถุนายน 2561  :try to logon with: GS1WS
13:59:42 6 มิถุนายน 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:59:42 6 มิถุนายน 2561  :There is already an object named 'tempWsGs1_001' in the database.
13:59:42 6 มิถุนายน 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
13:59:42 6 มิถุนายน 2561  :try to logon with: GS1WS
13:59:42 6 มิถุนายน 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:59:42 6 มิถุนายน 2561  :There is already an object named 'tempWsGs1_001' in the database.
14:03:10 6 มิถุนายน 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
14:03:10 6 มิถุนายน 2561  :try to logon with: GS1WS
14:03:10 6 มิถุนายน 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
14:03:10 6 มิถุนายน 2561  :try to logon with: GS1WS
14:10:26 6 มิถุนายน 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
14:10:26 6 มิถุนายน 2561  :try to logon with: GS1WS
14:10:27 6 มิถุนายน 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
14:10:27 6 มิถุนายน 2561  :try to logon with: GS1WS
14:11:35 6 มิถุนายน 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
14:11:35 6 มิถุนายน 2561  :try to logon with: GS1WS
14:11:35 6 มิถุนายน 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
14:11:35 6 มิถุนายน 2561  :try to logon with: GS1WS
14:13:03 6 มิถุนายน 2561  :Server was unable to process request. ---> Cannot open database "RDtmp" requested by the login. The login failed.
14:19:20 6 มิถุนายน 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
14:19:20 6 มิถุนายน 2561  :try to logon with: GS1WS
14:19:20 6 มิถุนายน 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
14:19:20 6 มิถุนายน 2561  :try to logon with: GS1WS
14:19:44 6 มิถุนายน 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
14:19:44 6 มิถุนายน 2561  :try to logon with: GS1WS
14:19:45 6 มิถุนายน 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
14:19:45 6 มิถุนายน 2561  :try to logon with: GS1WS
14:22:40 6 มิถุนายน 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
14:22:40 6 มิถุนายน 2561  :try to logon with: GS1WS
14:22:40 6 มิถุนายน 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
14:22:40 6 มิถุนายน 2561  :try to logon with: GS1WS
14:25:42 6 มิถุนายน 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
14:25:42 6 มิถุนายน 2561  :try to logon with: GS1WS
14:25:42 6 มิถุนายน 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
14:25:42 6 มิถุนายน 2561  :try to logon with: GS1WS
14:28:22 6 มิถุนายน 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
14:28:22 6 มิถุนายน 2561  :try to logon with: GS1WS
14:28:22 6 มิถุนายน 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
14:28:22 6 มิถุนายน 2561  :try to logon with: GS1WS
14:29:03 6 มิถุนายน 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
14:29:03 6 มิถุนายน 2561  :try to logon with: GS1WS
14:29:03 6 มิถุนายน 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
14:29:03 6 มิถุนายน 2561  :try to logon with: GS1WS
14:48:23 6 มิถุนายน 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
14:48:23 6 มิถุนายน 2561  :try to logon with: GS1WS
14:48:23 6 มิถุนายน 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
14:48:23 6 มิถุนายน 2561  :try to logon with: GS1WS
14:57:32 6 มิถุนายน 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
14:57:32 6 มิถุนายน 2561  :try to logon with: GS1WS
14:57:32 6 มิถุนายน 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
14:57:32 6 มิถุนายน 2561  :try to logon with: GS1WS
14:58:08 6 มิถุนายน 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
14:58:08 6 มิถุนายน 2561  :try to logon with: GS1WS
14:58:08 6 มิถุนายน 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
14:58:08 6 มิถุนายน 2561  :try to logon with: GS1WS
14:59:08 6 มิถุนายน 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
14:59:08 6 มิถุนายน 2561  :try to logon with: GS1WS
14:59:09 6 มิถุนายน 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
14:59:09 6 มิถุนายน 2561  :try to logon with: GS1WS
14:59:42 6 มิถุนายน 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
14:59:42 6 มิถุนายน 2561  :try to logon with: GS1WS
14:59:42 6 มิถุนายน 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:59:42 6 มิถุนายน 2561  :There is already an object named 'tempWsGs1_001' in the database.
14:59:42 6 มิถุนายน 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
14:59:42 6 มิถุนายน 2561  :try to logon with: GS1WS
14:59:42 6 มิถุนายน 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:59:42 6 มิถุนายน 2561  :There is already an object named 'tempWsGs1_001' in the database.
15:07:34 6 มิถุนายน 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
15:07:34 6 มิถุนายน 2561  :try to logon with: GS1WS
15:07:34 6 มิถุนายน 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
15:07:34 6 มิถุนายน 2561  :try to logon with: GS1WS
15:10:20 6 มิถุนายน 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
15:10:20 6 มิถุนายน 2561  :try to logon with: GS1WS
15:10:20 6 มิถุนายน 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
15:10:20 6 มิถุนายน 2561  :try to logon with: GS1WS
15:26:25 6 มิถุนายน 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
15:26:25 6 มิถุนายน 2561  :try to logon with: GS1WS
15:26:25 6 มิถุนายน 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
15:26:25 6 มิถุนายน 2561  :try to logon with: GS1WS
15:27:09 6 มิถุนายน 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
15:27:09 6 มิถุนายน 2561  :try to logon with: GS1WS
15:27:09 6 มิถุนายน 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
15:27:09 6 มิถุนายน 2561  :try to logon with: GS1WS
15:27:47 6 มิถุนายน 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
15:27:47 6 มิถุนายน 2561  :try to logon with: GS1WS
15:27:48 6 มิถุนายน 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
15:27:48 6 มิถุนายน 2561  :try to logon with: GS1WS
15:28:22 6 มิถุนายน 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
15:28:22 6 มิถุนายน 2561  :try to logon with: GS1WS
15:28:24 6 มิถุนายน 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
15:28:24 6 มิถุนายน 2561  :try to logon with: GS1WS
15:28:54 6 มิถุนายน 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
15:28:54 6 มิถุนายน 2561  :try to logon with: GS1WS
15:28:54 6 มิถุนายน 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
15:28:54 6 มิถุนายน 2561  :try to logon with: GS1WS
15:45:43 6 มิถุนายน 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
15:45:43 6 มิถุนายน 2561  :try to logon with: GS1WS
15:45:43 6 มิถุนายน 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
15:45:43 6 มิถุนายน 2561  :try to logon with: GS1WS
15:46:39 6 มิถุนายน 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
15:46:39 6 มิถุนายน 2561  :try to logon with: GS1WS
15:46:40 6 มิถุนายน 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
15:46:40 6 มิถุนายน 2561  :try to logon with: GS1WS
15:47:33 6 มิถุนายน 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
15:47:33 6 มิถุนายน 2561  :try to logon with: GS1WS
15:47:33 6 มิถุนายน 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
15:47:33 6 มิถุนายน 2561  :try to logon with: GS1WS
15:49:25 6 มิถุนายน 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
15:49:25 6 มิถุนายน 2561  :try to logon with: GS1WS
15:49:26 6 มิถุนายน 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
15:49:26 6 มิถุนายน 2561  :try to logon with: GS1WS
15:50:27 6 มิถุนายน 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
15:50:27 6 มิถุนายน 2561  :try to logon with: GS1WS
15:50:27 6 มิถุนายน 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
15:50:27 6 มิถุนายน 2561  :try to logon with: GS1WS
15:50:31 6 มิถุนายน 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
15:50:31 6 มิถุนายน 2561  :try to logon with: GS1WS
15:50:31 6 มิถุนายน 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
15:50:31 6 มิถุนายน 2561  :try to logon with: GS1WS
15:51:06 6 มิถุนายน 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
15:51:06 6 มิถุนายน 2561  :try to logon with: GS1WS
15:51:06 6 มิถุนายน 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
15:51:06 6 มิถุนายน 2561  :try to logon with: GS1WS
15:51:20 6 มิถุนายน 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
15:51:20 6 มิถุนายน 2561  :try to logon with: GS1WS
15:51:20 6 มิถุนายน 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
15:51:20 6 มิถุนายน 2561  :try to logon with: GS1WS
15:52:23 6 มิถุนายน 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
15:52:23 6 มิถุนายน 2561  :try to logon with: GS1WS
15:52:23 6 มิถุนายน 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
15:52:23 6 มิถุนายน 2561  :try to logon with: GS1WS
15:59:44 6 มิถุนายน 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
15:59:44 6 มิถุนายน 2561  :try to logon with: GS1WS
15:59:44 6 มิถุนายน 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:59:44 6 มิถุนายน 2561  :There is already an object named 'tempWsGs1_001' in the database.
15:59:44 6 มิถุนายน 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
15:59:44 6 มิถุนายน 2561  :try to logon with: GS1WS
15:59:44 6 มิถุนายน 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:59:44 6 มิถุนายน 2561  :There is already an object named 'tempWsGs1_001' in the database.
16:02:10 6 มิถุนายน 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
16:02:10 6 มิถุนายน 2561  :try to logon with: GS1WS
16:11:07 6 มิถุนายน 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
16:11:07 6 มิถุนายน 2561  :try to logon with: GS1WS
16:11:07 6 มิถุนายน 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
16:11:07 6 มิถุนายน 2561  :try to logon with: GS1WS
16:14:03 6 มิถุนายน 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
16:14:03 6 มิถุนายน 2561  :try to logon with: GS1WS
16:14:04 6 มิถุนายน 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
16:14:04 6 มิถุนายน 2561  :try to logon with: GS1WS
16:15:45 6 มิถุนายน 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
16:15:45 6 มิถุนายน 2561  :try to logon with: GS1WS
16:16:38 6 มิถุนายน 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
16:16:38 6 มิถุนายน 2561  :try to logon with: GS1WS
16:17:42 6 มิถุนายน 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
16:17:42 6 มิถุนายน 2561  :try to logon with: GS1WS
16:19:57 6 มิถุนายน 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
16:19:57 6 มิถุนายน 2561  :try to logon with: GS1WS
16:20:14 6 มิถุนายน 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
16:20:14 6 มิถุนายน 2561  :try to logon with: GS1WS
16:22:44 6 มิถุนายน 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
16:22:44 6 มิถุนายน 2561  :try to logon with: GS1WS
16:22:45 6 มิถุนายน 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
16:22:45 6 มิถุนายน 2561  :try to logon with: GS1WS
16:23:05 6 มิถุนายน 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
16:23:05 6 มิถุนายน 2561  :try to logon with: GS1WS
16:23:06 6 มิถุนายน 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
16:23:06 6 มิถุนายน 2561  :try to logon with: GS1WS
16:25:16 6 มิถุนายน 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
16:25:16 6 มิถุนายน 2561  :try to logon with: GS1WS
16:25:32 6 มิถุนายน 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
16:25:32 6 มิถุนายน 2561  :try to logon with: GS1WS
16:25:33 6 มิถุนายน 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
16:25:33 6 มิถุนายน 2561  :try to logon with: GS1WS
16:27:06 6 มิถุนายน 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
16:27:06 6 มิถุนายน 2561  :try to logon with: GS1WS
16:27:06 6 มิถุนายน 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
16:27:06 6 มิถุนายน 2561  :try to logon with: GS1WS
16:27:27 6 มิถุนายน 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
16:27:27 6 มิถุนายน 2561  :try to logon with: GS1WS
16:27:27 6 มิถุนายน 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
16:27:27 6 มิถุนายน 2561  :try to logon with: GS1WS
16:28:03 6 มิถุนายน 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
16:28:03 6 มิถุนายน 2561  :try to logon with: GS1WS
16:28:04 6 มิถุนายน 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
16:28:04 6 มิถุนายน 2561  :try to logon with: GS1WS
16:28:15 6 มิถุนายน 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
16:28:15 6 มิถุนายน 2561  :try to logon with: GS1WS
16:28:43 6 มิถุนายน 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
16:28:43 6 มิถุนายน 2561  :try to logon with: GS1WS
16:28:43 6 มิถุนายน 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
16:28:43 6 มิถุนายน 2561  :try to logon with: GS1WS
16:29:15 6 มิถุนายน 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
16:29:15 6 มิถุนายน 2561  :try to logon with: GS1WS
16:29:44 6 มิถุนายน 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
16:29:44 6 มิถุนายน 2561  :try to logon with: GS1WS
16:29:45 6 มิถุนายน 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
16:29:45 6 มิถุนายน 2561  :try to logon with: GS1WS
16:30:04 6 มิถุนายน 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
16:30:04 6 มิถุนายน 2561  :try to logon with: GS1WS
16:30:04 6 มิถุนายน 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
16:30:04 6 มิถุนายน 2561  :try to logon with: GS1WS
16:31:00 6 มิถุนายน 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
16:31:00 6 มิถุนายน 2561  :try to logon with: GS1WS
16:31:00 6 มิถุนายน 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
16:31:00 6 มิถุนายน 2561  :try to logon with: GS1WS
16:31:13 6 มิถุนายน 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
16:31:13 6 มิถุนายน 2561  :try to logon with: GS1WS
16:31:13 6 มิถุนายน 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
16:31:13 6 มิถุนายน 2561  :try to logon with: GS1WS
16:31:33 6 มิถุนายน 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
16:31:33 6 มิถุนายน 2561  :try to logon with: GS1WS
16:35:32 6 มิถุนายน 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
16:35:32 6 มิถุนายน 2561  :try to logon with: GS1WS
16:35:33 6 มิถุนายน 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
16:35:33 6 มิถุนายน 2561  :try to logon with: GS1WS
16:35:52 6 มิถุนายน 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
16:35:52 6 มิถุนายน 2561  :try to logon with: GS1WS
16:35:53 6 มิถุนายน 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
16:35:53 6 มิถุนายน 2561  :try to logon with: GS1WS
16:36:23 6 มิถุนายน 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
16:36:23 6 มิถุนายน 2561  :try to logon with: GS1WS
16:36:23 6 มิถุนายน 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
16:36:23 6 มิถุนายน 2561  :try to logon with: GS1WS
16:38:23 6 มิถุนายน 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
16:38:23 6 มิถุนายน 2561  :try to logon with: GS1WS
16:38:23 6 มิถุนายน 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
16:38:23 6 มิถุนายน 2561  :try to logon with: GS1WS
16:38:39 6 มิถุนายน 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
16:38:39 6 มิถุนายน 2561  :try to logon with: GS1WS
16:38:40 6 มิถุนายน 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
16:38:40 6 มิถุนายน 2561  :try to logon with: GS1WS
16:38:55 6 มิถุนายน 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
16:38:55 6 มิถุนายน 2561  :try to logon with: GS1WS
16:38:55 6 มิถุนายน 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
16:38:55 6 มิถุนายน 2561  :try to logon with: GS1WS
16:41:30 6 มิถุนายน 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
16:41:30 6 มิถุนายน 2561  :try to logon with: GS1WS
16:44:50 6 มิถุนายน 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
16:44:50 6 มิถุนายน 2561  :try to logon with: GS1WS
16:44:55 6 มิถุนายน 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
16:44:55 6 มิถุนายน 2561  :try to logon with: GS1WS
16:48:53 6 มิถุนายน 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
16:48:53 6 มิถุนายน 2561  :try to logon with: GS1WS
16:59:42 6 มิถุนายน 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
16:59:42 6 มิถุนายน 2561  :try to logon with: GS1WS
16:59:42 6 มิถุนายน 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:59:42 6 มิถุนายน 2561  :There is already an object named 'tempWsGs1_001' in the database.
16:59:43 6 มิถุนายน 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
16:59:43 6 มิถุนายน 2561  :try to logon with: GS1WS
16:59:43 6 มิถุนายน 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:59:43 6 มิถุนายน 2561  :There is already an object named 'tempWsGs1_001' in the database.
17:10:07 6 มิถุนายน 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
17:10:07 6 มิถุนายน 2561  :try to logon with: GS1WS
17:10:09 6 มิถุนายน 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
17:10:09 6 มิถุนายน 2561  :try to logon with: GS1WS
17:10:18 6 มิถุนายน 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
17:10:18 6 มิถุนายน 2561  :try to logon with: GS1WS
17:14:49 6 มิถุนายน 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
17:14:49 6 มิถุนายน 2561  :try to logon with: GS1WS
17:19:43 6 มิถุนายน 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
17:19:43 6 มิถุนายน 2561  :try to logon with: GS1WS
17:19:44 6 มิถุนายน 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
17:19:44 6 มิถุนายน 2561  :try to logon with: GS1WS
17:29:54 6 มิถุนายน 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
17:29:54 6 มิถุนายน 2561  :try to logon with: GS1WS
17:36:01 6 มิถุนายน 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
17:36:01 6 มิถุนายน 2561  :try to logon with: GS1WS
17:39:09 6 มิถุนายน 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
17:39:09 6 มิถุนายน 2561  :try to logon with: GS1WS
17:39:14 6 มิถุนายน 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
17:39:14 6 มิถุนายน 2561  :try to logon with: GS1WS
17:43:01 6 มิถุนายน 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
17:43:01 6 มิถุนายน 2561  :try to logon with: GS1WS
17:43:15 6 มิถุนายน 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
17:43:15 6 มิถุนายน 2561  :try to logon with: GS1WS
17:59:43 6 มิถุนายน 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
17:59:43 6 มิถุนายน 2561  :try to logon with: GS1WS
17:59:43 6 มิถุนายน 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:59:43 6 มิถุนายน 2561  :There is already an object named 'tempWsGs1_001' in the database.
17:59:45 6 มิถุนายน 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
17:59:45 6 มิถุนายน 2561  :try to logon with: GS1WS
17:59:45 6 มิถุนายน 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:59:45 6 มิถุนายน 2561  :There is already an object named 'tempWsGs1_001' in the database.
18:59:48 6 มิถุนายน 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
18:59:48 6 มิถุนายน 2561  :try to logon with: GS1WS
18:59:48 6 มิถุนายน 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:59:48 6 มิถุนายน 2561  :There is already an object named 'tempWsGs1_001' in the database.
18:59:48 6 มิถุนายน 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
18:59:48 6 มิถุนายน 2561  :try to logon with: GS1WS
18:59:48 6 มิถุนายน 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:59:48 6 มิถุนายน 2561  :There is already an object named 'tempWsGs1_001' in the database.
19:59:42 6 มิถุนายน 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
19:59:42 6 มิถุนายน 2561  :try to logon with: GS1WS
19:59:42 6 มิถุนายน 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:59:42 6 มิถุนายน 2561  :There is already an object named 'tempWsGs1_001' in the database.
19:59:42 6 มิถุนายน 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
19:59:42 6 มิถุนายน 2561  :try to logon with: GS1WS
19:59:42 6 มิถุนายน 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:59:42 6 มิถุนายน 2561  :There is already an object named 'tempWsGs1_001' in the database.
20:24:26 6 มิถุนายน 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
20:24:26 6 มิถุนายน 2561  :try to logon with: GS1WS
20:24:26 6 มิถุนายน 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
20:24:26 6 มิถุนายน 2561  :try to logon with: GS1WS
20:59:42 6 มิถุนายน 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
20:59:42 6 มิถุนายน 2561  :try to logon with: GS1WS
20:59:42 6 มิถุนายน 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:59:42 6 มิถุนายน 2561  :There is already an object named 'tempWsGs1_001' in the database.
20:59:42 6 มิถุนายน 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
20:59:42 6 มิถุนายน 2561  :try to logon with: GS1WS
20:59:42 6 มิถุนายน 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:59:42 6 มิถุนายน 2561  :There is already an object named 'tempWsGs1_001' in the database.
21:37:29 6 มิถุนายน 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
21:37:29 6 มิถุนายน 2561  :try to logon with: GS1WS
21:37:30 6 มิถุนายน 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
21:37:30 6 มิถุนายน 2561  :try to logon with: GS1WS
21:59:42 6 มิถุนายน 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
21:59:42 6 มิถุนายน 2561  :try to logon with: GS1WS
21:59:42 6 มิถุนายน 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:59:42 6 มิถุนายน 2561  :There is already an object named 'tempWsGs1_001' in the database.
21:59:42 6 มิถุนายน 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
21:59:42 6 มิถุนายน 2561  :try to logon with: GS1WS
21:59:42 6 มิถุนายน 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:59:42 6 มิถุนายน 2561  :There is already an object named 'tempWsGs1_001' in the database.
22:59:42 6 มิถุนายน 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
22:59:42 6 มิถุนายน 2561  :try to logon with: GS1WS
22:59:42 6 มิถุนายน 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:59:42 6 มิถุนายน 2561  :There is already an object named 'tempWsGs1_001' in the database.
22:59:42 6 มิถุนายน 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
22:59:42 6 มิถุนายน 2561  :try to logon with: GS1WS
22:59:42 6 มิถุนายน 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:59:42 6 มิถุนายน 2561  :There is already an object named 'tempWsGs1_001' in the database.
23:57:20 6 มิถุนายน 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
23:57:20 6 มิถุนายน 2561  :try to logon with: GS1WS
23:57:20 6 มิถุนายน 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
23:57:20 6 มิถุนายน 2561  :try to logon with: GS1WS
23:57:25 6 มิถุนายน 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
23:57:25 6 มิถุนายน 2561  :try to logon with: GS1WS
23:57:26 6 มิถุนายน 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
23:57:26 6 มิถุนายน 2561  :try to logon with: GS1WS
23:58:54 6 มิถุนายน 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
23:58:54 6 มิถุนายน 2561  :try to logon with: GS1WS
23:58:54 6 มิถุนายน 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
23:58:54 6 มิถุนายน 2561  :try to logon with: GS1WS
23:59:06 6 มิถุนายน 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
23:59:06 6 มิถุนายน 2561  :try to logon with: GS1WS
23:59:06 6 มิถุนายน 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
23:59:06 6 มิถุนายน 2561  :try to logon with: GS1WS
23:59:42 6 มิถุนายน 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
23:59:42 6 มิถุนายน 2561  :try to logon with: GS1WS
23:59:42 6 มิถุนายน 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:59:42 6 มิถุนายน 2561  :There is already an object named 'tempWsGs1_001' in the database.
23:59:42 6 มิถุนายน 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
23:59:42 6 มิถุนายน 2561  :try to logon with: GS1WS
23:59:42 6 มิถุนายน 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:59:42 6 มิถุนายน 2561  :There is already an object named 'tempWsGs1_001' in the database.