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

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

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

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

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

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

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

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

	insert into tempWsGs1_002
	select * from fnc_GetGS1MemberInfoForWebServiceByTaxID(@TAX_ID)

    set @currentRow = @currentRow +1
end  

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

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

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

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

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

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

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

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

	insert into tempWsGs1_002
	select * from fnc_GetGS1MemberInfoForWebServiceByTaxID(@TAX_ID)

    set @currentRow = @currentRow +1
end  

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

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

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

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

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

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

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

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

	insert into tempWsGs1_002
	select * from fnc_GetGS1MemberInfoForWebServiceByTaxID(@TAX_ID)

    set @currentRow = @currentRow +1
end  

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

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

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

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

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

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

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

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

	insert into tempWsGs1_002
	select * from fnc_GetGS1MemberInfoForWebServiceByTaxID(@TAX_ID)

    set @currentRow = @currentRow +1
end  

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

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

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

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

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

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

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

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

	insert into tempWsGs1_002
	select * from fnc_GetGS1MemberInfoForWebServiceByTaxID(@TAX_ID)

    set @currentRow = @currentRow +1
end  

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

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

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

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

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

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

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

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

	insert into tempWsGs1_002
	select * from fnc_GetGS1MemberInfoForWebServiceByTaxID(@TAX_ID)

    set @currentRow = @currentRow +1
end  

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

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

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

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

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

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

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

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

	insert into tempWsGs1_002
	select * from fnc_GetGS1MemberInfoForWebServiceByTaxID(@TAX_ID)

    set @currentRow = @currentRow +1
end  

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

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

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

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

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

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

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

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

	insert into tempWsGs1_002
	select * from fnc_GetGS1MemberInfoForWebServiceByTaxID(@TAX_ID)

    set @currentRow = @currentRow +1
end  

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

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

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

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

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

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

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

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

	insert into tempWsGs1_002
	select * from fnc_GetGS1MemberInfoForWebServiceByTaxID(@TAX_ID)

    set @currentRow = @currentRow +1
end  

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

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

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

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

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

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

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

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

	insert into tempWsGs1_002
	select * from fnc_GetGS1MemberInfoForWebServiceByTaxID(@TAX_ID)

    set @currentRow = @currentRow +1
end  

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

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

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

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

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

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

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

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

	insert into tempWsGs1_002
	select * from fnc_GetGS1MemberInfoForWebServiceByTaxID(@TAX_ID)

    set @currentRow = @currentRow +1
end  

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

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

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

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

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

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

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

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

	insert into tempWsGs1_002
	select * from fnc_GetGS1MemberInfoForWebServiceByTaxID(@TAX_ID)

    set @currentRow = @currentRow +1
end  

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

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

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

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

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

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

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

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

	insert into tempWsGs1_002
	select * from fnc_GetGS1MemberInfoForWebServiceByTaxID(@TAX_ID)

    set @currentRow = @currentRow +1
end  

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

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

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

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

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

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

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

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

	insert into tempWsGs1_002
	select * from fnc_GetGS1MemberInfoForWebServiceByTaxID(@TAX_ID)

    set @currentRow = @currentRow +1
end  

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

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

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

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

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

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

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

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

	insert into tempWsGs1_002
	select * from fnc_GetGS1MemberInfoForWebServiceByTaxID(@TAX_ID)

    set @currentRow = @currentRow +1
end  

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

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

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

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

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

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

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

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

	insert into tempWsGs1_002
	select * from fnc_GetGS1MemberInfoForWebServiceByTaxID(@TAX_ID)

    set @currentRow = @currentRow +1
end  

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

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

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

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

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

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

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

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

	insert into tempWsGs1_002
	select * from fnc_GetGS1MemberInfoForWebServiceByTaxID(@TAX_ID)

    set @currentRow = @currentRow +1
end  

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

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

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

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

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

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

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

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

	insert into tempWsGs1_002
	select * from fnc_GetGS1MemberInfoForWebServiceByTaxID(@TAX_ID)

    set @currentRow = @currentRow +1
end  

drop table tempWsGs1_001
select * from tempWsGs1_002
drop table tempWsGs1_002
8:59:46 5 มิถุนายน 2561  :There is already an object named 'tempWsGs1_001' in the database.
9:14:02 5 มิถุนายน 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
9:14:02 5 มิถุนายน 2561  :try to logon with: GS1WS
9:14:04 5 มิถุนายน 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
9:14:04 5 มิถุนายน 2561  :try to logon with: GS1WS
9:14:29 5 มิถุนายน 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
9:14:29 5 มิถุนายน 2561  :try to logon with: GS1WS
9:14:31 5 มิถุนายน 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
9:14:31 5 มิถุนายน 2561  :try to logon with: GS1WS
9:14:33 5 มิถุนายน 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
9:14:33 5 มิถุนายน 2561  :try to logon with: GS1WS
9:14:35 5 มิถุนายน 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
9:14:35 5 มิถุนายน 2561  :try to logon with: GS1WS
9:14:37 5 มิถุนายน 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
9:14:37 5 มิถุนายน 2561  :try to logon with: GS1WS
9:14:40 5 มิถุนายน 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
9:14:40 5 มิถุนายน 2561  :try to logon with: GS1WS
9:14:40 5 มิถุนายน 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
9:14:40 5 มิถุนายน 2561  :try to logon with: GS1WS
9:14:40 5 มิถุนายน 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
9:14:40 5 มิถุนายน 2561  :try to logon with: GS1WS
9:14:45 5 มิถุนายน 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
9:14:45 5 มิถุนายน 2561  :try to logon with: GS1WS
9:14:45 5 มิถุนายน 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
9:14:45 5 มิถุนายน 2561  :try to logon with: GS1WS
9:14:50 5 มิถุนายน 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
9:14:50 5 มิถุนายน 2561  :try to logon with: GS1WS
9:14:50 5 มิถุนายน 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
9:14:50 5 มิถุนายน 2561  :try to logon with: GS1WS
9:49:48 5 มิถุนายน 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
9:49:48 5 มิถุนายน 2561  :try to logon with: GS1WS
9:49:49 5 มิถุนายน 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
9:49:49 5 มิถุนายน 2561  :try to logon with: GS1WS
9:51:49 5 มิถุนายน 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
9:51:49 5 มิถุนายน 2561  :try to logon with: GS1WS
9:51:50 5 มิถุนายน 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
9:51:50 5 มิถุนายน 2561  :try to logon with: GS1WS
9:59:44 5 มิถุนายน 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
9:59:44 5 มิถุนายน 2561  :try to logon with: GS1WS
9:59:44 5 มิถุนายน 2561  :getGS1changed=/*SELECT        MB_MEMBER.MEMBER_CODE, MB_PRENAME.PRENAME_TH, MB_COMP_PERSON.COMP_PERSON_NAME_TH, MB_PRENAME.PRENAME_EN, MB_COMP_PERSON.COMP_PERSON_NAME_EN, 
                         MB_COMP_PERSON.TAX_ID, MB_MEMBER.REGIST_DATE, MB_MEMBER.MEMBER_MAIN_TYPE_CODE, MB_MEMBER.MEMBER_TYPE_CODE, MB_MEMBER.MEMBER_STATUS_CODE, MB_MEMBER_RETIRE.APPROVE_DATE
FROM            MB_MEMBER INNER JOIN
                         MB_COMP_PERSON ON MB_MEMBER.COMP_PERSON_CODE = MB_COMP_PERSON.COMP_PERSON_CODE INNER JOIN
                         MB_MEMBER_RETIRE ON MB_MEMBER.REGIST_CODE = MB_MEMBER_RETIRE.REGIST_CODE LEFT OUTER JOIN
                         MB_PRENAME ON MB_COMP_PERSON.PREN_CODE = MB_PRENAME.PRENAME_CODE
WHERE        (MB_MEMBER.MEMBER_MAIN_GROUP_CODE = '300') AND (MB_MEMBER_RETIRE.APPROVE_DATE BETWEEN dbo.fnc_StrToDateTime(@YYYYMMDD_FROM + '000000') AND dbo.fnc_StrToDateTime(@YYYYMMDD_TO + '235959'))
ORDER BY MB_MEMBER_RETIRE.APPROVE_DATE*/

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

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

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

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

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

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

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

	insert into tempWsGs1_002
	select * from fnc_GetGS1MemberInfoForWebServiceByTaxID(@TAX_ID)

    set @currentRow = @currentRow +1
