0:00:24 29 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
0:00:24 29 มีนาคม 2561  :try to logon with: GS1WS
0:00:24 29 มีนาคม 2561  :getGS1changed=/*SELECT        MB_MEMBER.MEMBER_CODE, MB_PRENAME.PRENAME_TH, MB_COMP_PERSON.COMP_PERSON_NAME_TH, MB_PRENAME.PRENAME_EN, MB_COMP_PERSON.COMP_PERSON_NAME_EN, 
                         MB_COMP_PERSON.TAX_ID, MB_MEMBER.REGIST_DATE, MB_MEMBER.MEMBER_MAIN_TYPE_CODE, MB_MEMBER.MEMBER_TYPE_CODE, MB_MEMBER.MEMBER_STATUS_CODE, MB_MEMBER_RETIRE.APPROVE_DATE
FROM            MB_MEMBER INNER JOIN
                         MB_COMP_PERSON ON MB_MEMBER.COMP_PERSON_CODE = MB_COMP_PERSON.COMP_PERSON_CODE INNER JOIN
                         MB_MEMBER_RETIRE ON MB_MEMBER.REGIST_CODE = MB_MEMBER_RETIRE.REGIST_CODE LEFT OUTER JOIN
                         MB_PRENAME ON MB_COMP_PERSON.PREN_CODE = MB_PRENAME.PRENAME_CODE
WHERE        (MB_MEMBER.MEMBER_MAIN_GROUP_CODE = '300') AND (MB_MEMBER_RETIRE.APPROVE_DATE BETWEEN dbo.fnc_StrToDateTime(@YYYYMMDD_FROM + '000000') AND dbo.fnc_StrToDateTime(@YYYYMMDD_TO + '235959'))
ORDER BY MB_MEMBER_RETIRE.APPROVE_DATE*/

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

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

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

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

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

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

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

	insert into tempWsGs1_002
	select * from fnc_GetGS1MemberInfoForWebServiceByTaxID(@TAX_ID)

    set @currentRow = @currentRow +1
end  

drop table tempWsGs1_001
select * from tempWsGs1_002
drop table tempWsGs1_002
0:00:24 29 มีนาคม 2561  :There is already an object named 'tempWsGs1_001' in the database.
1:00:24 29 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
1:00:24 29 มีนาคม 2561  :try to logon with: GS1WS
1:00:24 29 มีนาคม 2561  :getGS1changed=/*SELECT        MB_MEMBER.MEMBER_CODE, MB_PRENAME.PRENAME_TH, MB_COMP_PERSON.COMP_PERSON_NAME_TH, MB_PRENAME.PRENAME_EN, MB_COMP_PERSON.COMP_PERSON_NAME_EN, 
                         MB_COMP_PERSON.TAX_ID, MB_MEMBER.REGIST_DATE, MB_MEMBER.MEMBER_MAIN_TYPE_CODE, MB_MEMBER.MEMBER_TYPE_CODE, MB_MEMBER.MEMBER_STATUS_CODE, MB_MEMBER_RETIRE.APPROVE_DATE
FROM            MB_MEMBER INNER JOIN
                         MB_COMP_PERSON ON MB_MEMBER.COMP_PERSON_CODE = MB_COMP_PERSON.COMP_PERSON_CODE INNER JOIN
                         MB_MEMBER_RETIRE ON MB_MEMBER.REGIST_CODE = MB_MEMBER_RETIRE.REGIST_CODE LEFT OUTER JOIN
                         MB_PRENAME ON MB_COMP_PERSON.PREN_CODE = MB_PRENAME.PRENAME_CODE
WHERE        (MB_MEMBER.MEMBER_MAIN_GROUP_CODE = '300') AND (MB_MEMBER_RETIRE.APPROVE_DATE BETWEEN dbo.fnc_StrToDateTime(@YYYYMMDD_FROM + '000000') AND dbo.fnc_StrToDateTime(@YYYYMMDD_TO + '235959'))
ORDER BY MB_MEMBER_RETIRE.APPROVE_DATE*/

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

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

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

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

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

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

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

	insert into tempWsGs1_002
	select * from fnc_GetGS1MemberInfoForWebServiceByTaxID(@TAX_ID)

    set @currentRow = @currentRow +1
end  

drop table tempWsGs1_001
select * from tempWsGs1_002
drop table tempWsGs1_002
1:00:24 29 มีนาคม 2561  :There is already an object named 'tempWsGs1_001' in the database.
2:00:25 29 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
2:00:25 29 มีนาคม 2561  :try to logon with: GS1WS
2:00:25 29 มีนาคม 2561  :getGS1changed=/*SELECT        MB_MEMBER.MEMBER_CODE, MB_PRENAME.PRENAME_TH, MB_COMP_PERSON.COMP_PERSON_NAME_TH, MB_PRENAME.PRENAME_EN, MB_COMP_PERSON.COMP_PERSON_NAME_EN, 
                         MB_COMP_PERSON.TAX_ID, MB_MEMBER.REGIST_DATE, MB_MEMBER.MEMBER_MAIN_TYPE_CODE, MB_MEMBER.MEMBER_TYPE_CODE, MB_MEMBER.MEMBER_STATUS_CODE, MB_MEMBER_RETIRE.APPROVE_DATE
FROM            MB_MEMBER INNER JOIN
                         MB_COMP_PERSON ON MB_MEMBER.COMP_PERSON_CODE = MB_COMP_PERSON.COMP_PERSON_CODE INNER JOIN
                         MB_MEMBER_RETIRE ON MB_MEMBER.REGIST_CODE = MB_MEMBER_RETIRE.REGIST_CODE LEFT OUTER JOIN
                         MB_PRENAME ON MB_COMP_PERSON.PREN_CODE = MB_PRENAME.PRENAME_CODE
WHERE        (MB_MEMBER.MEMBER_MAIN_GROUP_CODE = '300') AND (MB_MEMBER_RETIRE.APPROVE_DATE BETWEEN dbo.fnc_StrToDateTime(@YYYYMMDD_FROM + '000000') AND dbo.fnc_StrToDateTime(@YYYYMMDD_TO + '235959'))
ORDER BY MB_MEMBER_RETIRE.APPROVE_DATE*/

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

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

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

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

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

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

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

	insert into tempWsGs1_002
	select * from fnc_GetGS1MemberInfoForWebServiceByTaxID(@TAX_ID)

    set @currentRow = @currentRow +1
end  

drop table tempWsGs1_001
select * from tempWsGs1_002
drop table tempWsGs1_002
2:00:25 29 มีนาคม 2561  :There is already an object named 'tempWsGs1_001' in the database.
3:00:24 29 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
3:00:24 29 มีนาคม 2561  :try to logon with: GS1WS
3:00:24 29 มีนาคม 2561  :getGS1changed=/*SELECT        MB_MEMBER.MEMBER_CODE, MB_PRENAME.PRENAME_TH, MB_COMP_PERSON.COMP_PERSON_NAME_TH, MB_PRENAME.PRENAME_EN, MB_COMP_PERSON.COMP_PERSON_NAME_EN, 
                         MB_COMP_PERSON.TAX_ID, MB_MEMBER.REGIST_DATE, MB_MEMBER.MEMBER_MAIN_TYPE_CODE, MB_MEMBER.MEMBER_TYPE_CODE, MB_MEMBER.MEMBER_STATUS_CODE, MB_MEMBER_RETIRE.APPROVE_DATE
FROM            MB_MEMBER INNER JOIN
                         MB_COMP_PERSON ON MB_MEMBER.COMP_PERSON_CODE = MB_COMP_PERSON.COMP_PERSON_CODE INNER JOIN
                         MB_MEMBER_RETIRE ON MB_MEMBER.REGIST_CODE = MB_MEMBER_RETIRE.REGIST_CODE LEFT OUTER JOIN
                         MB_PRENAME ON MB_COMP_PERSON.PREN_CODE = MB_PRENAME.PRENAME_CODE
WHERE        (MB_MEMBER.MEMBER_MAIN_GROUP_CODE = '300') AND (MB_MEMBER_RETIRE.APPROVE_DATE BETWEEN dbo.fnc_StrToDateTime(@YYYYMMDD_FROM + '000000') AND dbo.fnc_StrToDateTime(@YYYYMMDD_TO + '235959'))
ORDER BY MB_MEMBER_RETIRE.APPROVE_DATE*/

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

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

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

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

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

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

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

	insert into tempWsGs1_002
	select * from fnc_GetGS1MemberInfoForWebServiceByTaxID(@TAX_ID)

    set @currentRow = @currentRow +1
