Como posso inserir uma string dividida múltipla na consulta de inserção única

0

crie a tabela a seguir

Declare @APS nvarchar(1000)='1,1,1.5,1.791'
,@cluster nvarchar(1000)='0150,0150,001,0382'
,@style nvarchar(1000)='696707-018,696707-018,696707-018,696707-018'


CREATE TABLE #temptable (
ID int IDENTITY (1, 1) NOT NULL ,
stylecolor varchar (500) NOT NULL ,
APSDev varchar (250)  NULL,
ClusterID varchar(1000) Null
)

Aqui eu preciso inserir valores

Insert into #temptable  (stylecolor, ClusterID, APSDev)
select  item  from  [<table name>]. dbo.SplitString(@style,',') 
select  item  from  [<table name>].dbo.SplitString(@cluster,',')
select  item  from  [<table name>]. dbo.SplitString(@APS,',')

Obtendo erro:

The select list for the INSERT statement contains fewer items than the 
insert list. The number of SELECT values must match the number of INSERT 
columns.
    
por sravas 02.05.2018 / 19:03

0 respostas

Tags