end  

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

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

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

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

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

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

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

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

	insert into tempWsGs1_002
	select * from fnc_GetGS1MemberInfoForWebServiceByTaxID(@TAX_ID)

    set @currentRow = @currentRow +1
end  

drop table tempWsGs1_001
select * from tempWsGs1_002
drop table tempWsGs1_002
9:59:46 5 มิถุนายน 2561  :There is already an object named 'tempWsGs1_001' in the database.
10:25:47 5 มิถุนายน 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
10:25:47 5 มิถุนายน 2561  :try to logon with: GS1WS
10:25:47 5 มิถุนายน 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
10:25:47 5 มิถุนายน 2561  :try to logon with: GS1WS
10:38:15 5 มิถุนายน 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
10:38:15 5 มิถุนายน 2561  :try to logon with: GS1WS
10:38:16 5 มิถุนายน 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
10:38:16 5 มิถุนายน 2561  :try to logon with: GS1WS
10:41:55 5 มิถุนายน 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
10:41:55 5 มิถุนายน 2561  :try to logon with: GS1WS
10:41:56 5 มิถุนายน 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
10:41:56 5 มิถุนายน 2561  :try to logon with: GS1WS
10:41:56 5 มิถุนายน 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
10:41:56 5 มิถุนายน 2561  :try to logon with: GS1WS
10:41:56 5 มิถุนายน 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
10:41:56 5 มิถุนายน 2561  :try to logon with: GS1WS
10:42:04 5 มิถุนายน 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
10:42:04 5 มิถุนายน 2561  :try to logon with: GS1WS
10:42:05 5 มิถุนายน 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
10:42:05 5 มิถุนายน 2561  :try to logon with: GS1WS
10:48:59 5 มิถุนายน 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
10:48:59 5 มิถุนายน 2561  :try to logon with: GS1WS
10:48:59 5 มิถุนายน 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
10:48:59 5 มิถุนายน 2561  :try to logon with: GS1WS
10:48:59 5 มิถุนายน 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
10:48:59 5 มิถุนายน 2561  :try to logon with: GS1WS
10:48:59 5 มิถุนายน 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
10:48:59 5 มิถุนายน 2561  :try to logon with: GS1WS
10:51:19 5 มิถุนายน 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
10:51:19 5 มิถุนายน 2561  :try to logon with: GS1WS
10:51:19 5 มิถุนายน 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
10:51:19 5 มิถุนายน 2561  :try to logon with: GS1WS
10:51:19 5 มิถุนายน 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
10:51:19 5 มิถุนายน 2561  :try to logon with: GS1WS
10:51:19 5 มิถุนายน 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
10:51:19 5 มิถุนายน 2561  :try to logon with: GS1WS
10:58:41 5 มิถุนายน 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
10:58:41 5 มิถุนายน 2561  :try to logon with: GS1WS
10:58:41 5 มิถุนายน 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
10:58:41 5 มิถุนายน 2561  :try to logon with: GS1WS
10:58:41 5 มิถุนายน 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
10:58:41 5 มิถุนายน 2561  :try to logon with: GS1WS
10:58:41 5 มิถุนายน 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
10:58:41 5 มิถุนายน 2561  :try to logon with: GS1WS
10:59:36 5 มิถุนายน 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
10:59:36 5 มิถุนายน 2561  :try to logon with: GS1WS
10:59:37 5 มิถุนายน 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
10:59:37 5 มิถุนายน 2561  :try to logon with: GS1WS
10:59:43 5 มิถุนายน 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
10:59:43 5 มิถุนายน 2561  :try to logon with: GS1WS
10:59:43 5 มิถุนายน 2561  :getGS1changed=/*SELECT        MB_MEMBER.MEMBER_CODE, MB_PRENAME.PRENAME_TH, MB_COMP_PERSON.COMP_PERSON_NAME_TH, MB_PRENAME.PRENAME_EN, MB_COMP_PERSON.COMP_PERSON_NAME_EN, 
                         MB_COMP_PERSON.TAX_ID, MB_MEMBER.REGIST_DATE, MB_MEMBER.MEMBER_MAIN_TYPE_CODE, MB_MEMBER.MEMBER_TYPE_CODE, MB_MEMBER.MEMBER_STATUS_CODE, MB_MEMBER_RETIRE.APPROVE_DATE
FROM            MB_MEMBER INNER JOIN
                         MB_COMP_PERSON ON MB_MEMBER.COMP_PERSON_CODE = MB_COMP_PERSON.COMP_PERSON_CODE INNER JOIN
                         MB_MEMBER_RETIRE ON MB_MEMBER.REGIST_CODE = MB_MEMBER_RETIRE.REGIST_CODE LEFT OUTER JOIN
                         MB_PRENAME ON MB_COMP_PERSON.PREN_CODE = MB_PRENAME.PRENAME_CODE
WHERE        (MB_MEMBER.MEMBER_MAIN_GROUP_CODE = '300') AND (MB_MEMBER_RETIRE.APPROVE_DATE BETWEEN dbo.fnc_StrToDateTime(@YYYYMMDD_FROM + '000000') AND dbo.fnc_StrToDateTime(@YYYYMMDD_TO + '235959'))
ORDER BY MB_MEMBER_RETIRE.APPROVE_DATE*/

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

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

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

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

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

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

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

	insert into tempWsGs1_002
	select * from fnc_GetGS1MemberInfoForWebServiceByTaxID(@TAX_ID)

    set @currentRow = @currentRow +1