end  

drop table tempWsGs1_001
select * from tempWsGs1_002
drop table tempWsGs1_002
3:00:24 29 มีนาคม 2561  :There is already an object named 'tempWsGs1_001' in the database.
4:00:24 29 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
4:00:24 29 มีนาคม 2561  :try to logon with: GS1WS
4:00:24 29 มีนาคม 2561  :getGS1changed=/*SELECT        MB_MEMBER.MEMBER_CODE, MB_PRENAME.PRENAME_TH, MB_COMP_PERSON.COMP_PERSON_NAME_TH, MB_PRENAME.PRENAME_EN, MB_COMP_PERSON.COMP_PERSON_NAME_EN, 
                         MB_COMP_PERSON.TAX_ID, MB_MEMBER.REGIST_DATE, MB_MEMBER.MEMBER_MAIN_TYPE_CODE, MB_MEMBER.MEMBER_TYPE_CODE, MB_MEMBER.MEMBER_STATUS_CODE, MB_MEMBER_RETIRE.APPROVE_DATE
FROM            MB_MEMBER INNER JOIN
                         MB_COMP_PERSON ON MB_MEMBER.COMP_PERSON_CODE = MB_COMP_PERSON.COMP_PERSON_CODE INNER JOIN
                         MB_MEMBER_RETIRE ON MB_MEMBER.REGIST_CODE = MB_MEMBER_RETIRE.REGIST_CODE LEFT OUTER JOIN
                         MB_PRENAME ON MB_COMP_PERSON.PREN_CODE = MB_PRENAME.PRENAME_CODE
WHERE        (MB_MEMBER.MEMBER_MAIN_GROUP_CODE = '300') AND (MB_MEMBER_RETIRE.APPROVE_DATE BETWEEN dbo.fnc_StrToDateTime(@YYYYMMDD_FROM + '000000') AND dbo.fnc_StrToDateTime(@YYYYMMDD_TO + '235959'))
ORDER BY MB_MEMBER_RETIRE.APPROVE_DATE*/

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

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

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

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

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

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

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

	insert into tempWsGs1_002
	select * from fnc_GetGS1MemberInfoForWebServiceByTaxID(@TAX_ID)

    set @currentRow = @currentRow +1
end  

drop table tempWsGs1_001
select * from tempWsGs1_002
drop table tempWsGs1_002
4:00:24 29 มีนาคม 2561  :There is already an object named 'tempWsGs1_001' in the database.
5:00:25 29 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
5:00:25 29 มีนาคม 2561  :try to logon with: GS1WS
5:00:25 29 มีนาคม 2561  :getGS1changed=/*SELECT        MB_MEMBER.MEMBER_CODE, MB_PRENAME.PRENAME_TH, MB_COMP_PERSON.COMP_PERSON_NAME_TH, MB_PRENAME.PRENAME_EN, MB_COMP_PERSON.COMP_PERSON_NAME_EN, 
                         MB_COMP_PERSON.TAX_ID, MB_MEMBER.REGIST_DATE, MB_MEMBER.MEMBER_MAIN_TYPE_CODE, MB_MEMBER.MEMBER_TYPE_CODE, MB_MEMBER.MEMBER_STATUS_CODE, MB_MEMBER_RETIRE.APPROVE_DATE
FROM            MB_MEMBER INNER JOIN
                         MB_COMP_PERSON ON MB_MEMBER.COMP_PERSON_CODE = MB_COMP_PERSON.COMP_PERSON_CODE INNER JOIN
                         MB_MEMBER_RETIRE ON MB_MEMBER.REGIST_CODE = MB_MEMBER_RETIRE.REGIST_CODE LEFT OUTER JOIN
                         MB_PRENAME ON MB_COMP_PERSON.PREN_CODE = MB_PRENAME.PRENAME_CODE
WHERE        (MB_MEMBER.MEMBER_MAIN_GROUP_CODE = '300') AND (MB_MEMBER_RETIRE.APPROVE_DATE BETWEEN dbo.fnc_StrToDateTime(@YYYYMMDD_FROM + '000000') AND dbo.fnc_StrToDateTime(@YYYYMMDD_TO + '235959'))
ORDER BY MB_MEMBER_RETIRE.APPROVE_DATE*/

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

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

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

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

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

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

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

	insert into tempWsGs1_002
	select * from fnc_GetGS1MemberInfoForWebServiceByTaxID(@TAX_ID)

    set @currentRow = @currentRow +1
end  

drop table tempWsGs1_001
select * from tempWsGs1_002
drop table tempWsGs1_002
5:00:25 29 มีนาคม 2561  :There is already an object named 'tempWsGs1_001' in the database.
6:00:24 29 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
6:00:24 29 มีนาคม 2561  :try to logon with: GS1WS
6:00:24 29 มีนาคม 2561  :getGS1changed=/*SELECT        MB_MEMBER.MEMBER_CODE, MB_PRENAME.PRENAME_TH, MB_COMP_PERSON.COMP_PERSON_NAME_TH, MB_PRENAME.PRENAME_EN, MB_COMP_PERSON.COMP_PERSON_NAME_EN, 
                         MB_COMP_PERSON.TAX_ID, MB_MEMBER.REGIST_DATE, MB_MEMBER.MEMBER_MAIN_TYPE_CODE, MB_MEMBER.MEMBER_TYPE_CODE, MB_MEMBER.MEMBER_STATUS_CODE, MB_MEMBER_RETIRE.APPROVE_DATE
FROM            MB_MEMBER INNER JOIN
                         MB_COMP_PERSON ON MB_MEMBER.COMP_PERSON_CODE = MB_COMP_PERSON.COMP_PERSON_CODE INNER JOIN
                         MB_MEMBER_RETIRE ON MB_MEMBER.REGIST_CODE = MB_MEMBER_RETIRE.REGIST_CODE LEFT OUTER JOIN
                         MB_PRENAME ON MB_COMP_PERSON.PREN_CODE = MB_PRENAME.PRENAME_CODE
WHERE        (MB_MEMBER.MEMBER_MAIN_GROUP_CODE = '300') AND (MB_MEMBER_RETIRE.APPROVE_DATE BETWEEN dbo.fnc_StrToDateTime(@YYYYMMDD_FROM + '000000') AND dbo.fnc_StrToDateTime(@YYYYMMDD_TO + '235959'))
ORDER BY MB_MEMBER_RETIRE.APPROVE_DATE*/

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

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

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

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

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

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

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

	insert into tempWsGs1_002
	select * from fnc_GetGS1MemberInfoForWebServiceByTaxID(@TAX_ID)

    set @currentRow = @currentRow +1
end  

drop table tempWsGs1_001
select * from tempWsGs1_002
drop table tempWsGs1_002
6:00:24 29 มีนาคม 2561  :There is already an object named 'tempWsGs1_001' in the database.
7:00:27 29 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
7:00:27 29 มีนาคม 2561  :try to logon with: GS1WS
7:00:27 29 มีนาคม 2561  :getGS1changed=/*SELECT        MB_MEMBER.MEMBER_CODE, MB_PRENAME.PRENAME_TH, MB_COMP_PERSON.COMP_PERSON_NAME_TH, MB_PRENAME.PRENAME_EN, MB_COMP_PERSON.COMP_PERSON_NAME_EN, 
                         MB_COMP_PERSON.TAX_ID, MB_MEMBER.REGIST_DATE, MB_MEMBER.MEMBER_MAIN_TYPE_CODE, MB_MEMBER.MEMBER_TYPE_CODE, MB_MEMBER.MEMBER_STATUS_CODE, MB_MEMBER_RETIRE.APPROVE_DATE
FROM            MB_MEMBER INNER JOIN
                         MB_COMP_PERSON ON MB_MEMBER.COMP_PERSON_CODE = MB_COMP_PERSON.COMP_PERSON_CODE INNER JOIN
                         MB_MEMBER_RETIRE ON MB_MEMBER.REGIST_CODE = MB_MEMBER_RETIRE.REGIST_CODE LEFT OUTER JOIN
                         MB_PRENAME ON MB_COMP_PERSON.PREN_CODE = MB_PRENAME.PRENAME_CODE
WHERE        (MB_MEMBER.MEMBER_MAIN_GROUP_CODE = '300') AND (MB_MEMBER_RETIRE.APPROVE_DATE BETWEEN dbo.fnc_StrToDateTime(@YYYYMMDD_FROM + '000000') AND dbo.fnc_StrToDateTime(@YYYYMMDD_TO + '235959'))
ORDER BY MB_MEMBER_RETIRE.APPROVE_DATE*/

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

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

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

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

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

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

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

	insert into tempWsGs1_002
	select * from fnc_GetGS1MemberInfoForWebServiceByTaxID(@TAX_ID)

    set @currentRow = @currentRow +1
