0:00:39 5 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
0:00:39 5 มีนาคม 2561  :try to logon with: GS1WS
0:00:39 5 มีนาคม 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:39 5 มีนาคม 2561  :There is already an object named 'tempWsGs1_001' in the database.
1:00:38 5 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
1:00:38 5 มีนาคม 2561  :try to logon with: GS1WS
1:00:38 5 มีนาคม 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:38 5 มีนาคม 2561  :There is already an object named 'tempWsGs1_001' in the database.
2:00:38 5 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
2:00:38 5 มีนาคม 2561  :try to logon with: GS1WS
2:00:38 5 มีนาคม 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:38 5 มีนาคม 2561  :There is already an object named 'tempWsGs1_001' in the database.
3:00:38 5 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
3:00:38 5 มีนาคม 2561  :try to logon with: GS1WS
3:00:38 5 มีนาคม 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:38 5 มีนาคม 2561  :There is already an object named 'tempWsGs1_001' in the database.
4:00:38 5 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
4:00:38 5 มีนาคม 2561  :try to logon with: GS1WS
4:00:38 5 มีนาคม 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:38 5 มีนาคม 2561  :There is already an object named 'tempWsGs1_001' in the database.
5:00:38 5 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
5:00:38 5 มีนาคม 2561  :try to logon with: GS1WS
5:00:38 5 มีนาคม 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:38 5 มีนาคม 2561  :There is already an object named 'tempWsGs1_001' in the database.
6:00:38 5 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
6:00:38 5 มีนาคม 2561  :try to logon with: GS1WS
6:00:38 5 มีนาคม 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:38 5 มีนาคม 2561  :There is already an object named 'tempWsGs1_001' in the database.
7:00:38 5 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
7:00:38 5 มีนาคม 2561  :try to logon with: GS1WS
7:00:38 5 มีนาคม 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:38 5 มีนาคม 2561  :There is already an object named 'tempWsGs1_001' in the database.
8:00:41 5 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
8:00:41 5 มีนาคม 2561  :try to logon with: GS1WS
8:00:41 5 มีนาคม 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:41 5 มีนาคม 2561  :There is already an object named 'tempWsGs1_001' in the database.
9:00:38 5 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
9:00:38 5 มีนาคม 2561  :try to logon with: GS1WS
9:00:38 5 มีนาคม 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:38 5 มีนาคม 2561  :There is already an object named 'tempWsGs1_001' in the database.
10:00:38 5 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
10:00:38 5 มีนาคม 2561  :try to logon with: GS1WS
10:00:38 5 มีนาคม 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:38 5 มีนาคม 2561  :There is already an object named 'tempWsGs1_001' in the database.
10:01:34 5 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
10:01:34 5 มีนาคม 2561  :try to logon with: GS1WS
10:18:17 5 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
10:18:17 5 มีนาคม 2561  :try to logon with: GS1WS
10:23:57 5 มีนาคม 2561  :Server was unable to process request. ---> Cannot open database "RDtmp" requested by the login. The login failed.
10:50:33 5 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
10:50:33 5 มีนาคม 2561  :try to logon with: GS1WS
10:50:38 5 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
10:50:38 5 มีนาคม 2561  :try to logon with: GS1WS
10:51:39 5 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
10:51:39 5 มีนาคม 2561  :try to logon with: GS1WS
10:53:17 5 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
10:53:17 5 มีนาคม 2561  :try to logon with: GS1WS
11:04:40 5 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
11:04:40 5 มีนาคม 2561  :try to logon with: GS1WS
11:08:50 5 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
11:08:50 5 มีนาคม 2561  :try to logon with: GS1WS
11:08:51 5 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
11:08:51 5 มีนาคม 2561  :try to logon with: GS1WS
11:08:51 5 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
11:08:51 5 มีนาคม 2561  :try to logon with: GS1WS
11:08:51 5 มีนาคม 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:08:51 5 มีนาคม 2561  :There is already an object named 'tempWsGs1_001' in the database.
11:08:51 5 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
11:08:51 5 มีนาคม 2561  :try to logon with: GS1WS
11:08:51 5 มีนาคม 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:08:51 5 มีนาคม 2561  :There is already an object named 'tempWsGs1_001' in the database.
11:10:38 5 มีนาคม 2561  :The user name or password is incorrect.

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

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

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

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

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

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

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

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

	insert into tempWsGs1_002
	select * from fnc_GetGS1MemberInfoForWebServiceByTaxID(@TAX_ID)

    set @currentRow = @currentRow +1
end  

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