end  

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

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

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

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

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

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

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

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

	insert into tempWsGs1_002
	select * from fnc_GetGS1MemberInfoForWebServiceByTaxID(@TAX_ID)

    set @currentRow = @currentRow +1
end  

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

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

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

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

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

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

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

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

	insert into tempWsGs1_002
	select * from fnc_GetGS1MemberInfoForWebServiceByTaxID(@TAX_ID)

    set @currentRow = @currentRow +1
end  

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

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

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

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

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

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

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

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

	insert into tempWsGs1_002
	select * from fnc_GetGS1MemberInfoForWebServiceByTaxID(@TAX_ID)

    set @currentRow = @currentRow +1
end  

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

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

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

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

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

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

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

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

	insert into tempWsGs1_002
	select * from fnc_GetGS1MemberInfoForWebServiceByTaxID(@TAX_ID)

    set @currentRow = @currentRow +1
end  

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

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

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

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

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

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

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

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

	insert into tempWsGs1_002
	select * from fnc_GetGS1MemberInfoForWebServiceByTaxID(@TAX_ID)

    set @currentRow = @currentRow +1
end  

drop table tempWsGs1_001
select * from tempWsGs1_002
drop table tempWsGs1_002
12:59:51 5 มิถุนายน 2561  :There is already an object named 'tempWsGs1_001' in the database.
13:05:10 5 มิถุนายน 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
13:05:10 5 มิถุนายน 2561  :try to logon with: GS1WS
13:05:10 5 มิถุนายน 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
13:05:10 5 มิถุนายน 2561  :try to logon with: GS1WS
13:06:50 5 มิถุนายน 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
13:06:50 5 มิถุนายน 2561  :try to logon with: GS1WS
13:06:50 5 มิถุนายน 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
13:06:50 5 มิถุนายน 2561  :try to logon with: GS1WS
13:23:12 5 มิถุนายน 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
13:23:12 5 มิถุนายน 2561  :try to logon with: GS1WS
13:23:12 5 มิถุนายน 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
13:23:12 5 มิถุนายน 2561  :try to logon with: GS1WS
13:23:13 5 มิถุนายน 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
13:23:13 5 มิถุนายน 2561  :try to logon with: GS1WS
13:23:13 5 มิถุนายน 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
13:23:13 5 มิถุนายน 2561  :try to logon with: GS1WS
13:26:38 5 มิถุนายน 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
13:26:38 5 มิถุนายน 2561  :try to logon with: GS1WS
13:26:38 5 มิถุนายน 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
13:26:38 5 มิถุนายน 2561  :try to logon with: GS1WS
13:27:36 5 มิถุนายน 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
13:27:36 5 มิถุนายน 2561  :try to logon with: GS1WS
13:27:36 5 มิถุนายน 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
13:27:36 5 มิถุนายน 2561  :try to logon with: GS1WS
13:28:03 5 มิถุนายน 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
13:28:03 5 มิถุนายน 2561  :try to logon with: GS1WS
13:28:03 5 มิถุนายน 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
13:28:03 5 มิถุนายน 2561  :try to logon with: GS1WS
13:28:22 5 มิถุนายน 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
13:28:22 5 มิถุนายน 2561  :try to logon with: GS1WS
13:28:22 5 มิถุนายน 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
13:28:22 5 มิถุนายน 2561  :try to logon with: GS1WS
13:33:15 5 มิถุนายน 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
13:33:15 5 มิถุนายน 2561  :try to logon with: GS1WS
13:33:15 5 มิถุนายน 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
13:33:15 5 มิถุนายน 2561  :try to logon with: GS1WS
13:34:00 5 มิถุนายน 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
13:34:00 5 มิถุนายน 2561  :try to logon with: GS1WS
13:34:00 5 มิถุนายน 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
13:34:00 5 มิถุนายน 2561  :try to logon with: GS1WS
13:34:34 5 มิถุนายน 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
13:34:34 5 มิถุนายน 2561  :try to logon with: GS1WS
13:34:34 5 มิถุนายน 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
13:34:34 5 มิถุนายน 2561  :try to logon with: GS1WS
13:34:54 5 มิถุนายน 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
13:34:54 5 มิถุนายน 2561  :try to logon with: GS1WS
13:34:55 5 มิถุนายน 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
13:34:55 5 มิถุนายน 2561  :try to logon with: GS1WS
13:35:13 5 มิถุนายน 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
13:35:13 5 มิถุนายน 2561  :try to logon with: GS1WS
13:35:13 5 มิถุนายน 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
13:35:13 5 มิถุนายน 2561  :try to logon with: GS1WS
13:35:51 5 มิถุนายน 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
13:35:51 5 มิถุนายน 2561  :try to logon with: GS1WS
13:35:52 5 มิถุนายน 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
13:35:52 5 มิถุนายน 2561  :try to logon with: GS1WS
13:36:31 5 มิถุนายน 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
13:36:31 5 มิถุนายน 2561  :try to logon with: GS1WS
13:36:31 5 มิถุนายน 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
13:36:31 5 มิถุนายน 2561  :try to logon with: GS1WS
13:41:11 5 มิถุนายน 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
13:41:11 5 มิถุนายน 2561  :try to logon with: GS1WS
13:41:11 5 มิถุนายน 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
13:41:11 5 มิถุนายน 2561  :try to logon with: GS1WS
13:42:54 5 มิถุนายน 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
13:42:54 5 มิถุนายน 2561  :try to logon with: GS1WS
13:42:54 5 มิถุนายน 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
13:42:54 5 มิถุนายน 2561  :try to logon with: GS1WS
13:50:04 5 มิถุนายน 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
13:50:04 5 มิถุนายน 2561  :try to logon with: GS1WS
13:50:04 5 มิถุนายน 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
13:50:04 5 มิถุนายน 2561  :try to logon with: GS1WS
13:51:31 5 มิถุนายน 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
13:51:31 5 มิถุนายน 2561  :try to logon with: GS1WS
13:51:31 5 มิถุนายน 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
13:51:31 5 มิถุนายน 2561  :try to logon with: GS1WS
13:54:28 5 มิถุนายน 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
13:54:28 5 มิถุนายน 2561  :try to logon with: GS1WS
13:54:29 5 มิถุนายน 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
13:54:29 5 มิถุนายน 2561  :try to logon with: GS1WS
13:55:31 5 มิถุนายน 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
13:55:31 5 มิถุนายน 2561  :try to logon with: GS1WS
13:55:31 5 มิถุนายน 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
13:55:31 5 มิถุนายน 2561  :try to logon with: GS1WS
13:55:49 5 มิถุนายน 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
13:55:49 5 มิถุนายน 2561  :try to logon with: GS1WS
13:55:49 5 มิถุนายน 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
13:55:49 5 มิถุนายน 2561  :try to logon with: GS1WS
13:57:24 5 มิถุนายน 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
13:57:24 5 มิถุนายน 2561  :try to logon with: GS1WS
13:57:24 5 มิถุนายน 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
13:57:24 5 มิถุนายน 2561  :try to logon with: GS1WS
13:58:37 5 มิถุนายน 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
13:58:37 5 มิถุนายน 2561  :try to logon with: GS1WS
13:58:37 5 มิถุนายน 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
13:58:37 5 มิถุนายน 2561  :try to logon with: GS1WS
13:59:43 5 มิถุนายน 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
13:59:43 5 มิถุนายน 2561  :try to logon with: GS1WS
13:59:43 5 มิถุนายน 2561  :getGS1changed=/*SELECT        MB_MEMBER.MEMBER_CODE, MB_PRENAME.PRENAME_TH, MB_COMP_PERSON.COMP_PERSON_NAME_TH, MB_PRENAME.PRENAME_EN, MB_COMP_PERSON.COMP_PERSON_NAME_EN, 
                         MB_COMP_PERSON.TAX_ID, MB_MEMBER.REGIST_DATE, MB_MEMBER.MEMBER_MAIN_TYPE_CODE, MB_MEMBER.MEMBER_TYPE_CODE, MB_MEMBER.MEMBER_STATUS_CODE, MB_MEMBER_RETIRE.APPROVE_DATE
FROM            MB_MEMBER INNER JOIN
                         MB_COMP_PERSON ON MB_MEMBER.COMP_PERSON_CODE = MB_COMP_PERSON.COMP_PERSON_CODE INNER JOIN
                         MB_MEMBER_RETIRE ON MB_MEMBER.REGIST_CODE = MB_MEMBER_RETIRE.REGIST_CODE LEFT OUTER JOIN
                         MB_PRENAME ON MB_COMP_PERSON.PREN_CODE = MB_PRENAME.PRENAME_CODE
WHERE        (MB_MEMBER.MEMBER_MAIN_GROUP_CODE = '300') AND (MB_MEMBER_RETIRE.APPROVE_DATE BETWEEN dbo.fnc_StrToDateTime(@YYYYMMDD_FROM + '000000') AND dbo.fnc_StrToDateTime(@YYYYMMDD_TO + '235959'))
ORDER BY MB_MEMBER_RETIRE.APPROVE_DATE*/

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

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

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

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

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

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

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

	insert into tempWsGs1_002
	select * from fnc_GetGS1MemberInfoForWebServiceByTaxID(@TAX_ID)

    set @currentRow = @currentRow +1