end  

drop table tempWsGs1_001
select * from tempWsGs1_002
drop table tempWsGs1_002
7:00:27 29 มีนาคม 2561  :There is already an object named 'tempWsGs1_001' in the database.
8:00:25 29 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
8:00:25 29 มีนาคม 2561  :try to logon with: GS1WS
8:00:25 29 มีนาคม 2561  :getGS1changed=/*SELECT        MB_MEMBER.MEMBER_CODE, MB_PRENAME.PRENAME_TH, MB_COMP_PERSON.COMP_PERSON_NAME_TH, MB_PRENAME.PRENAME_EN, MB_COMP_PERSON.COMP_PERSON_NAME_EN, 
                         MB_COMP_PERSON.TAX_ID, MB_MEMBER.REGIST_DATE, MB_MEMBER.MEMBER_MAIN_TYPE_CODE, MB_MEMBER.MEMBER_TYPE_CODE, MB_MEMBER.MEMBER_STATUS_CODE, MB_MEMBER_RETIRE.APPROVE_DATE
FROM            MB_MEMBER INNER JOIN
                         MB_COMP_PERSON ON MB_MEMBER.COMP_PERSON_CODE = MB_COMP_PERSON.COMP_PERSON_CODE INNER JOIN
                         MB_MEMBER_RETIRE ON MB_MEMBER.REGIST_CODE = MB_MEMBER_RETIRE.REGIST_CODE LEFT OUTER JOIN
                         MB_PRENAME ON MB_COMP_PERSON.PREN_CODE = MB_PRENAME.PRENAME_CODE
WHERE        (MB_MEMBER.MEMBER_MAIN_GROUP_CODE = '300') AND (MB_MEMBER_RETIRE.APPROVE_DATE BETWEEN dbo.fnc_StrToDateTime(@YYYYMMDD_FROM + '000000') AND dbo.fnc_StrToDateTime(@YYYYMMDD_TO + '235959'))
ORDER BY MB_MEMBER_RETIRE.APPROVE_DATE*/

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

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

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

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

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

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

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

	insert into tempWsGs1_002
	select * from fnc_GetGS1MemberInfoForWebServiceByTaxID(@TAX_ID)

    set @currentRow = @currentRow +1
end  

drop table tempWsGs1_001
select * from tempWsGs1_002
drop table tempWsGs1_002
8:00:25 29 มีนาคม 2561  :There is already an object named 'tempWsGs1_001' in the database.
8:35:17 29 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
8:35:17 29 มีนาคม 2561  :try to logon with: GS1WS
9:00:25 29 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
9:00:25 29 มีนาคม 2561  :try to logon with: GS1WS
9:00:25 29 มีนาคม 2561  :getGS1changed=/*SELECT        MB_MEMBER.MEMBER_CODE, MB_PRENAME.PRENAME_TH, MB_COMP_PERSON.COMP_PERSON_NAME_TH, MB_PRENAME.PRENAME_EN, MB_COMP_PERSON.COMP_PERSON_NAME_EN, 
                         MB_COMP_PERSON.TAX_ID, MB_MEMBER.REGIST_DATE, MB_MEMBER.MEMBER_MAIN_TYPE_CODE, MB_MEMBER.MEMBER_TYPE_CODE, MB_MEMBER.MEMBER_STATUS_CODE, MB_MEMBER_RETIRE.APPROVE_DATE
FROM            MB_MEMBER INNER JOIN
                         MB_COMP_PERSON ON MB_MEMBER.COMP_PERSON_CODE = MB_COMP_PERSON.COMP_PERSON_CODE INNER JOIN
                         MB_MEMBER_RETIRE ON MB_MEMBER.REGIST_CODE = MB_MEMBER_RETIRE.REGIST_CODE LEFT OUTER JOIN
                         MB_PRENAME ON MB_COMP_PERSON.PREN_CODE = MB_PRENAME.PRENAME_CODE
WHERE        (MB_MEMBER.MEMBER_MAIN_GROUP_CODE = '300') AND (MB_MEMBER_RETIRE.APPROVE_DATE BETWEEN dbo.fnc_StrToDateTime(@YYYYMMDD_FROM + '000000') AND dbo.fnc_StrToDateTime(@YYYYMMDD_TO + '235959'))
ORDER BY MB_MEMBER_RETIRE.APPROVE_DATE*/

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

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

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

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

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

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

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

	insert into tempWsGs1_002
	select * from fnc_GetGS1MemberInfoForWebServiceByTaxID(@TAX_ID)

    set @currentRow = @currentRow +1
end  

drop table tempWsGs1_001
select * from tempWsGs1_002
drop table tempWsGs1_002
9:00:25 29 มีนาคม 2561  :There is already an object named 'tempWsGs1_001' in the database.
10:00:28 29 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
10:00:28 29 มีนาคม 2561  :try to logon with: GS1WS
10:00:28 29 มีนาคม 2561  :getGS1changed=/*SELECT        MB_MEMBER.MEMBER_CODE, MB_PRENAME.PRENAME_TH, MB_COMP_PERSON.COMP_PERSON_NAME_TH, MB_PRENAME.PRENAME_EN, MB_COMP_PERSON.COMP_PERSON_NAME_EN, 
                         MB_COMP_PERSON.TAX_ID, MB_MEMBER.REGIST_DATE, MB_MEMBER.MEMBER_MAIN_TYPE_CODE, MB_MEMBER.MEMBER_TYPE_CODE, MB_MEMBER.MEMBER_STATUS_CODE, MB_MEMBER_RETIRE.APPROVE_DATE
FROM            MB_MEMBER INNER JOIN
                         MB_COMP_PERSON ON MB_MEMBER.COMP_PERSON_CODE = MB_COMP_PERSON.COMP_PERSON_CODE INNER JOIN
                         MB_MEMBER_RETIRE ON MB_MEMBER.REGIST_CODE = MB_MEMBER_RETIRE.REGIST_CODE LEFT OUTER JOIN
                         MB_PRENAME ON MB_COMP_PERSON.PREN_CODE = MB_PRENAME.PRENAME_CODE
WHERE        (MB_MEMBER.MEMBER_MAIN_GROUP_CODE = '300') AND (MB_MEMBER_RETIRE.APPROVE_DATE BETWEEN dbo.fnc_StrToDateTime(@YYYYMMDD_FROM + '000000') AND dbo.fnc_StrToDateTime(@YYYYMMDD_TO + '235959'))
ORDER BY MB_MEMBER_RETIRE.APPROVE_DATE*/

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

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

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

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

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

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

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

	insert into tempWsGs1_002
	select * from fnc_GetGS1MemberInfoForWebServiceByTaxID(@TAX_ID)

    set @currentRow = @currentRow +1
end  

drop table tempWsGs1_001
select * from tempWsGs1_002
drop table tempWsGs1_002
10:00:28 29 มีนาคม 2561  :There is already an object named 'tempWsGs1_001' in the database.
10:07:47 29 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
10:07:47 29 มีนาคม 2561  :try to logon with: GS1WS
10:09:41 29 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
10:09:41 29 มีนาคม 2561  :try to logon with: GS1WS
10:10:35 29 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
10:10:35 29 มีนาคม 2561  :try to logon with: GS1WS
10:13:06 29 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
10:13:06 29 มีนาคม 2561  :try to logon with: GS1WS
10:34:29 29 มีนาคม 2561  :There was no endpoint listening at https://rdws.rd.go.th/serviceRD3/vatserviceRD3.asmx that could accept the message. This is often caused by an incorrect address or SOAP action. See InnerException, if present, for more details.
10:43:33 29 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
10:43:33 29 มีนาคม 2561  :try to logon with: GS1WS
10:45:26 29 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
10:45:26 29 มีนาคม 2561  :try to logon with: GS1WS
10:45:55 29 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
10:45:55 29 มีนาคม 2561  :try to logon with: GS1WS
10:59:35 29 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
10:59:35 29 มีนาคม 2561  :try to logon with: GS1WS
11:00:26 29 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
11:00:26 29 มีนาคม 2561  :try to logon with: GS1WS
11:00:26 29 มีนาคม 2561  :getGS1changed=/*SELECT        MB_MEMBER.MEMBER_CODE, MB_PRENAME.PRENAME_TH, MB_COMP_PERSON.COMP_PERSON_NAME_TH, MB_PRENAME.PRENAME_EN, MB_COMP_PERSON.COMP_PERSON_NAME_EN, 
                         MB_COMP_PERSON.TAX_ID, MB_MEMBER.REGIST_DATE, MB_MEMBER.MEMBER_MAIN_TYPE_CODE, MB_MEMBER.MEMBER_TYPE_CODE, MB_MEMBER.MEMBER_STATUS_CODE, MB_MEMBER_RETIRE.APPROVE_DATE
FROM            MB_MEMBER INNER JOIN
                         MB_COMP_PERSON ON MB_MEMBER.COMP_PERSON_CODE = MB_COMP_PERSON.COMP_PERSON_CODE INNER JOIN
                         MB_MEMBER_RETIRE ON MB_MEMBER.REGIST_CODE = MB_MEMBER_RETIRE.REGIST_CODE LEFT OUTER JOIN
                         MB_PRENAME ON MB_COMP_PERSON.PREN_CODE = MB_PRENAME.PRENAME_CODE
WHERE        (MB_MEMBER.MEMBER_MAIN_GROUP_CODE = '300') AND (MB_MEMBER_RETIRE.APPROVE_DATE BETWEEN dbo.fnc_StrToDateTime(@YYYYMMDD_FROM + '000000') AND dbo.fnc_StrToDateTime(@YYYYMMDD_TO + '235959'))
ORDER BY MB_MEMBER_RETIRE.APPROVE_DATE*/

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

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

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

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

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

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

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

	insert into tempWsGs1_002
	select * from fnc_GetGS1MemberInfoForWebServiceByTaxID(@TAX_ID)

    set @currentRow = @currentRow +1
