String Split not working - not enough arguments

Christopher Jack 1,616

Hi,

I am trying to insert a string results into a temp table using the following

create table #Temp
(
sku nvarchar(400)
)
insert #Temp(sku)
SELECT value
from STRING_SPLIT (@sku2, ',')

However I am getting the following error when I highlight string_split - an insufficient nummber of arguments where supplied for for the function String_split .

Thanks

Chris

Viorel 127K Reputation points

2022-03-04T13:40:31.127+00:00

If it works, I think that you can ignore this issue.
Yitzhak Khabinsky 27,196 Reputation points

2022-03-04T13:47:45.137+00:00

While asking a question you need to provide a minimal reproducible example:
(1) DDL and sample data population, i.e. CREATE table(s) plus INSERT, T-SQL statements.
(2) What you need to do, i.e. logic, and your attempt implementation of it in T-SQL.
(3) Desired output based on the sample data in the #1 above.
(4) Your SQL Server version (SELECT @@version;)

Answer accepted by question author

Tom Phillips 17,786

That is just a warning from Intelisense in SSMS. It can be ignored. I hope it gets fixed soon.

0 comments

5 additional answers

Christopher Jack 1,616 Reputation points

2022-03-07T10:36:40.99+00:00

Thanks, it seems to be because it was reading the variable in.. it was a intellisense issue.

Thanks

Chris
Was this answer helpful?

0 comments No comments
Sign in to comment

Use comments to ask for clarification, additional information, or improvements to the question.

Share via

String Split not working - not enough arguments

5 additional answers

Your answer