end  

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

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

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

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

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

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

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

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

	insert into tempWsGs1_002
	select * from fnc_GetGS1MemberInfoForWebServiceByTaxID(@TAX_ID)

    set @currentRow = @currentRow +1
end  

drop table tempWsGs1_001
select * from tempWsGs1_002
drop table tempWsGs1_002
13:59:43 5 มิถุนายน 2561  :There is already an object named 'tempWsGs1_001' in the database.
14:04:52 5 มิถุนายน 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
14:04:52 5 มิถุนายน 2561  :try to logon with: GS1WS
14:04:53 5 มิถุนายน 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
14:04:53 5 มิถุนายน 2561  :try to logon with: GS1WS
14:10:56 5 มิถุนายน 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
14:10:56 5 มิถุนายน 2561  :try to logon with: GS1WS
14:10:56 5 มิถุนายน 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
14:10:56 5 มิถุนายน 2561  :try to logon with: GS1WS
14:18:17 5 มิถุนายน 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
14:18:17 5 มิถุนายน 2561  :try to logon with: GS1WS
14:18:17 5 มิถุนายน 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
14:18:17 5 มิถุนายน 2561  :try to logon with: GS1WS
14:25:23 5 มิถุนายน 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
14:25:23 5 มิถุนายน 2561  :try to logon with: GS1WS
14:25:24 5 มิถุนายน 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
14:25:24 5 มิถุนายน 2561  :try to logon with: GS1WS
14:30:38 5 มิถุนายน 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
14:30:38 5 มิถุนายน 2561  :try to logon with: GS1WS
14:30:38 5 มิถุนายน 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
14:30:38 5 มิถุนายน 2561  :try to logon with: GS1WS
14:31:00 5 มิถุนายน 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
14:31:00 5 มิถุนายน 2561  :try to logon with: GS1WS
14:31:00 5 มิถุนายน 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
14:31:00 5 มิถุนายน 2561  :try to logon with: GS1WS
14:31:47 5 มิถุนายน 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
14:31:47 5 มิถุนายน 2561  :try to logon with: GS1WS
14:31:47 5 มิถุนายน 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
14:31:47 5 มิถุนายน 2561  :try to logon with: GS1WS
14:32:19 5 มิถุนายน 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
14:32:19 5 มิถุนายน 2561  :try to logon with: GS1WS
14:32:19 5 มิถุนายน 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
14:32:19 5 มิถุนายน 2561  :try to logon with: GS1WS
14:33:50 5 มิถุนายน 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
14:33:50 5 มิถุนายน 2561  :try to logon with: GS1WS
14:33:50 5 มิถุนายน 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
14:33:50 5 มิถุนายน 2561  :try to logon with: GS1WS
14:36:18 5 มิถุนายน 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
14:36:18 5 มิถุนายน 2561  :try to logon with: GS1WS
14:36:18 5 มิถุนายน 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
14:36:18 5 มิถุนายน 2561  :try to logon with: GS1WS
14:36:43 5 มิถุนายน 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
14:36:43 5 มิถุนายน 2561  :try to logon with: GS1WS
14:36:43 5 มิถุนายน 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
14:36:43 5 มิถุนายน 2561  :try to logon with: GS1WS
14:37:46 5 มิถุนายน 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
14:37:46 5 มิถุนายน 2561  :try to logon with: GS1WS
14:37:47 5 มิถุนายน 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
14:37:47 5 มิถุนายน 2561  :try to logon with: GS1WS
14:38:50 5 มิถุนายน 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
14:38:50 5 มิถุนายน 2561  :try to logon with: GS1WS
14:38:50 5 มิถุนายน 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
14:38:50 5 มิถุนายน 2561  :try to logon with: GS1WS
14:39:23 5 มิถุนายน 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
14:39:23 5 มิถุนายน 2561  :try to logon with: GS1WS
14:39:23 5 มิถุนายน 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
14:39:23 5 มิถุนายน 2561  :try to logon with: GS1WS
14:46:45 5 มิถุนายน 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
14:46:45 5 มิถุนายน 2561  :try to logon with: GS1WS
14:46:46 5 มิถุนายน 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
14:46:46 5 มิถุนายน 2561  :try to logon with: GS1WS
14:46:48 5 มิถุนายน 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
14:46:48 5 มิถุนายน 2561  :try to logon with: GS1WS
14:46:48 5 มิถุนายน 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
14:46:48 5 มิถุนายน 2561  :try to logon with: GS1WS
14:47:32 5 มิถุนายน 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
14:47:32 5 มิถุนายน 2561  :try to logon with: GS1WS
14:47:32 5 มิถุนายน 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
14:47:32 5 มิถุนายน 2561  :try to logon with: GS1WS
14:59:43 5 มิถุนายน 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
14:59:43 5 มิถุนายน 2561  :try to logon with: GS1WS
14:59:43 5 มิถุนายน 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
14:59:43 5 มิถุนายน 2561  :try to logon with: GS1WS
14:59:43 5 มิถุนายน 2561  :getGS1changed=/*SELECT        MB_MEMBER.MEMBER_CODE, MB_PRENAME.PRENAME_TH, MB_COMP_PERSON.COMP_PERSON_NAME_TH, MB_PRENAME.PRENAME_EN, MB_COMP_PERSON.COMP_PERSON_NAME_EN, 
                         MB_COMP_PERSON.TAX_ID, MB_MEMBER.REGIST_DATE, MB_MEMBER.MEMBER_MAIN_TYPE_CODE, MB_MEMBER.MEMBER_TYPE_CODE, MB_MEMBER.MEMBER_STATUS_CODE, MB_MEMBER_RETIRE.APPROVE_DATE
FROM            MB_MEMBER INNER JOIN
                         MB_COMP_PERSON ON MB_MEMBER.COMP_PERSON_CODE = MB_COMP_PERSON.COMP_PERSON_CODE INNER JOIN
                         MB_MEMBER_RETIRE ON MB_MEMBER.REGIST_CODE = MB_MEMBER_RETIRE.REGIST_CODE LEFT OUTER JOIN
                         MB_PRENAME ON MB_COMP_PERSON.PREN_CODE = MB_PRENAME.PRENAME_CODE
WHERE        (MB_MEMBER.MEMBER_MAIN_GROUP_CODE = '300') AND (MB_MEMBER_RETIRE.APPROVE_DATE BETWEEN dbo.fnc_StrToDateTime(@YYYYMMDD_FROM + '000000') AND dbo.fnc_StrToDateTime(@YYYYMMDD_TO + '235959'))
ORDER BY MB_MEMBER_RETIRE.APPROVE_DATE*/

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

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

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

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

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

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

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

	insert into tempWsGs1_002
	select * from fnc_GetGS1MemberInfoForWebServiceByTaxID(@TAX_ID)

    set @currentRow = @currentRow +1