end  

drop table tempWsGs1_001
select * from tempWsGs1_002
drop table tempWsGs1_002
11:00:26 29 มีนาคม 2561  :There is already an object named 'tempWsGs1_001' in the database.
11:00:26 29 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
11:00:26 29 มีนาคม 2561  :try to logon with: GS1WS
11:00:26 29 มีนาคม 2561  :getGS1changed=/*SELECT        MB_MEMBER.MEMBER_CODE, MB_PRENAME.PRENAME_TH, MB_COMP_PERSON.COMP_PERSON_NAME_TH, MB_PRENAME.PRENAME_EN, MB_COMP_PERSON.COMP_PERSON_NAME_EN, 
                         MB_COMP_PERSON.TAX_ID, MB_MEMBER.REGIST_DATE, MB_MEMBER.MEMBER_MAIN_TYPE_CODE, MB_MEMBER.MEMBER_TYPE_CODE, MB_MEMBER.MEMBER_STATUS_CODE, MB_MEMBER_RETIRE.APPROVE_DATE
FROM            MB_MEMBER INNER JOIN
                         MB_COMP_PERSON ON MB_MEMBER.COMP_PERSON_CODE = MB_COMP_PERSON.COMP_PERSON_CODE INNER JOIN
                         MB_MEMBER_RETIRE ON MB_MEMBER.REGIST_CODE = MB_MEMBER_RETIRE.REGIST_CODE LEFT OUTER JOIN
                         MB_PRENAME ON MB_COMP_PERSON.PREN_CODE = MB_PRENAME.PRENAME_CODE
WHERE        (MB_MEMBER.MEMBER_MAIN_GROUP_CODE = '300') AND (MB_MEMBER_RETIRE.APPROVE_DATE BETWEEN dbo.fnc_StrToDateTime(@YYYYMMDD_FROM + '000000') AND dbo.fnc_StrToDateTime(@YYYYMMDD_TO + '235959'))
ORDER BY MB_MEMBER_RETIRE.APPROVE_DATE*/

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

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

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

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

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

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

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

	insert into tempWsGs1_002
	select * from fnc_GetGS1MemberInfoForWebServiceByTaxID(@TAX_ID)

    set @currentRow = @currentRow +1
end  

drop table tempWsGs1_001
select * from tempWsGs1_002
drop table tempWsGs1_002
11:00:26 29 มีนาคม 2561  :There is already an object named 'tempWsGs1_001' in the database.
11:02:14 29 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
11:02:14 29 มีนาคม 2561  :try to logon with: GS1WS
11:15:33 29 มีนาคม 2561  :Server was unable to process request. ---> Cannot open database "RDtmp" requested by the login. The login failed.
11:25:39 29 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
11:25:39 29 มีนาคม 2561  :try to logon with: GS1WS
11:30:49 29 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
11:30:49 29 มีนาคม 2561  :try to logon with: GS1WS
11:37:59 29 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
11:37:59 29 มีนาคม 2561  :try to logon with: GS1WS
11:45:43 29 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
11:45:43 29 มีนาคม 2561  :try to logon with: GS1WS
12:00:24 29 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
12:00:24 29 มีนาคม 2561  :try to logon with: GS1WS
12:00:24 29 มีนาคม 2561  :getGS1changed=/*SELECT        MB_MEMBER.MEMBER_CODE, MB_PRENAME.PRENAME_TH, MB_COMP_PERSON.COMP_PERSON_NAME_TH, MB_PRENAME.PRENAME_EN, MB_COMP_PERSON.COMP_PERSON_NAME_EN, 
                         MB_COMP_PERSON.TAX_ID, MB_MEMBER.REGIST_DATE, MB_MEMBER.MEMBER_MAIN_TYPE_CODE, MB_MEMBER.MEMBER_TYPE_CODE, MB_MEMBER.MEMBER_STATUS_CODE, MB_MEMBER_RETIRE.APPROVE_DATE
FROM            MB_MEMBER INNER JOIN
                         MB_COMP_PERSON ON MB_MEMBER.COMP_PERSON_CODE = MB_COMP_PERSON.COMP_PERSON_CODE INNER JOIN
                         MB_MEMBER_RETIRE ON MB_MEMBER.REGIST_CODE = MB_MEMBER_RETIRE.REGIST_CODE LEFT OUTER JOIN
                         MB_PRENAME ON MB_COMP_PERSON.PREN_CODE = MB_PRENAME.PRENAME_CODE
WHERE        (MB_MEMBER.MEMBER_MAIN_GROUP_CODE = '300') AND (MB_MEMBER_RETIRE.APPROVE_DATE BETWEEN dbo.fnc_StrToDateTime(@YYYYMMDD_FROM + '000000') AND dbo.fnc_StrToDateTime(@YYYYMMDD_TO + '235959'))
ORDER BY MB_MEMBER_RETIRE.APPROVE_DATE*/

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

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

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

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

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

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

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

	insert into tempWsGs1_002
	select * from fnc_GetGS1MemberInfoForWebServiceByTaxID(@TAX_ID)

    set @currentRow = @currentRow +1
end  

drop table tempWsGs1_001
select * from tempWsGs1_002
drop table tempWsGs1_002
12:00:24 29 มีนาคม 2561  :There is already an object named 'tempWsGs1_001' in the database.
12:05:21 29 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
12:05:21 29 มีนาคม 2561  :try to logon with: GS1WS
12:07:03 29 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
12:07:03 29 มีนาคม 2561  :try to logon with: GS1WS
12:26:00 29 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
12:26:00 29 มีนาคม 2561  :try to logon with: GS1WS
12:26:09 29 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
12:26:09 29 มีนาคม 2561  :try to logon with: GS1WS
12:55:32 29 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
12:55:32 29 มีนาคม 2561  :try to logon with: GS1WS
13:00:39 29 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
13:00:39 29 มีนาคม 2561  :try to logon with: GS1WS
13:00:39 29 มีนาคม 2561  :getGS1changed=/*SELECT        MB_MEMBER.MEMBER_CODE, MB_PRENAME.PRENAME_TH, MB_COMP_PERSON.COMP_PERSON_NAME_TH, MB_PRENAME.PRENAME_EN, MB_COMP_PERSON.COMP_PERSON_NAME_EN, 
                         MB_COMP_PERSON.TAX_ID, MB_MEMBER.REGIST_DATE, MB_MEMBER.MEMBER_MAIN_TYPE_CODE, MB_MEMBER.MEMBER_TYPE_CODE, MB_MEMBER.MEMBER_STATUS_CODE, MB_MEMBER_RETIRE.APPROVE_DATE
FROM            MB_MEMBER INNER JOIN
                         MB_COMP_PERSON ON MB_MEMBER.COMP_PERSON_CODE = MB_COMP_PERSON.COMP_PERSON_CODE INNER JOIN
                         MB_MEMBER_RETIRE ON MB_MEMBER.REGIST_CODE = MB_MEMBER_RETIRE.REGIST_CODE LEFT OUTER JOIN
                         MB_PRENAME ON MB_COMP_PERSON.PREN_CODE = MB_PRENAME.PRENAME_CODE
WHERE        (MB_MEMBER.MEMBER_MAIN_GROUP_CODE = '300') AND (MB_MEMBER_RETIRE.APPROVE_DATE BETWEEN dbo.fnc_StrToDateTime(@YYYYMMDD_FROM + '000000') AND dbo.fnc_StrToDateTime(@YYYYMMDD_TO + '235959'))
ORDER BY MB_MEMBER_RETIRE.APPROVE_DATE*/

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

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

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

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

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

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

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

	insert into tempWsGs1_002
	select * from fnc_GetGS1MemberInfoForWebServiceByTaxID(@TAX_ID)

    set @currentRow = @currentRow +1
