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

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

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

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

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

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

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

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

	insert into tempWsGs1_002
	select * from fnc_GetGS1MemberInfoForWebServiceByTaxID(@TAX_ID)

    set @currentRow = @currentRow +1
end  

drop table tempWsGs1_001
select * from tempWsGs1_002
drop table tempWsGs1_002
8:00:34 13 มีนาคม 2561  :There is already an object named 'tempWsGs1_001' in the database.
9:00:38 13 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
9:00:38 13 มีนาคม 2561  :try to logon with: GS1WS
9:00:38 13 มีนาคม 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 13 มีนาคม 2561  :There is already an object named 'tempWsGs1_001' in the database.
9:39:59 13 มีนาคม 2561  :Server was unable to process request. ---> [DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied.
9:47:19 13 มีนาคม 2561  :There was no endpoint listening at https://rdws.rd.go.th/serviceRD3/vatserviceRD3.asmx that could accept the message. This is often caused by an incorrect address or SOAP action. See InnerException, if present, for more details.
10:00:38 13 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
10:00:38 13 มีนาคม 2561  :try to logon with: GS1WS
10:00:38 13 มีนาคม 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 13 มีนาคม 2561  :There is already an object named 'tempWsGs1_001' in the database.
10:00:44 13 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
10:00:44 13 มีนาคม 2561  :try to logon with: GS1WS
10:01:27 13 มีนาคม 2561  :Server was unable to process request. ---> [DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied.
10:01:42 13 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
10:01:42 13 มีนาคม 2561  :try to logon with: GS1WS
10:59:02 13 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
10:59:02 13 มีนาคม 2561  :try to logon with: GS1WS
11:00:34 13 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
11:00:34 13 มีนาคม 2561  :try to logon with: GS1WS
11:00:34 13 มีนาคม 2561  :getGS1changed=/*SELECT        MB_MEMBER.MEMBER_CODE, MB_PRENAME.PRENAME_TH, MB_COMP_PERSON.COMP_PERSON_NAME_TH, MB_PRENAME.PRENAME_EN, MB_COMP_PERSON.COMP_PERSON_NAME_EN, 
                         MB_COMP_PERSON.TAX_ID, MB_MEMBER.REGIST_DATE, MB_MEMBER.MEMBER_MAIN_TYPE_CODE, MB_MEMBER.MEMBER_TYPE_CODE, MB_MEMBER.MEMBER_STATUS_CODE, MB_MEMBER_RETIRE.APPROVE_DATE
FROM            MB_MEMBER INNER JOIN
                         MB_COMP_PERSON ON MB_MEMBER.COMP_PERSON_CODE = MB_COMP_PERSON.COMP_PERSON_CODE INNER JOIN
                         MB_MEMBER_RETIRE ON MB_MEMBER.REGIST_CODE = MB_MEMBER_RETIRE.REGIST_CODE LEFT OUTER JOIN
                         MB_PRENAME ON MB_COMP_PERSON.PREN_CODE = MB_PRENAME.PRENAME_CODE
WHERE        (MB_MEMBER.MEMBER_MAIN_GROUP_CODE = '300') AND (MB_MEMBER_RETIRE.APPROVE_DATE BETWEEN dbo.fnc_StrToDateTime(@YYYYMMDD_FROM + '000000') AND dbo.fnc_StrToDateTime(@YYYYMMDD_TO + '235959'))
ORDER BY MB_MEMBER_RETIRE.APPROVE_DATE*/

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

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

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

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

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

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

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

	insert into tempWsGs1_002
	select * from fnc_GetGS1MemberInfoForWebServiceByTaxID(@TAX_ID)

    set @currentRow = @currentRow +1
end  

drop table tempWsGs1_001
select * from tempWsGs1_002
drop table tempWsGs1_002
11:00:34 13 มีนาคม 2561  :There is already an object named 'tempWsGs1_001' in the database.
11:05:23 13 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
11:05:23 13 มีนาคม 2561  :try to logon with: GS1WS
11:07:52 13 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
11:07:52 13 มีนาคม 2561  :try to logon with: GS1WS
11:09:31 13 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
11:09:31 13 มีนาคม 2561  :try to logon with: GS1WS
11:11:12 13 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
11:11:12 13 มีนาคม 2561  :try to logon with: GS1WS
11:13:41 13 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
11:13:41 13 มีนาคม 2561  :try to logon with: GS1WS
11:16:06 13 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
11:16:06 13 มีนาคม 2561  :try to logon with: GS1WS
11:24:28 13 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
11:24:28 13 มีนาคม 2561  :try to logon with: GS1WS
11:26:25 13 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
11:26:25 13 มีนาคม 2561  :try to logon with: GS1WS
11:37:16 13 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
11:37:16 13 มีนาคม 2561  :try to logon with: GS1WS
11:46:38 13 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
11:46:38 13 มีนาคม 2561  :try to logon with: GS1WS
11:46:47 13 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
11:46:47 13 มีนาคม 2561  :try to logon with: GS1WS
11:48:09 13 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
11:48:09 13 มีนาคม 2561  :try to logon with: GS1WS
11:49:53 13 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
11:49:53 13 มีนาคม 2561  :try to logon with: GS1WS
11:51:45 13 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
11:51:45 13 มีนาคม 2561  :try to logon with: GS1WS
11:54:05 13 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
11:54:05 13 มีนาคม 2561  :try to logon with: GS1WS
11:55:55 13 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
11:55:55 13 มีนาคม 2561  :try to logon with: GS1WS
11:56:58 13 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
11:56:58 13 มีนาคม 2561  :try to logon with: GS1WS
11:57:56 13 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
11:57:56 13 มีนาคม 2561  :try to logon with: GS1WS
12:00:34 13 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
12:00:34 13 มีนาคม 2561  :try to logon with: GS1WS
12:00:34 13 มีนาคม 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:34 13 มีนาคม 2561  :There is already an object named 'tempWsGs1_001' in the database.
12:15:38 13 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
12:15:38 13 มีนาคม 2561  :try to logon with: GS1WS
12:17:16 13 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
12:17:16 13 มีนาคม 2561  :try to logon with: GS1WS
12:19:56 13 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
12:19:56 13 มีนาคม 2561  :try to logon with: GS1WS
12:21:33 13 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
12:21:33 13 มีนาคม 2561  :try to logon with: GS1WS
12:36:08 13 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
12:36:08 13 มีนาคม 2561  :try to logon with: GS1WS
12:37:09 13 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
12:37:09 13 มีนาคม 2561  :try to logon with: GS1WS
12:44:14 13 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
12:44:14 13 มีนาคม 2561  :try to logon with: GS1WS
12:50:52 13 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
12:50:52 13 มีนาคม 2561  :try to logon with: GS1WS
13:00:39 13 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
13:00:39 13 มีนาคม 2561  :try to logon with: GS1WS
13:00:39 13 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
13:00:39 13 มีนาคม 2561  :try to logon with: GS1WS
13:00:39 13 มีนาคม 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 13 มีนาคม 2561  :There is already an object named 'tempWsGs1_001' in the database.
13:03:18 13 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
13:03:18 13 มีนาคม 2561  :try to logon with: GS1WS
13:03:54 13 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
13:03:54 13 มีนาคม 2561  :try to logon with: GS1WS
13:04:30 13 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
13:04:30 13 มีนาคม 2561  :try to logon with: GS1WS
13:05:25 13 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
13:05:25 13 มีนาคม 2561  :try to logon with: GS1WS
13:12:13 13 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
13:12:13 13 มีนาคม 2561  :try to logon with: GS1WS
13:12:47 13 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
13:12:47 13 มีนาคม 2561  :try to logon with: GS1WS
13:16:31 13 มีนาคม 2561  :There was no endpoint listening at https://rdws.rd.go.th/serviceRD3/vatserviceRD3.asmx that could accept the message. This is often caused by an incorrect address or SOAP action. See InnerException, if present, for more details.
13:20:01 13 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
13:20:01 13 มีนาคม 2561  :try to logon with: GS1WS
13:21:17 13 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
13:21:17 13 มีนาคม 2561  :try to logon with: GS1WS
13:21:20 13 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
13:21:20 13 มีนาคม 2561  :try to logon with: GS1WS
13:28:32 13 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
13:28:32 13 มีนาคม 2561  :try to logon with: GS1WS
13:29:38 13 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
13:29:38 13 มีนาคม 2561  :try to logon with: GS1WS
13:31:10 13 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
13:31:10 13 มีนาคม 2561  :try to logon with: GS1WS
13:31:21 13 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
13:31:21 13 มีนาคม 2561  :try to logon with: GS1WS
13:31:40 13 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
13:31:40 13 มีนาคม 2561  :try to logon with: GS1WS
13:33:01 13 มีนาคม 2561  :Server was unable to process request. ---> [DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied.
13:33:44 13 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
13:33:44 13 มีนาคม 2561  :try to logon with: GS1WS
13:34:39 13 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
13:34:39 13 มีนาคม 2561  :try to logon with: GS1WS
13:36:23 13 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
13:36:23 13 มีนาคม 2561  :try to logon with: GS1WS
13:37:11 13 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
13:37:11 13 มีนาคม 2561  :try to logon with: GS1WS
13:41:50 13 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
13:41:50 13 มีนาคม 2561  :try to logon with: GS1WS
13:45:22 13 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
13:45:22 13 มีนาคม 2561  :try to logon with: GS1WS
13:47:11 13 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
13:47:11 13 มีนาคม 2561  :try to logon with: GS1WS
13:49:18 13 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
13:49:18 13 มีนาคม 2561  :try to logon with: GS1WS
13:51:00 13 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
13:51:00 13 มีนาคม 2561  :try to logon with: GS1WS
13:51:17 13 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
13:51:17 13 มีนาคม 2561  :try to logon with: GS1WS
13:52:17 13 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
13:52:17 13 มีนาคม 2561  :try to logon with: GS1WS
13:53:13 13 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
13:53:13 13 มีนาคม 2561  :try to logon with: GS1WS
13:55:10 13 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
13:55:10 13 มีนาคม 2561  :try to logon with: GS1WS
13:55:38 13 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
13:55:38 13 มีนาคม 2561  :try to logon with: GS1WS
13:56:59 13 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
13:56:59 13 มีนาคม 2561  :try to logon with: GS1WS
13:57:25 13 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
13:57:25 13 มีนาคม 2561  :try to logon with: GS1WS
13:59:19 13 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
13:59:19 13 มีนาคม 2561  :try to logon with: GS1WS
14:00:33 13 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
14:00:33 13 มีนาคม 2561  :try to logon with: GS1WS
14:00:33 13 มีนาคม 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:33 13 มีนาคม 2561  :There is already an object named 'tempWsGs1_001' in the database.
14:01:10 13 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
14:01:10 13 มีนาคม 2561  :try to logon with: GS1WS
14:01:11 13 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
14:01:11 13 มีนาคม 2561  :try to logon with: GS1WS
14:02:18 13 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
14:02:18 13 มีนาคม 2561  :try to logon with: GS1WS
14:03:40 13 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
14:03:40 13 มีนาคม 2561  :try to logon with: GS1WS
14:07:43 13 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
14:07:43 13 มีนาคม 2561  :try to logon with: GS1WS
14:08:25 13 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
14:08:25 13 มีนาคม 2561  :try to logon with: GS1WS
14:10:04 13 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
14:10:04 13 มีนาคม 2561  :try to logon with: GS1WS
14:11:56 13 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
14:11:56 13 มีนาคม 2561  :try to logon with: GS1WS
14:13:07 13 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
14:13:07 13 มีนาคม 2561  :try to logon with: GS1WS
14:13:23 13 มีนาคม 2561  :Server was unable to process request. ---> [DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied.
14:17:02 13 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
14:17:02 13 มีนาคม 2561  :try to logon with: GS1WS
14:17:11 13 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
14:17:11 13 มีนาคม 2561  :try to logon with: GS1WS
14:19:16 13 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
14:19:16 13 มีนาคม 2561  :try to logon with: GS1WS
14:20:36 13 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
14:20:36 13 มีนาคม 2561  :try to logon with: GS1WS
14:21:52 13 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
14:21:52 13 มีนาคม 2561  :try to logon with: GS1WS
14:23:31 13 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
14:23:31 13 มีนาคม 2561  :try to logon with: GS1WS
14:25:07 13 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
14:25:07 13 มีนาคม 2561  :try to logon with: GS1WS
14:26:58 13 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
14:26:58 13 มีนาคม 2561  :try to logon with: GS1WS
14:34:59 13 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
14:34:59 13 มีนาคม 2561  :try to logon with: GS1WS
14:36:58 13 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
14:36:58 13 มีนาคม 2561  :try to logon with: GS1WS
14:38:33 13 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
14:38:33 13 มีนาคม 2561  :try to logon with: GS1WS
14:40:15 13 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
14:40:15 13 มีนาคม 2561  :try to logon with: GS1WS
14:41:50 13 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
14:41:50 13 มีนาคม 2561  :try to logon with: GS1WS
14:42:12 13 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
14:42:12 13 มีนาคม 2561  :try to logon with: GS1WS
14:44:54 13 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
14:44:54 13 มีนาคม 2561  :try to logon with: GS1WS
14:46:40 13 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
14:46:40 13 มีนาคม 2561  :try to logon with: GS1WS
14:49:19 13 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
14:49:19 13 มีนาคม 2561  :try to logon with: GS1WS
14:50:29 13 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
14:50:29 13 มีนาคม 2561  :try to logon with: GS1WS
14:50:33 13 มีนาคม 2561  :Server was unable to process request. ---> No error message available, result code: E_FAIL(0x80004005).
14:51:11 13 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
14:51:11 13 มีนาคม 2561  :try to logon with: GS1WS
14:54:16 13 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
14:54:16 13 มีนาคม 2561  :try to logon with: GS1WS
14:56:35 13 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
14:56:35 13 มีนาคม 2561  :try to logon with: GS1WS
14:58:18 13 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
14:58:18 13 มีนาคม 2561  :try to logon with: GS1WS
15:00:01 13 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
15:00:01 13 มีนาคม 2561  :try to logon with: GS1WS
15:00:33 13 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
15:00:33 13 มีนาคม 2561  :try to logon with: GS1WS
15:00:33 13 มีนาคม 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:33 13 มีนาคม 2561  :There is already an object named 'tempWsGs1_001' in the database.
15:02:51 13 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
15:02:51 13 มีนาคม 2561  :try to logon with: GS1WS
15:14:26 13 มีนาคม 2561  :Server was unable to process request. ---> [DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied.
15:15:51 13 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
15:15:51 13 มีนาคม 2561  :try to logon with: GS1WS
15:17:26 13 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
15:17:26 13 มีนาคม 2561  :try to logon with: GS1WS
15:19:45 13 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
15:19:45 13 มีนาคม 2561  :try to logon with: GS1WS
15:21:33 13 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
15:21:33 13 มีนาคม 2561  :try to logon with: GS1WS
15:23:14 13 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
15:23:14 13 มีนาคม 2561  :try to logon with: GS1WS
15:23:54 13 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
15:23:54 13 มีนาคม 2561  :try to logon with: GS1WS
15:25:09 13 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
15:25:09 13 มีนาคม 2561  :try to logon with: GS1WS
15:27:41 13 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
15:27:41 13 มีนาคม 2561  :try to logon with: GS1WS
15:29:29 13 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
15:29:29 13 มีนาคม 2561  :try to logon with: GS1WS
15:31:04 13 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
15:31:04 13 มีนาคม 2561  :try to logon with: GS1WS
15:32:42 13 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
15:32:42 13 มีนาคม 2561  :try to logon with: GS1WS
15:38:20 13 มีนาคม 2561  :There was no endpoint listening at https://rdws.rd.go.th/serviceRD3/vatserviceRD3.asmx that could accept the message. This is often caused by an incorrect address or SOAP action. See InnerException, if present, for more details.
15:47:53 13 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
15:47:53 13 มีนาคม 2561  :try to logon with: GS1WS
16:00:34 13 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
16:00:34 13 มีนาคม 2561  :try to logon with: GS1WS
16:00:34 13 มีนาคม 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:34 13 มีนาคม 2561  :There is already an object named 'tempWsGs1_001' in the database.
16:00:36 13 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
16:00:36 13 มีนาคม 2561  :try to logon with: GS1WS
16:02:39 13 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
16:02:39 13 มีนาคม 2561  :try to logon with: GS1WS
16:06:43 13 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
16:06:43 13 มีนาคม 2561  :try to logon with: GS1WS
16:07:42 13 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
16:07:42 13 มีนาคม 2561  :try to logon with: GS1WS
16:08:02 13 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
16:08:02 13 มีนาคม 2561  :try to logon with: GS1WS
16:09:37 13 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
16:09:37 13 มีนาคม 2561  :try to logon with: GS1WS
16:11:11 13 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
16:11:11 13 มีนาคม 2561  :try to logon with: GS1WS
16:13:36 13 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
16:13:36 13 มีนาคม 2561  :try to logon with: GS1WS
16:14:53 13 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
16:14:53 13 มีนาคม 2561  :try to logon with: GS1WS
16:16:41 13 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
16:16:41 13 มีนาคม 2561  :try to logon with: GS1WS
16:17:51 13 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
16:17:51 13 มีนาคม 2561  :try to logon with: GS1WS
16:17:53 13 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
16:17:53 13 มีนาคม 2561  :try to logon with: GS1WS
16:19:15 13 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
16:19:15 13 มีนาคม 2561  :try to logon with: GS1WS
16:20:03 13 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
16:20:03 13 มีนาคม 2561  :try to logon with: GS1WS
16:20:08 13 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
16:20:08 13 มีนาคม 2561  :try to logon with: GS1WS
16:21:46 13 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
16:21:46 13 มีนาคม 2561  :try to logon with: GS1WS
16:21:47 13 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
16:21:47 13 มีนาคม 2561  :try to logon with: GS1WS
16:23:08 13 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
16:23:08 13 มีนาคม 2561  :try to logon with: GS1WS
16:23:43 13 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
16:23:43 13 มีนาคม 2561  :try to logon with: GS1WS
16:26:34 13 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
16:26:34 13 มีนาคม 2561  :try to logon with: GS1WS
16:27:55 13 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
16:27:55 13 มีนาคม 2561  :try to logon with: GS1WS
16:28:52 13 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
16:28:52 13 มีนาคม 2561  :try to logon with: GS1WS
16:32:20 13 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
16:32:20 13 มีนาคม 2561  :try to logon with: GS1WS
16:34:11 13 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
16:34:11 13 มีนาคม 2561  :try to logon with: GS1WS
16:37:00 13 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
16:37:00 13 มีนาคม 2561  :try to logon with: GS1WS
16:37:09 13 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
16:37:09 13 มีนาคม 2561  :try to logon with: GS1WS
16:39:14 13 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
16:39:14 13 มีนาคม 2561  :try to logon with: GS1WS
16:40:35 13 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
16:40:35 13 มีนาคม 2561  :try to logon with: GS1WS
16:40:43 13 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
16:40:43 13 มีนาคม 2561  :try to logon with: GS1WS
16:42:33 13 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
16:42:33 13 มีนาคม 2561  :try to logon with: GS1WS
16:44:18 13 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
16:44:18 13 มีนาคม 2561  :try to logon with: GS1WS
16:46:59 13 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
16:46:59 13 มีนาคม 2561  :try to logon with: GS1WS
16:48:50 13 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
16:48:50 13 มีนาคม 2561  :try to logon with: GS1WS
16:52:46 13 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
16:52:46 13 มีนาคม 2561  :try to logon with: GS1WS
16:55:29 13 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
16:55:29 13 มีนาคม 2561  :try to logon with: GS1WS
16:57:47 13 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
16:57:47 13 มีนาคม 2561  :try to logon with: GS1WS
16:58:19 13 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
16:58:19 13 มีนาคม 2561  :try to logon with: GS1WS
16:58:27 13 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
16:58:27 13 มีนาคม 2561  :try to logon with: GS1WS
17:00:33 13 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
17:00:33 13 มีนาคม 2561  :try to logon with: GS1WS
17:00:33 13 มีนาคม 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:33 13 มีนาคม 2561  :There is already an object named 'tempWsGs1_001' in the database.
17:03:41 13 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
17:03:41 13 มีนาคม 2561  :try to logon with: GS1WS
17:07:05 13 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
17:07:05 13 มีนาคม 2561  :try to logon with: GS1WS
17:08:17 13 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
17:08:17 13 มีนาคม 2561  :try to logon with: GS1WS
17:09:59 13 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
17:09:59 13 มีนาคม 2561  :try to logon with: GS1WS
17:10:57 13 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
17:10:57 13 มีนาคม 2561  :try to logon with: GS1WS
17:11:36 13 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
17:11:36 13 มีนาคม 2561  :try to logon with: GS1WS
17:16:45 13 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
17:16:45 13 มีนาคม 2561  :try to logon with: GS1WS
17:18:25 13 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
17:18:25 13 มีนาคม 2561  :try to logon with: GS1WS
17:19:26 13 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
17:19:26 13 มีนาคม 2561  :try to logon with: GS1WS
18:00:33 13 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
18:00:33 13 มีนาคม 2561  :try to logon with: GS1WS
18:00:33 13 มีนาคม 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:33 13 มีนาคม 2561  :There is already an object named 'tempWsGs1_001' in the database.
18:23:30 13 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
18:23:30 13 มีนาคม 2561  :try to logon with: GS1WS
18:26:38 13 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
18:26:38 13 มีนาคม 2561  :try to logon with: GS1WS
18:31:02 13 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
18:31:02 13 มีนาคม 2561  :try to logon with: GS1WS
18:35:15 13 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
18:35:15 13 มีนาคม 2561  :try to logon with: GS1WS
18:39:26 13 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
18:39:26 13 มีนาคม 2561  :try to logon with: GS1WS
18:39:44 13 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
18:39:44 13 มีนาคม 2561  :try to logon with: GS1WS
18:43:44 13 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
18:43:44 13 มีนาคม 2561  :try to logon with: GS1WS
19:00:33 13 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
19:00:33 13 มีนาคม 2561  :try to logon with: GS1WS
19:00:34 13 มีนาคม 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:34 13 มีนาคม 2561  :There is already an object named 'tempWsGs1_001' in the database.
19:48:56 13 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
19:48:56 13 มีนาคม 2561  :try to logon with: GS1WS
19:49:40 13 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
19:49:40 13 มีนาคม 2561  :try to logon with: GS1WS
19:50:21 13 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
19:50:21 13 มีนาคม 2561  :try to logon with: GS1WS
19:50:56 13 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
19:50:56 13 มีนาคม 2561  :try to logon with: GS1WS
19:51:37 13 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
19:51:37 13 มีนาคม 2561  :try to logon with: GS1WS
19:52:20 13 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
19:52:20 13 มีนาคม 2561  :try to logon with: GS1WS
19:54:51 13 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
19:54:51 13 มีนาคม 2561  :try to logon with: GS1WS
19:55:34 13 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
19:55:34 13 มีนาคม 2561  :try to logon with: GS1WS
20:00:33 13 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
20:00:33 13 มีนาคม 2561  :try to logon with: GS1WS
20:00:33 13 มีนาคม 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:33 13 มีนาคม 2561  :There is already an object named 'tempWsGs1_001' in the database.
21:00:34 13 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
21:00:34 13 มีนาคม 2561  :try to logon with: GS1WS
21:00:34 13 มีนาคม 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:34 13 มีนาคม 2561  :There is already an object named 'tempWsGs1_001' in the database.
22:00:33 13 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
22:00:33 13 มีนาคม 2561  :try to logon with: GS1WS
22:00:33 13 มีนาคม 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:33 13 มีนาคม 2561  :There is already an object named 'tempWsGs1_001' in the database.
23:00:36 13 มีนาคม 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
23:00:36 13 มีนาคม 2561  :try to logon with: GS1WS
23:00:36 13 มีนาคม 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:36 13 มีนาคม 2561  :There is already an object named 'tempWsGs1_001' in the database.