end  

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

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

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

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

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

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

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

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

	insert into tempWsGs1_002
	select * from fnc_GetGS1MemberInfoForWebServiceByTaxID(@TAX_ID)

    set @currentRow = @currentRow +1
end  

drop table tempWsGs1_001
select * from tempWsGs1_002
drop table tempWsGs1_002
14:59:43 5 มิถุนายน 2561  :There is already an object named 'tempWsGs1_001' in the database.
14:59:46 5 มิถุนายน 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
14:59:46 5 มิถุนายน 2561  :try to logon with: GS1WS
14:59:46 5 มิถุนายน 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
14:59:46 5 มิถุนายน 2561  :try to logon with: GS1WS
15:02:18 5 มิถุนายน 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
15:02:18 5 มิถุนายน 2561  :try to logon with: GS1WS
15:02:18 5 มิถุนายน 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
15:02:18 5 มิถุนายน 2561  :try to logon with: GS1WS
15:04:12 5 มิถุนายน 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
15:04:12 5 มิถุนายน 2561  :try to logon with: GS1WS
15:04:12 5 มิถุนายน 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
15:04:12 5 มิถุนายน 2561  :try to logon with: GS1WS
15:06:57 5 มิถุนายน 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
15:06:57 5 มิถุนายน 2561  :try to logon with: GS1WS
15:06:57 5 มิถุนายน 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
15:06:57 5 มิถุนายน 2561  :try to logon with: GS1WS
15:07:52 5 มิถุนายน 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
15:07:52 5 มิถุนายน 2561  :try to logon with: GS1WS
15:07:53 5 มิถุนายน 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
15:07:53 5 มิถุนายน 2561  :try to logon with: GS1WS
15:13:54 5 มิถุนายน 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
15:13:54 5 มิถุนายน 2561  :try to logon with: GS1WS
15:13:55 5 มิถุนายน 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
15:13:55 5 มิถุนายน 2561  :try to logon with: GS1WS
15:14:24 5 มิถุนายน 2561  :Server was unable to process request. ---> Cannot open database "RDtmp" requested by the login. The login failed.
15:16:59 5 มิถุนายน 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
15:16:59 5 มิถุนายน 2561  :try to logon with: GS1WS
15:16:59 5 มิถุนายน 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
15:16:59 5 มิถุนายน 2561  :try to logon with: GS1WS
15:36:48 5 มิถุนายน 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
15:36:48 5 มิถุนายน 2561  :try to logon with: GS1WS
15:36:48 5 มิถุนายน 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
15:36:48 5 มิถุนายน 2561  :try to logon with: GS1WS
15:40:37 5 มิถุนายน 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
15:40:37 5 มิถุนายน 2561  :try to logon with: GS1WS
15:40:37 5 มิถุนายน 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
15:40:37 5 มิถุนายน 2561  :try to logon with: GS1WS
15:43:24 5 มิถุนายน 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
15:43:24 5 มิถุนายน 2561  :try to logon with: GS1WS
15:43:24 5 มิถุนายน 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
15:43:24 5 มิถุนายน 2561  :try to logon with: GS1WS
15:52:00 5 มิถุนายน 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
15:52:00 5 มิถุนายน 2561  :try to logon with: GS1WS
15:52:00 5 มิถุนายน 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
15:52:00 5 มิถุนายน 2561  :try to logon with: GS1WS
15:52:24 5 มิถุนายน 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
15:52:24 5 มิถุนายน 2561  :try to logon with: GS1WS
15:52:24 5 มิถุนายน 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
15:52:24 5 มิถุนายน 2561  :try to logon with: GS1WS
15:55:21 5 มิถุนายน 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
15:55:21 5 มิถุนายน 2561  :try to logon with: GS1WS
15:55:22 5 มิถุนายน 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
15:55:22 5 มิถุนายน 2561  :try to logon with: GS1WS
15:57:44 5 มิถุนายน 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
15:57:44 5 มิถุนายน 2561  :try to logon with: GS1WS
15:57:45 5 มิถุนายน 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
15:57:45 5 มิถุนายน 2561  :try to logon with: GS1WS
15:59:26 5 มิถุนายน 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
15:59:26 5 มิถุนายน 2561  :try to logon with: GS1WS
15:59:26 5 มิถุนายน 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
15:59:26 5 มิถุนายน 2561  :try to logon with: GS1WS
15:59:43 5 มิถุนายน 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
15:59:43 5 มิถุนายน 2561  :try to logon with: GS1WS
15:59:43 5 มิถุนายน 2561  :getGS1changed=/*SELECT        MB_MEMBER.MEMBER_CODE, MB_PRENAME.PRENAME_TH, MB_COMP_PERSON.COMP_PERSON_NAME_TH, MB_PRENAME.PRENAME_EN, MB_COMP_PERSON.COMP_PERSON_NAME_EN, 
                         MB_COMP_PERSON.TAX_ID, MB_MEMBER.REGIST_DATE, MB_MEMBER.MEMBER_MAIN_TYPE_CODE, MB_MEMBER.MEMBER_TYPE_CODE, MB_MEMBER.MEMBER_STATUS_CODE, MB_MEMBER_RETIRE.APPROVE_DATE
FROM            MB_MEMBER INNER JOIN
                         MB_COMP_PERSON ON MB_MEMBER.COMP_PERSON_CODE = MB_COMP_PERSON.COMP_PERSON_CODE INNER JOIN
                         MB_MEMBER_RETIRE ON MB_MEMBER.REGIST_CODE = MB_MEMBER_RETIRE.REGIST_CODE LEFT OUTER JOIN
                         MB_PRENAME ON MB_COMP_PERSON.PREN_CODE = MB_PRENAME.PRENAME_CODE
WHERE        (MB_MEMBER.MEMBER_MAIN_GROUP_CODE = '300') AND (MB_MEMBER_RETIRE.APPROVE_DATE BETWEEN dbo.fnc_StrToDateTime(@YYYYMMDD_FROM + '000000') AND dbo.fnc_StrToDateTime(@YYYYMMDD_TO + '235959'))
ORDER BY MB_MEMBER_RETIRE.APPROVE_DATE*/

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

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

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

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

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

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

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

	insert into tempWsGs1_002
	select * from fnc_GetGS1MemberInfoForWebServiceByTaxID(@TAX_ID)

    set @currentRow = @currentRow +1