end  

drop table tempWsGs1_001
select * from tempWsGs1_002
drop table tempWsGs1_002
13:00:39 29 มีนาคม 2561  :There is already an object named 'tempWsGs1_001' in the database.
13:22:37 29 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
13:22:37 29 มีนาคม 2561  :try to logon with: GS1WS
13:51:33 29 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
13:51:33 29 มีนาคม 2561  :try to logon with: GS1WS
13:53:59 29 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
13:53:59 29 มีนาคม 2561  :try to logon with: GS1WS
14:00:24 29 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
14:00:24 29 มีนาคม 2561  :try to logon with: GS1WS
14:00:24 29 มีนาคม 2561  :getGS1changed=/*SELECT        MB_MEMBER.MEMBER_CODE, MB_PRENAME.PRENAME_TH, MB_COMP_PERSON.COMP_PERSON_NAME_TH, MB_PRENAME.PRENAME_EN, MB_COMP_PERSON.COMP_PERSON_NAME_EN, 
                         MB_COMP_PERSON.TAX_ID, MB_MEMBER.REGIST_DATE, MB_MEMBER.MEMBER_MAIN_TYPE_CODE, MB_MEMBER.MEMBER_TYPE_CODE, MB_MEMBER.MEMBER_STATUS_CODE, MB_MEMBER_RETIRE.APPROVE_DATE
FROM            MB_MEMBER INNER JOIN
                         MB_COMP_PERSON ON MB_MEMBER.COMP_PERSON_CODE = MB_COMP_PERSON.COMP_PERSON_CODE INNER JOIN
                         MB_MEMBER_RETIRE ON MB_MEMBER.REGIST_CODE = MB_MEMBER_RETIRE.REGIST_CODE LEFT OUTER JOIN
                         MB_PRENAME ON MB_COMP_PERSON.PREN_CODE = MB_PRENAME.PRENAME_CODE
WHERE        (MB_MEMBER.MEMBER_MAIN_GROUP_CODE = '300') AND (MB_MEMBER_RETIRE.APPROVE_DATE BETWEEN dbo.fnc_StrToDateTime(@YYYYMMDD_FROM + '000000') AND dbo.fnc_StrToDateTime(@YYYYMMDD_TO + '235959'))
ORDER BY MB_MEMBER_RETIRE.APPROVE_DATE*/

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

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

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

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

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

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

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

	insert into tempWsGs1_002
	select * from fnc_GetGS1MemberInfoForWebServiceByTaxID(@TAX_ID)

    set @currentRow = @currentRow +1
end  

drop table tempWsGs1_001
select * from tempWsGs1_002
drop table tempWsGs1_002
14:00:24 29 มีนาคม 2561  :There is already an object named 'tempWsGs1_001' in the database.
14:03:03 29 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
14:03:03 29 มีนาคม 2561  :try to logon with: GS1WS
14:13:16 29 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
14:13:16 29 มีนาคม 2561  :try to logon with: GS1WS
14:15:00 29 มีนาคม 2561  :There was no endpoint listening at https://rdws.rd.go.th/serviceRD3/vatserviceRD3.asmx that could accept the message. This is often caused by an incorrect address or SOAP action. See InnerException, if present, for more details.
14:33:02 29 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
14:33:02 29 มีนาคม 2561  :try to logon with: GS1WS
14:46:16 29 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
14:46:16 29 มีนาคม 2561  :try to logon with: GS1WS
14:53:50 29 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
14:53:50 29 มีนาคม 2561  :try to logon with: GS1WS
14:54:42 29 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
14:54:42 29 มีนาคม 2561  :try to logon with: GS1WS
14:56:34 29 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
14:56:34 29 มีนาคม 2561  :try to logon with: GS1WS
15:00:24 29 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
15:00:24 29 มีนาคม 2561  :try to logon with: GS1WS
15:00:24 29 มีนาคม 2561  :getGS1changed=/*SELECT        MB_MEMBER.MEMBER_CODE, MB_PRENAME.PRENAME_TH, MB_COMP_PERSON.COMP_PERSON_NAME_TH, MB_PRENAME.PRENAME_EN, MB_COMP_PERSON.COMP_PERSON_NAME_EN, 
                         MB_COMP_PERSON.TAX_ID, MB_MEMBER.REGIST_DATE, MB_MEMBER.MEMBER_MAIN_TYPE_CODE, MB_MEMBER.MEMBER_TYPE_CODE, MB_MEMBER.MEMBER_STATUS_CODE, MB_MEMBER_RETIRE.APPROVE_DATE
FROM            MB_MEMBER INNER JOIN
                         MB_COMP_PERSON ON MB_MEMBER.COMP_PERSON_CODE = MB_COMP_PERSON.COMP_PERSON_CODE INNER JOIN
                         MB_MEMBER_RETIRE ON MB_MEMBER.REGIST_CODE = MB_MEMBER_RETIRE.REGIST_CODE LEFT OUTER JOIN
                         MB_PRENAME ON MB_COMP_PERSON.PREN_CODE = MB_PRENAME.PRENAME_CODE
WHERE        (MB_MEMBER.MEMBER_MAIN_GROUP_CODE = '300') AND (MB_MEMBER_RETIRE.APPROVE_DATE BETWEEN dbo.fnc_StrToDateTime(@YYYYMMDD_FROM + '000000') AND dbo.fnc_StrToDateTime(@YYYYMMDD_TO + '235959'))
ORDER BY MB_MEMBER_RETIRE.APPROVE_DATE*/

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

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

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

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

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

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

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

	insert into tempWsGs1_002
	select * from fnc_GetGS1MemberInfoForWebServiceByTaxID(@TAX_ID)

    set @currentRow = @currentRow +1
end  

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

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

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

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

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

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

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

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

	insert into tempWsGs1_002
	select * from fnc_GetGS1MemberInfoForWebServiceByTaxID(@TAX_ID)

    set @currentRow = @currentRow +1
end  

drop table tempWsGs1_001
select * from tempWsGs1_002
drop table tempWsGs1_002
16:00:24 29 มีนาคม 2561  :There is already an object named 'tempWsGs1_001' in the database.
16:00:24 29 มีนาคม 2561  :getGS1changed=/*SELECT        MB_MEMBER.MEMBER_CODE, MB_PRENAME.PRENAME_TH, MB_COMP_PERSON.COMP_PERSON_NAME_TH, MB_PRENAME.PRENAME_EN, MB_COMP_PERSON.COMP_PERSON_NAME_EN, 
                         MB_COMP_PERSON.TAX_ID, MB_MEMBER.REGIST_DATE, MB_MEMBER.MEMBER_MAIN_TYPE_CODE, MB_MEMBER.MEMBER_TYPE_CODE, MB_MEMBER.MEMBER_STATUS_CODE, MB_MEMBER_RETIRE.APPROVE_DATE
FROM            MB_MEMBER INNER JOIN
                         MB_COMP_PERSON ON MB_MEMBER.COMP_PERSON_CODE = MB_COMP_PERSON.COMP_PERSON_CODE INNER JOIN
                         MB_MEMBER_RETIRE ON MB_MEMBER.REGIST_CODE = MB_MEMBER_RETIRE.REGIST_CODE LEFT OUTER JOIN
                         MB_PRENAME ON MB_COMP_PERSON.PREN_CODE = MB_PRENAME.PRENAME_CODE
WHERE        (MB_MEMBER.MEMBER_MAIN_GROUP_CODE = '300') AND (MB_MEMBER_RETIRE.APPROVE_DATE BETWEEN dbo.fnc_StrToDateTime(@YYYYMMDD_FROM + '000000') AND dbo.fnc_StrToDateTime(@YYYYMMDD_TO + '235959'))
ORDER BY MB_MEMBER_RETIRE.APPROVE_DATE*/

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

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

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

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

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

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

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

	insert into tempWsGs1_002
	select * from fnc_GetGS1MemberInfoForWebServiceByTaxID(@TAX_ID)

    set @currentRow = @currentRow +1
