เรื่อง database split คำออกจาก column เดียวกับ ไปอยู่ อีก table นึง

Create function fnMaxAddress(@value varchar(max)) returns @result table
	 (
    ip    varchar(30),
    mac_address   varchar(30)
   )
 as
 begin
 declare @index int
declare @ip varchar(max)
set @index = CHARINDEX('dvc=',@value)
set @ip= ltrim(substring(@value,@index+4,len(@value)))
insert into @result
select substring(@ip,1,CHARINDEX(' ',@ip)),
ltrim(replace(substring(@ip,CHARINDEX(' ',@ip),len(@ip)),'deviceMacAddress=',''))

 return 
 end;
 

 declare @value varchar(max) = 'CEF:0|Trend Micro|Deep Discovery Inspector|3.7.1096|100101|Web 
Reputation Services detected a malicious URL request|6|dvc=192.168.103.232 deviceMacAddress=
84:8F:69:E8:E4:BE';

select ip,mac_address from fnMaxAddress(@value)
 --192.168.103.232 	  84:8F:69:E8:E4:BE

CREATE TABLE [dbo].[macaddress](
	[ip] [varchar](50) NULL,
	[mac_address] [varchar](50) NULL
)

insert into macaddress 
SELECT s.ip,s.mac_address FROM customers1 AS t CROSS APPLY dbo.fnMaxAddress(t.txtip) AS s;

Create function fnMaxAddress(@value varchar(max)) returns @result table
	 (
    ip    varchar(30),
    mac_address   varchar(30)
   )
 as
 begin
 declare @index int
declare @ip varchar(max)
set @index = CHARINDEX('dvc=',@value)
set @ip= ltrim(substring(@value,@index+4,len(@value)))
insert into @result
select substring(@ip,1,CHARINDEX(' ',@ip)),
ltrim(replace(substring(@ip,CHARINDEX(' ',@ip),len(@ip)),'deviceMacAddress=',''))

 return 
 end;