sql server stored procedure - collection of data for fields as input I have a stored procedure to add a collection of values to a field in table.
How I implement it now:
from my .net app, I create a string of comma separated values from an array( eg: resource1, recource2, resoource3...). This string is then send to stored procedure, where it is split and each value is inserted into a table.
my code below
ALTER PROCEDURE  [dbo].[resourcetrackerupdate]
@resources varchar(max)

as begin

SET NOCOUNT ON;


DECLARE @MyCursor CURSOR;
DECLARE @ReourceName varchar(max);
BEGIN
    SET @MyCursor = CURSOR FOR
    select [name]  from dbo.splitstring(@resources)

    OPEN @MyCursor 
    FETCH NEXT FROM @MyCursor 
    INTO @ResourceName

    WHILE @@FETCH_STATUS = 0
    BEGIN


            BEGIN TRY
                INSERT INTO resourcetracker ([ResourceName]) VALUES (@ResourceName)
             END TRY
            BEGIN CATCH
    
             END CATCH 
      FETCH NEXT FROM @MyCursor 
      INTO @ResourceName
    END; 

    CLOSE @MyCursor ;
    DEALLOCATE @MyCursor;
END;

Now, my requirement is that I need to send multiple field data (as opposed to just one - resourcename - now). So , I will need to send resourcename, resourcesize, assignedto etc to stored procedure to insert into the table as new records.
FYI, these arrays are size of few thousands records.
The long comma separated string approach might not work anymore. How can I change my stored procedure to process all that data?
One of the drive is the source, because that could define the best way.
Now, i will assume there is some internal logic to the procedure.
Possibilities:

send it as json/xml and parse it using MSSQL functions
send it as a table valuable
place it into a temporar table and process it in procedure