end  

drop table tempWsGs1_001
select * from tempWsGs1_002
drop table tempWsGs1_002
16:00:24 29 มีนาคม 2561  :There is already an object named 'tempWsGs1_001' in the database.
16:00:26 29 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
16:00:26 29 มีนาคม 2561  :try to logon with: GS1WS
16:01:06 29 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
16:01:06 29 มีนาคม 2561  :try to logon with: GS1WS
16:01:38 29 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
16:01:38 29 มีนาคม 2561  :try to logon with: GS1WS
16:01:44 29 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
16:01:44 29 มีนาคม 2561  :try to logon with: GS1WS
16:02:02 29 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
16:02:02 29 มีนาคม 2561  :try to logon with: GS1WS
16:02:45 29 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
16:02:45 29 มีนาคม 2561  :try to logon with: GS1WS
16:02:55 29 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
16:02:55 29 มีนาคม 2561  :try to logon with: GS1WS
16:03:16 29 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
16:03:16 29 มีนาคม 2561  :try to logon with: GS1WS
16:03:27 29 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
16:03:27 29 มีนาคม 2561  :try to logon with: GS1WS
16:04:11 29 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
16:04:11 29 มีนาคม 2561  :try to logon with: GS1WS
16:04:41 29 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
16:04:41 29 มีนาคม 2561  :try to logon with: GS1WS
16:05:53 29 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
16:05:53 29 มีนาคม 2561  :try to logon with: GS1WS
16:06:09 29 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
16:06:09 29 มีนาคม 2561  :try to logon with: GS1WS
16:06:22 29 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
16:06:22 29 มีนาคม 2561  :try to logon with: GS1WS
16:08:45 29 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
16:08:45 29 มีนาคม 2561  :try to logon with: GS1WS
16:10:08 29 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
16:10:08 29 มีนาคม 2561  :try to logon with: GS1WS
16:10:56 29 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
16:10:56 29 มีนาคม 2561  :try to logon with: GS1WS
16:11:27 29 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
16:11:27 29 มีนาคม 2561  :try to logon with: GS1WS
16:11:53 29 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
16:11:53 29 มีนาคม 2561  :try to logon with: GS1WS
16:12:07 29 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
16:12:07 29 มีนาคม 2561  :try to logon with: GS1WS
16:12:08 29 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
16:12:08 29 มีนาคม 2561  :try to logon with: GS1WS
16:12:33 29 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
16:12:33 29 มีนาคม 2561  :try to logon with: GS1WS
16:16:15 29 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
16:16:15 29 มีนาคม 2561  :try to logon with: GS1WS
16:19:43 29 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
16:19:43 29 มีนาคม 2561  :try to logon with: GS1WS
16:21:44 29 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
16:21:44 29 มีนาคม 2561  :try to logon with: GS1WS
16:21:44 29 มีนาคม 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:21:44 29 มีนาคม 2561  :There is already an object named 'tempWsGs1_001' in the database.
16:21:52 29 มีนาคม 2561  :The user name or password is incorrect.

16:21:52 29 มีนาคม 2561  :try to logon with: GS1WS
16:22:11 29 มีนาคม 2561  :An operations error occurred.

16:22:11 29 มีนาคม 2561  :try to logon with: 
16:22:32 29 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
16:22:32 29 มีนาคม 2561  :try to logon with: GS1WS
16:22:32 29 มีนาคม 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:22:32 29 มีนาคม 2561  :There is already an object named 'tempWsGs1_001' in the database.
16:22:51 29 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
16:22:51 29 มีนาคม 2561  :try to logon with: GS1WS
16:22:54 29 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
16:22:54 29 มีนาคม 2561  :try to logon with: GS1WS
16:22:54 29 มีนาคม 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:22:54 29 มีนาคม 2561  :There is already an object named 'tempWsGs1_001' in the database.
16:23:10 29 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
16:23:10 29 มีนาคม 2561  :try to logon with: GS1WS
16:24:26 29 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
16:24:26 29 มีนาคม 2561  :try to logon with: GS1WS
16:25:02 29 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
16:25:02 29 มีนาคม 2561  :try to logon with: GS1WS
16:25:35 29 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
16:25:35 29 มีนาคม 2561  :try to logon with: GS1WS
16:31:39 29 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
16:31:39 29 มีนาคม 2561  :try to logon with: GS1WS
16:39:30 29 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
16:39:30 29 มีนาคม 2561  :try to logon with: GS1WS
16:39:56 29 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
16:39:56 29 มีนาคม 2561  :try to logon with: GS1WS
16:40:27 29 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
16:40:27 29 มีนาคม 2561  :try to logon with: GS1WS
16:41:27 29 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
16:41:27 29 มีนาคม 2561  :try to logon with: GS1WS
16:41:49 29 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
16:41:49 29 มีนาคม 2561  :try to logon with: GS1WS
16:42:15 29 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
16:42:15 29 มีนาคม 2561  :try to logon with: GS1WS
16:46:38 29 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
16:46:38 29 มีนาคม 2561  :try to logon with: GS1WS
16:46:45 29 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
16:46:45 29 มีนาคม 2561  :try to logon with: GS1WS
16:48:13 29 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
16:48:13 29 มีนาคม 2561  :try to logon with: GS1WS
16:48:45 29 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
16:48:45 29 มีนาคม 2561  :try to logon with: GS1WS
16:55:54 29 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
16:55:54 29 มีนาคม 2561  :try to logon with: GS1WS
16:56:47 29 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
16:56:47 29 มีนาคม 2561  :try to logon with: GS1WS
16:57:52 29 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
16:57:52 29 มีนาคม 2561  :try to logon with: GS1WS
17:00:29 29 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
17:00:29 29 มีนาคม 2561  :try to logon with: GS1WS
17:00:29 29 มีนาคม 2561  :getGS1changed=/*SELECT        MB_MEMBER.MEMBER_CODE, MB_PRENAME.PRENAME_TH, MB_COMP_PERSON.COMP_PERSON_NAME_TH, MB_PRENAME.PRENAME_EN, MB_COMP_PERSON.COMP_PERSON_NAME_EN, 
                         MB_COMP_PERSON.TAX_ID, MB_MEMBER.REGIST_DATE, MB_MEMBER.MEMBER_MAIN_TYPE_CODE, MB_MEMBER.MEMBER_TYPE_CODE, MB_MEMBER.MEMBER_STATUS_CODE, MB_MEMBER_RETIRE.APPROVE_DATE
FROM            MB_MEMBER INNER JOIN
                         MB_COMP_PERSON ON MB_MEMBER.COMP_PERSON_CODE = MB_COMP_PERSON.COMP_PERSON_CODE INNER JOIN
                         MB_MEMBER_RETIRE ON MB_MEMBER.REGIST_CODE = MB_MEMBER_RETIRE.REGIST_CODE LEFT OUTER JOIN
                         MB_PRENAME ON MB_COMP_PERSON.PREN_CODE = MB_PRENAME.PRENAME_CODE
WHERE        (MB_MEMBER.MEMBER_MAIN_GROUP_CODE = '300') AND (MB_MEMBER_RETIRE.APPROVE_DATE BETWEEN dbo.fnc_StrToDateTime(@YYYYMMDD_FROM + '000000') AND dbo.fnc_StrToDateTime(@YYYYMMDD_TO + '235959'))
ORDER BY MB_MEMBER_RETIRE.APPROVE_DATE*/

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

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

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

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

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

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

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

	insert into tempWsGs1_002
	select * from fnc_GetGS1MemberInfoForWebServiceByTaxID(@TAX_ID)

    set @currentRow = @currentRow +1
end  