end  

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

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

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

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

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

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

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

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

	insert into tempWsGs1_002
	select * from fnc_GetGS1MemberInfoForWebServiceByTaxID(@TAX_ID)

    set @currentRow = @currentRow +1
end  

drop table tempWsGs1_001
select * from tempWsGs1_002
drop table tempWsGs1_002
15:59:43 5 มิถุนายน 2561  :There is already an object named 'tempWsGs1_001' in the database.
16:00:52 5 มิถุนายน 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
16:00:52 5 มิถุนายน 2561  :try to logon with: GS1WS
16:00:52 5 มิถุนายน 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
16:00:52 5 มิถุนายน 2561  :try to logon with: GS1WS
16:22:34 5 มิถุนายน 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
16:22:34 5 มิถุนายน 2561  :try to logon with: GS1WS
16:22:35 5 มิถุนายน 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
16:22:35 5 มิถุนายน 2561  :try to logon with: GS1WS
16:23:16 5 มิถุนายน 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
16:23:16 5 มิถุนายน 2561  :try to logon with: GS1WS
16:23:17 5 มิถุนายน 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
16:23:17 5 มิถุนายน 2561  :try to logon with: GS1WS
16:25:10 5 มิถุนายน 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
16:25:10 5 มิถุนายน 2561  :try to logon with: GS1WS
16:25:10 5 มิถุนายน 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
16:25:10 5 มิถุนายน 2561  :try to logon with: GS1WS
16:28:16 5 มิถุนายน 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
16:28:16 5 มิถุนายน 2561  :try to logon with: GS1WS
16:28:16 5 มิถุนายน 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
16:28:16 5 มิถุนายน 2561  :try to logon with: GS1WS
16:31:15 5 มิถุนายน 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
16:31:15 5 มิถุนายน 2561  :try to logon with: GS1WS
16:31:15 5 มิถุนายน 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
16:31:15 5 มิถุนายน 2561  :try to logon with: GS1WS
16:31:40 5 มิถุนายน 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
16:31:40 5 มิถุนายน 2561  :try to logon with: GS1WS
16:31:41 5 มิถุนายน 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
16:31:41 5 มิถุนายน 2561  :try to logon with: GS1WS
16:31:43 5 มิถุนายน 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
16:31:43 5 มิถุนายน 2561  :try to logon with: GS1WS
16:31:43 5 มิถุนายน 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
16:31:43 5 มิถุนายน 2561  :try to logon with: GS1WS
16:31:54 5 มิถุนายน 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
16:31:54 5 มิถุนายน 2561  :try to logon with: GS1WS
16:31:54 5 มิถุนายน 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
16:31:54 5 มิถุนายน 2561  :try to logon with: GS1WS
16:32:06 5 มิถุนายน 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
16:32:06 5 มิถุนายน 2561  :try to logon with: GS1WS
16:32:06 5 มิถุนายน 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
16:32:06 5 มิถุนายน 2561  :try to logon with: GS1WS
16:32:37 5 มิถุนายน 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
16:32:37 5 มิถุนายน 2561  :try to logon with: GS1WS
16:32:38 5 มิถุนายน 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
16:32:38 5 มิถุนายน 2561  :try to logon with: GS1WS
16:42:36 5 มิถุนายน 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
16:42:36 5 มิถุนายน 2561  :try to logon with: GS1WS
16:42:37 5 มิถุนายน 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
16:42:37 5 มิถุนายน 2561  :try to logon with: GS1WS
16:42:44 5 มิถุนายน 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
16:42:44 5 มิถุนายน 2561  :try to logon with: GS1WS
16:42:45 5 มิถุนายน 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
16:42:45 5 มิถุนายน 2561  :try to logon with: GS1WS
16:43:11 5 มิถุนายน 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
16:43:11 5 มิถุนายน 2561  :try to logon with: GS1WS
16:43:11 5 มิถุนายน 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
16:43:11 5 มิถุนายน 2561  :try to logon with: GS1WS
16:44:15 5 มิถุนายน 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
16:44:15 5 มิถุนายน 2561  :try to logon with: GS1WS
16:44:15 5 มิถุนายน 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
16:44:15 5 มิถุนายน 2561  :try to logon with: GS1WS
16:44:25 5 มิถุนายน 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
16:44:25 5 มิถุนายน 2561  :try to logon with: GS1WS
16:44:25 5 มิถุนายน 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
16:44:25 5 มิถุนายน 2561  :try to logon with: GS1WS
16:44:46 5 มิถุนายน 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
16:44:46 5 มิถุนายน 2561  :try to logon with: GS1WS
16:44:47 5 มิถุนายน 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
16:44:47 5 มิถุนายน 2561  :try to logon with: GS1WS
16:56:14 5 มิถุนายน 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
16:56:14 5 มิถุนายน 2561  :try to logon with: GS1WS
16:56:14 5 มิถุนายน 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
16:56:14 5 มิถุนายน 2561  :try to logon with: GS1WS
16:58:18 5 มิถุนายน 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
16:58:18 5 มิถุนายน 2561  :try to logon with: GS1WS
16:58:18 5 มิถุนายน 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
16:58:18 5 มิถุนายน 2561  :try to logon with: GS1WS
16:59:44 5 มิถุนายน 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
16:59:44 5 มิถุนายน 2561  :try to logon with: GS1WS
16:59:44 5 มิถุนายน 2561  :getGS1changed=/*SELECT        MB_MEMBER.MEMBER_CODE, MB_PRENAME.PRENAME_TH, MB_COMP_PERSON.COMP_PERSON_NAME_TH, MB_PRENAME.PRENAME_EN, MB_COMP_PERSON.COMP_PERSON_NAME_EN, 
                         MB_COMP_PERSON.TAX_ID, MB_MEMBER.REGIST_DATE, MB_MEMBER.MEMBER_MAIN_TYPE_CODE, MB_MEMBER.MEMBER_TYPE_CODE, MB_MEMBER.MEMBER_STATUS_CODE, MB_MEMBER_RETIRE.APPROVE_DATE
FROM            MB_MEMBER INNER JOIN
                         MB_COMP_PERSON ON MB_MEMBER.COMP_PERSON_CODE = MB_COMP_PERSON.COMP_PERSON_CODE INNER JOIN
                         MB_MEMBER_RETIRE ON MB_MEMBER.REGIST_CODE = MB_MEMBER_RETIRE.REGIST_CODE LEFT OUTER JOIN
                         MB_PRENAME ON MB_COMP_PERSON.PREN_CODE = MB_PRENAME.PRENAME_CODE
WHERE        (MB_MEMBER.MEMBER_MAIN_GROUP_CODE = '300') AND (MB_MEMBER_RETIRE.APPROVE_DATE BETWEEN dbo.fnc_StrToDateTime(@YYYYMMDD_FROM + '000000') AND dbo.fnc_StrToDateTime(@YYYYMMDD_TO + '235959'))
ORDER BY MB_MEMBER_RETIRE.APPROVE_DATE*/

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

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

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

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

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

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

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

	insert into tempWsGs1_002
	select * from fnc_GetGS1MemberInfoForWebServiceByTaxID(@TAX_ID)

    set @currentRow = @currentRow +1
