有两个表:
tb1:
ID var_details
=================================
001 Q-1538,Q-0141,Q-1328,Q-1981,
002 Q-1322,Q-1193,tb2:
ID HRID
==========现在想要将tb1的资料拆分后Insert tb2中,如下:
ID HRID
===========
001 Q-1538
001 Q-0141
001 Q-1328
001 Q-1981
002 Q-1322
002 Q-1193
...
tb1:
ID var_details
=================================
001 Q-1538,Q-0141,Q-1328,Q-1981,
002 Q-1322,Q-1193,tb2:
ID HRID
==========现在想要将tb1的资料拆分后Insert tb2中,如下:
ID HRID
===========
001 Q-1538
001 Q-0141
001 Q-1328
001 Q-1981
002 Q-1322
002 Q-1193
...
set @sql=''
CREATE TABLE #AA(ID nvarchar(10),var_details nvarchar(50))
SELECT @sql=@sql+'union select N'''+ID+''','''+replace(var_details,',',''' union select N'''+ID+''',''') +'''' +char(13)+char(10) FROM tb1
select @sql=stuff(@sql,1,6,'')
insert into #aa exec(@sql)select * from #aa
set @sql = ''
declare @table varchar(4),@fields varchar(1000)
declare Cur_test cursor for
Conversion failed when converting the varchar value '','' to data type int.
Conversion failed when converting the varchar value '','' to data type int.