drop table tempWsGs1_001
select * from tempWsGs1_002
drop table tempWsGs1_002
17:00:29 29 มีนาคม 2561  :There is already an object named 'tempWsGs1_001' in the database.
17:00:29 29 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
17:00:29 29 มีนาคม 2561  :try to logon with: GS1WS
17:00:29 29 มีนาคม 2561  :getGS1changed=/*SELECT        MB_MEMBER.MEMBER_CODE, MB_PRENAME.PRENAME_TH, MB_COMP_PERSON.COMP_PERSON_NAME_TH, MB_PRENAME.PRENAME_EN, MB_COMP_PERSON.COMP_PERSON_NAME_EN, 
                         MB_COMP_PERSON.TAX_ID, MB_MEMBER.REGIST_DATE, MB_MEMBER.MEMBER_MAIN_TYPE_CODE, MB_MEMBER.MEMBER_TYPE_CODE, MB_MEMBER.MEMBER_STATUS_CODE, MB_MEMBER_RETIRE.APPROVE_DATE
FROM            MB_MEMBER INNER JOIN
                         MB_COMP_PERSON ON MB_MEMBER.COMP_PERSON_CODE = MB_COMP_PERSON.COMP_PERSON_CODE INNER JOIN
                         MB_MEMBER_RETIRE ON MB_MEMBER.REGIST_CODE = MB_MEMBER_RETIRE.REGIST_CODE LEFT OUTER JOIN
                         MB_PRENAME ON MB_COMP_PERSON.PREN_CODE = MB_PRENAME.PRENAME_CODE
WHERE        (MB_MEMBER.MEMBER_MAIN_GROUP_CODE = '300') AND (MB_MEMBER_RETIRE.APPROVE_DATE BETWEEN dbo.fnc_StrToDateTime(@YYYYMMDD_FROM + '000000') AND dbo.fnc_StrToDateTime(@YYYYMMDD_TO + '235959'))
ORDER BY MB_MEMBER_RETIRE.APPROVE_DATE*/

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

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

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

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

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

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

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

	insert into tempWsGs1_002
	select * from fnc_GetGS1MemberInfoForWebServiceByTaxID(@TAX_ID)

    set @currentRow = @currentRow +1
end  

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

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

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

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

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

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

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

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

	insert into tempWsGs1_002
	select * from fnc_GetGS1MemberInfoForWebServiceByTaxID(@TAX_ID)

    set @currentRow = @currentRow +1
end  

drop table tempWsGs1_001
select * from tempWsGs1_002
drop table tempWsGs1_002
18:00:24 29 มีนาคม 2561  :There is already an object named 'tempWsGs1_001' in the database.
18:00:35 29 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
18:00:35 29 มีนาคม 2561  :try to logon with: GS1WS
18:00:35 29 มีนาคม 2561  :getGS1changed=/*SELECT        MB_MEMBER.MEMBER_CODE, MB_PRENAME.PRENAME_TH, MB_COMP_PERSON.COMP_PERSON_NAME_TH, MB_PRENAME.PRENAME_EN, MB_COMP_PERSON.COMP_PERSON_NAME_EN, 
                         MB_COMP_PERSON.TAX_ID, MB_MEMBER.REGIST_DATE, MB_MEMBER.MEMBER_MAIN_TYPE_CODE, MB_MEMBER.MEMBER_TYPE_CODE, MB_MEMBER.MEMBER_STATUS_CODE, MB_MEMBER_RETIRE.APPROVE_DATE
FROM            MB_MEMBER INNER JOIN
                         MB_COMP_PERSON ON MB_MEMBER.COMP_PERSON_CODE = MB_COMP_PERSON.COMP_PERSON_CODE INNER JOIN
                         MB_MEMBER_RETIRE ON MB_MEMBER.REGIST_CODE = MB_MEMBER_RETIRE.REGIST_CODE LEFT OUTER JOIN
                         MB_PRENAME ON MB_COMP_PERSON.PREN_CODE = MB_PRENAME.PRENAME_CODE
WHERE        (MB_MEMBER.MEMBER_MAIN_GROUP_CODE = '300') AND (MB_MEMBER_RETIRE.APPROVE_DATE BETWEEN dbo.fnc_StrToDateTime(@YYYYMMDD_FROM + '000000') AND dbo.fnc_StrToDateTime(@YYYYMMDD_TO + '235959'))
ORDER BY MB_MEMBER_RETIRE.APPROVE_DATE*/

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

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

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

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

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

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

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

	insert into tempWsGs1_002
	select * from fnc_GetGS1MemberInfoForWebServiceByTaxID(@TAX_ID)

    set @currentRow = @currentRow +1
end  

drop table tempWsGs1_001
select * from tempWsGs1_002
drop table tempWsGs1_002
18:00:35 29 มีนาคม 2561  :There is already an object named 'tempWsGs1_001' in the database.
18:04:49 29 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
18:04:49 29 มีนาคม 2561  :try to logon with: GS1WS
18:04:58 29 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
18:04:58 29 มีนาคม 2561  :try to logon with: GS1WS
18:07:07 29 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
18:07:07 29 มีนาคม 2561  :try to logon with: GS1WS
18:10:58 29 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
18:10:58 29 มีนาคม 2561  :try to logon with: GS1WS
18:11:30 29 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
18:11:30 29 มีนาคม 2561  :try to logon with: GS1WS
18:11:51 29 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
18:11:51 29 มีนาคม 2561  :try to logon with: GS1WS
18:12:09 29 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
18:12:09 29 มีนาคม 2561  :try to logon with: GS1WS
18:20:42 29 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
18:20:42 29 มีนาคม 2561  :try to logon with: GS1WS
18:29:09 29 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
18:29:09 29 มีนาคม 2561  :try to logon with: GS1WS
18:29:24 29 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
18:29:24 29 มีนาคม 2561  :try to logon with: GS1WS
18:29:40 29 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
18:29:40 29 มีนาคม 2561  :try to logon with: GS1WS
18:30:53 29 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
18:30:53 29 มีนาคม 2561  :try to logon with: GS1WS
18:33:10 29 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
18:33:10 29 มีนาคม 2561  :try to logon with: GS1WS
18:34:05 29 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
18:34:05 29 มีนาคม 2561  :try to logon with: GS1WS
18:34:33 29 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
18:34:33 29 มีนาคม 2561  :try to logon with: GS1WS
19:00:28 29 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
19:00:28 29 มีนาคม 2561  :try to logon with: GS1WS
19:00:28 29 มีนาคม 2561  :getGS1changed=/*SELECT        MB_MEMBER.MEMBER_CODE, MB_PRENAME.PRENAME_TH, MB_COMP_PERSON.COMP_PERSON_NAME_TH, MB_PRENAME.PRENAME_EN, MB_COMP_PERSON.COMP_PERSON_NAME_EN, 
                         MB_COMP_PERSON.TAX_ID, MB_MEMBER.REGIST_DATE, MB_MEMBER.MEMBER_MAIN_TYPE_CODE, MB_MEMBER.MEMBER_TYPE_CODE, MB_MEMBER.MEMBER_STATUS_CODE, MB_MEMBER_RETIRE.APPROVE_DATE
FROM            MB_MEMBER INNER JOIN
                         MB_COMP_PERSON ON MB_MEMBER.COMP_PERSON_CODE = MB_COMP_PERSON.COMP_PERSON_CODE INNER JOIN
                         MB_MEMBER_RETIRE ON MB_MEMBER.REGIST_CODE = MB_MEMBER_RETIRE.REGIST_CODE LEFT OUTER JOIN
                         MB_PRENAME ON MB_COMP_PERSON.PREN_CODE = MB_PRENAME.PRENAME_CODE
WHERE        (MB_MEMBER.MEMBER_MAIN_GROUP_CODE = '300') AND (MB_MEMBER_RETIRE.APPROVE_DATE BETWEEN dbo.fnc_StrToDateTime(@YYYYMMDD_FROM + '000000') AND dbo.fnc_StrToDateTime(@YYYYMMDD_TO + '235959'))
ORDER BY MB_MEMBER_RETIRE.APPROVE_DATE*/

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

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

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

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

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

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

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

	insert into tempWsGs1_002
	select * from fnc_GetGS1MemberInfoForWebServiceByTaxID(@TAX_ID)

    set @currentRow = @currentRow +1
end  