end  

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

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

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

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

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

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

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

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

	insert into tempWsGs1_002
	select * from fnc_GetGS1MemberInfoForWebServiceByTaxID(@TAX_ID)

    set @currentRow = @currentRow +1
end  

drop table tempWsGs1_001
select * from tempWsGs1_002
drop table tempWsGs1_002
16:59:46 5 มิถุนายน 2561  :There is already an object named 'tempWsGs1_001' in the database.
16:59:52 5 มิถุนายน 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
16:59:52 5 มิถุนายน 2561  :try to logon with: GS1WS
16:59:52 5 มิถุนายน 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
16:59:52 5 มิถุนายน 2561  :try to logon with: GS1WS
17:01:17 5 มิถุนายน 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
17:01:17 5 มิถุนายน 2561  :try to logon with: GS1WS
17:01:17 5 มิถุนายน 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
17:01:17 5 มิถุนายน 2561  :try to logon with: GS1WS
17:01:28 5 มิถุนายน 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
17:01:28 5 มิถุนายน 2561  :try to logon with: GS1WS
17:01:28 5 มิถุนายน 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
17:01:28 5 มิถุนายน 2561  :try to logon with: GS1WS
17:01:47 5 มิถุนายน 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
17:01:47 5 มิถุนายน 2561  :try to logon with: GS1WS
17:01:51 5 มิถุนายน 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
17:01:51 5 มิถุนายน 2561  :try to logon with: GS1WS
17:06:18 5 มิถุนายน 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
17:06:18 5 มิถุนายน 2561  :try to logon with: GS1WS
17:06:36 5 มิถุนายน 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
17:06:36 5 มิถุนายน 2561  :try to logon with: GS1WS
17:06:53 5 มิถุนายน 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
17:06:53 5 มิถุนายน 2561  :try to logon with: GS1WS
17:06:54 5 มิถุนายน 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
17:06:54 5 มิถุนายน 2561  :try to logon with: GS1WS
17:10:31 5 มิถุนายน 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
17:10:31 5 มิถุนายน 2561  :try to logon with: GS1WS
17:10:31 5 มิถุนายน 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
17:10:31 5 มิถุนายน 2561  :try to logon with: GS1WS
17:15:14 5 มิถุนายน 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
17:15:14 5 มิถุนายน 2561  :try to logon with: GS1WS
17:15:15 5 มิถุนายน 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
17:15:15 5 มิถุนายน 2561  :try to logon with: GS1WS
17:17:49 5 มิถุนายน 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
17:17:49 5 มิถุนายน 2561  :try to logon with: GS1WS
17:17:49 5 มิถุนายน 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
17:17:49 5 มิถุนายน 2561  :try to logon with: GS1WS
17:21:13 5 มิถุนายน 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
17:21:13 5 มิถุนายน 2561  :try to logon with: GS1WS
17:21:14 5 มิถุนายน 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
17:21:14 5 มิถุนายน 2561  :try to logon with: GS1WS
17:59:44 5 มิถุนายน 2561  :Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
17:59:44 5 มิถุนายน 2561  :try to logon with: GS1WS
17:59:44 5 มิถุนายน 2561  :getGS1changed=/*SELECT        MB_MEMBER.MEMBER_CODE, MB_PRENAME.PRENAME_TH, MB_COMP_PERSON.COMP_PERSON_NAME_TH, MB_PRENAME.PRENAME_EN, MB_COMP_PERSON.COMP_PERSON_NAME_EN, 
                         MB_COMP_PERSON.TAX_ID, MB_MEMBER.REGIST_DATE, MB_MEMBER.MEMBER_MAIN_TYPE_CODE, MB_MEMBER.MEMBER_TYPE_CODE, MB_MEMBER.MEMBER_STATUS_CODE, MB_MEMBER_RETIRE.APPROVE_DATE
FROM            MB_MEMBER INNER JOIN
                         MB_COMP_PERSON ON MB_MEMBER.COMP_PERSON_CODE = MB_COMP_PERSON.COMP_PERSON_CODE INNER JOIN
                         MB_MEMBER_RETIRE ON MB_MEMBER.REGIST_CODE = MB_MEMBER_RETIRE.REGIST_CODE LEFT OUTER JOIN
                         MB_PRENAME ON MB_COMP_PERSON.PREN_CODE = MB_PRENAME.PRENAME_CODE
WHERE        (MB_MEMBER.MEMBER_MAIN_GROUP_CODE = '300') AND (MB_MEMBER_RETIRE.APPROVE_DATE BETWEEN dbo.fnc_StrToDateTime(@YYYYMMDD_FROM + '000000') AND dbo.fnc_StrToDateTime(@YYYYMMDD_TO + '235959'))
ORDER BY MB_MEMBER_RETIRE.APPROVE_DATE*/

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

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

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

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

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

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

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

	insert into tempWsGs1_002
	select * from fnc_GetGS1MemberInfoForWebServiceByTaxID(@TAX_ID)

    set @currentRow = @currentRow +1