drop table tempWsGs1_001
select * from tempWsGs1_002
drop table tempWsGs1_002
19:00:28 29 มีนาคม 2561  :There is already an object named 'tempWsGs1_001' in the database.
19:37:58 29 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
19:37:58 29 มีนาคม 2561  :try to logon with: GS1WS
20:00:26 29 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
20:00:26 29 มีนาคม 2561  :try to logon with: GS1WS
20:00:26 29 มีนาคม 2561  :getGS1changed=/*SELECT        MB_MEMBER.MEMBER_CODE, MB_PRENAME.PRENAME_TH, MB_COMP_PERSON.COMP_PERSON_NAME_TH, MB_PRENAME.PRENAME_EN, MB_COMP_PERSON.COMP_PERSON_NAME_EN, 
                         MB_COMP_PERSON.TAX_ID, MB_MEMBER.REGIST_DATE, MB_MEMBER.MEMBER_MAIN_TYPE_CODE, MB_MEMBER.MEMBER_TYPE_CODE, MB_MEMBER.MEMBER_STATUS_CODE, MB_MEMBER_RETIRE.APPROVE_DATE
FROM            MB_MEMBER INNER JOIN
                         MB_COMP_PERSON ON MB_MEMBER.COMP_PERSON_CODE = MB_COMP_PERSON.COMP_PERSON_CODE INNER JOIN
                         MB_MEMBER_RETIRE ON MB_MEMBER.REGIST_CODE = MB_MEMBER_RETIRE.REGIST_CODE LEFT OUTER JOIN
                         MB_PRENAME ON MB_COMP_PERSON.PREN_CODE = MB_PRENAME.PRENAME_CODE
WHERE        (MB_MEMBER.MEMBER_MAIN_GROUP_CODE = '300') AND (MB_MEMBER_RETIRE.APPROVE_DATE BETWEEN dbo.fnc_StrToDateTime(@YYYYMMDD_FROM + '000000') AND dbo.fnc_StrToDateTime(@YYYYMMDD_TO + '235959'))
ORDER BY MB_MEMBER_RETIRE.APPROVE_DATE*/

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

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

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

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

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

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

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

	insert into tempWsGs1_002
	select * from fnc_GetGS1MemberInfoForWebServiceByTaxID(@TAX_ID)

    set @currentRow = @currentRow +1
end  

drop table tempWsGs1_001
select * from tempWsGs1_002
drop table tempWsGs1_002
20:00:26 29 มีนาคม 2561  :There is already an object named 'tempWsGs1_001' in the database.
21:00:30 29 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
21:00:30 29 มีนาคม 2561  :try to logon with: GS1WS
21:00:30 29 มีนาคม 2561  :getGS1changed=/*SELECT        MB_MEMBER.MEMBER_CODE, MB_PRENAME.PRENAME_TH, MB_COMP_PERSON.COMP_PERSON_NAME_TH, MB_PRENAME.PRENAME_EN, MB_COMP_PERSON.COMP_PERSON_NAME_EN, 
                         MB_COMP_PERSON.TAX_ID, MB_MEMBER.REGIST_DATE, MB_MEMBER.MEMBER_MAIN_TYPE_CODE, MB_MEMBER.MEMBER_TYPE_CODE, MB_MEMBER.MEMBER_STATUS_CODE, MB_MEMBER_RETIRE.APPROVE_DATE
FROM            MB_MEMBER INNER JOIN
                         MB_COMP_PERSON ON MB_MEMBER.COMP_PERSON_CODE = MB_COMP_PERSON.COMP_PERSON_CODE INNER JOIN
                         MB_MEMBER_RETIRE ON MB_MEMBER.REGIST_CODE = MB_MEMBER_RETIRE.REGIST_CODE LEFT OUTER JOIN
                         MB_PRENAME ON MB_COMP_PERSON.PREN_CODE = MB_PRENAME.PRENAME_CODE
WHERE        (MB_MEMBER.MEMBER_MAIN_GROUP_CODE = '300') AND (MB_MEMBER_RETIRE.APPROVE_DATE BETWEEN dbo.fnc_StrToDateTime(@YYYYMMDD_FROM + '000000') AND dbo.fnc_StrToDateTime(@YYYYMMDD_TO + '235959'))
ORDER BY MB_MEMBER_RETIRE.APPROVE_DATE*/

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

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

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

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

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

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

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

	insert into tempWsGs1_002
	select * from fnc_GetGS1MemberInfoForWebServiceByTaxID(@TAX_ID)

    set @currentRow = @currentRow +1
end  

drop table tempWsGs1_001
select * from tempWsGs1_002
drop table tempWsGs1_002
21:00:30 29 มีนาคม 2561  :There is already an object named 'tempWsGs1_001' in the database.
22:00:30 29 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
22:00:30 29 มีนาคม 2561  :try to logon with: GS1WS
22:00:30 29 มีนาคม 2561  :getGS1changed=/*SELECT        MB_MEMBER.MEMBER_CODE, MB_PRENAME.PRENAME_TH, MB_COMP_PERSON.COMP_PERSON_NAME_TH, MB_PRENAME.PRENAME_EN, MB_COMP_PERSON.COMP_PERSON_NAME_EN, 
                         MB_COMP_PERSON.TAX_ID, MB_MEMBER.REGIST_DATE, MB_MEMBER.MEMBER_MAIN_TYPE_CODE, MB_MEMBER.MEMBER_TYPE_CODE, MB_MEMBER.MEMBER_STATUS_CODE, MB_MEMBER_RETIRE.APPROVE_DATE
FROM            MB_MEMBER INNER JOIN
                         MB_COMP_PERSON ON MB_MEMBER.COMP_PERSON_CODE = MB_COMP_PERSON.COMP_PERSON_CODE INNER JOIN
                         MB_MEMBER_RETIRE ON MB_MEMBER.REGIST_CODE = MB_MEMBER_RETIRE.REGIST_CODE LEFT OUTER JOIN
                         MB_PRENAME ON MB_COMP_PERSON.PREN_CODE = MB_PRENAME.PRENAME_CODE
WHERE        (MB_MEMBER.MEMBER_MAIN_GROUP_CODE = '300') AND (MB_MEMBER_RETIRE.APPROVE_DATE BETWEEN dbo.fnc_StrToDateTime(@YYYYMMDD_FROM + '000000') AND dbo.fnc_StrToDateTime(@YYYYMMDD_TO + '235959'))
ORDER BY MB_MEMBER_RETIRE.APPROVE_DATE*/

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

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

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

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

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

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

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

	insert into tempWsGs1_002
	select * from fnc_GetGS1MemberInfoForWebServiceByTaxID(@TAX_ID)

    set @currentRow = @currentRow +1
end  

drop table tempWsGs1_001
select * from tempWsGs1_002
drop table tempWsGs1_002
22:00:30 29 มีนาคม 2561  :There is already an object named 'tempWsGs1_001' in the database.
23:00:25 29 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
23:00:25 29 มีนาคม 2561  :try to logon with: GS1WS
23:00:25 29 มีนาคม 2561  :getGS1changed=/*SELECT        MB_MEMBER.MEMBER_CODE, MB_PRENAME.PRENAME_TH, MB_COMP_PERSON.COMP_PERSON_NAME_TH, MB_PRENAME.PRENAME_EN, MB_COMP_PERSON.COMP_PERSON_NAME_EN, 
                         MB_COMP_PERSON.TAX_ID, MB_MEMBER.REGIST_DATE, MB_MEMBER.MEMBER_MAIN_TYPE_CODE, MB_MEMBER.MEMBER_TYPE_CODE, MB_MEMBER.MEMBER_STATUS_CODE, MB_MEMBER_RETIRE.APPROVE_DATE
FROM            MB_MEMBER INNER JOIN
                         MB_COMP_PERSON ON MB_MEMBER.COMP_PERSON_CODE = MB_COMP_PERSON.COMP_PERSON_CODE INNER JOIN
                         MB_MEMBER_RETIRE ON MB_MEMBER.REGIST_CODE = MB_MEMBER_RETIRE.REGIST_CODE LEFT OUTER JOIN
                         MB_PRENAME ON MB_COMP_PERSON.PREN_CODE = MB_PRENAME.PRENAME_CODE
WHERE        (MB_MEMBER.MEMBER_MAIN_GROUP_CODE = '300') AND (MB_MEMBER_RETIRE.APPROVE_DATE BETWEEN dbo.fnc_StrToDateTime(@YYYYMMDD_FROM + '000000') AND dbo.fnc_StrToDateTime(@YYYYMMDD_TO + '235959'))
ORDER BY MB_MEMBER_RETIRE.APPROVE_DATE*/

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

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

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

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

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

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

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

	insert into tempWsGs1_002
	select * from fnc_GetGS1MemberInfoForWebServiceByTaxID(@TAX_ID)

    set @currentRow = @currentRow +1
end  

drop table tempWsGs1_001
select * from tempWsGs1_002
drop table tempWsGs1_002
23:00:25 29 มีนาคม 2561  :There is already an object named 'tempWsGs1_001' in the database.
23:04:09 29 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
23:04:09 29 มีนาคม 2561  :try to logon with: GS1WS
23:13:09 29 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
23:13:09 29 มีนาคม 2561  :try to logon with: GS1WS
23:16:00 29 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
23:16:00 29 มีนาคม 2561  :try to logon with: GS1WS
23:17:22 29 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
23:17:22 29 มีนาคม 2561  :try to logon with: GS1WS
23:43:42 29 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
23:43:42 29 มีนาคม 2561  :try to logon with: GS1WS