end  

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

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

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

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

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

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

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

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

	insert into tempWsGs1_002
	select * from fnc_GetGS1MemberInfoForWebServiceByTaxID(@TAX_ID)

    set @currentRow = @currentRow +1
end  

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

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

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

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

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

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

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

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

	insert into tempWsGs1_002
	select * from fnc_GetGS1MemberInfoForWebServiceByTaxID(@TAX_ID)

    set @currentRow = @currentRow +1
end  

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

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

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

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

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

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

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

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

	insert into tempWsGs1_002
	select * from fnc_GetGS1MemberInfoForWebServiceByTaxID(@TAX_ID)

    set @currentRow = @currentRow +1
end  

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

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

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

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

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

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

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

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

	insert into tempWsGs1_002
	select * from fnc_GetGS1MemberInfoForWebServiceByTaxID(@TAX_ID)

    set @currentRow = @currentRow +1
end  

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

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

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

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

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

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

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

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

	insert into tempWsGs1_002
	select * from fnc_GetGS1MemberInfoForWebServiceByTaxID(@TAX_ID)

    set @currentRow = @currentRow +1
end  

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

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

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

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

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

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

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

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

	insert into tempWsGs1_002
	select * from fnc_GetGS1MemberInfoForWebServiceByTaxID(@TAX_ID)

    set @currentRow = @currentRow +1
end  

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

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

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

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

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

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

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

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

	insert into tempWsGs1_002
	select * from fnc_GetGS1MemberInfoForWebServiceByTaxID(@TAX_ID)

    set @currentRow = @currentRow +1
end  

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

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

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

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

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

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

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

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

	insert into tempWsGs1_002
	select * from fnc_GetGS1MemberInfoForWebServiceByTaxID(@TAX_ID)

    set @currentRow = @currentRow +1
end  

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

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

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

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

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

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

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

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

	insert into tempWsGs1_002
	select * from fnc_GetGS1MemberInfoForWebServiceByTaxID(@TAX_ID)

    set @currentRow = @currentRow +1
end  

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

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

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

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

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

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

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

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

	insert into tempWsGs1_002
	select * from fnc_GetGS1MemberInfoForWebServiceByTaxID(@TAX_ID)

    set @currentRow = @currentRow +1
end  

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

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

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

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

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

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

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

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

	insert into tempWsGs1_002
	select * from fnc_GetGS1MemberInfoForWebServiceByTaxID(@TAX_ID)

    set @currentRow = @currentRow +1
end  

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

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

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

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

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

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

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

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

	insert into tempWsGs1_002
	select * from fnc_GetGS1MemberInfoForWebServiceByTaxID(@TAX_ID)

    set @currentRow = @currentRow +1
end  

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

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

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

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

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

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

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

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

	insert into tempWsGs1_002
	select * from fnc_GetGS1MemberInfoForWebServiceByTaxID(@TAX_ID)

    set @currentRow = @currentRow +1
end  

drop table tempWsGs1_001
select * from tempWsGs1_002
drop table tempWsGs1_002
23:59:43 5 มิถุนายน 2561  :There is already an object named 'tempWsGs1_001' in the database.