SQL Stored Procedure that reads comma separated string

I need a stored Procedure for MS SQL 2016 that can take a parameter of a PersonID and a comma separated string I want to procedure take the ID and string like "6657155,25637603,25368431,24385586,6497246,25855746"

The Select statement needs to call the column to see what values are already in the system such as Select Pending from Publications where PersonID = @PersonID

Pending will be 6657155,25637603,25368431,24385586 and I want a string to update a column with values that are not in the original string

@CVS = 6497246,25855746

UPDATE Publications

SET Queue = @CSV

Where PersonID = @PersonID

Evner: Programmering af database, Microsoft SQL Server, Software Arkitektur, SQL

Se mere: parse comma separated values within worksheet, oscommerce import comma separated, categories product comma separated sql, how to split comma separated string and pass to in clause of select statement in sql server, using comma separated value parameter strings in sql in clauses, pass comma separated string to stored procedure c#, split comma separated string in sql server 2012, sql split string, sql split string into words, sql split string by character, how to pass comma separated values to stored procedure in oracle, comma separated file sql express, add comma separated values sql server, array_unique convert array comma separated string php, Specification 1. The program should read the data that is contained in a comma-separated text file and store the information in , how to split comma separated values in sql query, ruby create comma separated string from array, sql stuff comma separated list, python parse comma separated string, json array to comma separated string javascript

Om arbejdsgiveren:
( 176 bedømmelser ) Charleston, United States

Projekt ID: #19503132

Tildelt til:


Hello, I can write this sproc for you in an hour. I have something very similar already written for another project. Thanks, Buckner

$30 USD på 1 dag
(0 bedømmelser)

 Over 7 years of IT experience in various domains as Developer that includes Database Design and Development, Microsoft BI Solutions, ETL Development, Data warehouse Implementation, Report Development using SQL Server Flere

$20 USD på 1 dag
(0 bedømmelser)

8 freelancere byder i gennemsnit $23 på dette job


Hi. Iam expertise in sql query and logical programming if you are interested i will complete quickly with ur requirment if u are really looking for it ping me

$35 USD på 1 dag
(15 bedømmelser)

Hi There, I am interested in your project. No worry your project. If you give me an opportunity to discuss further then I will do my best for you As I am a full-stack freelancer, I am sure that I can work with you Flere

$25 USD på 1 dag
(9 bedømmelser)

Hi, I am writing this after reviewed your project description. I am interested in your project and Kindly drop a message so we can discuss. • Overall 7+ years of experience in Software Development Projects. • Ov Flere

$10 USD in 0 dage
(2 bedømmelser)

Hi there! I can get this stored procedure done for you, I am a fulltime DBA at a private company as well. You can also view my profile and see previous employers' reviews which suggest that I'm hardworking, consistent Flere

$25 USD in 7 dage
(2 bedømmelser)

I'm a computer engineering student and i used SQL for a long time. I've made a lot of SQL Stored Procedure and complete your request in some hours

$20 USD på 1 dag
(0 bedømmelser)

Hi, I have 5+ years of experience in dotnet web development. I am a full stack developer. I have worked with various clients including GE and Intel. I can help you with your work. Please look into my profile. Flere

$15 USD på 1 dag
(0 bedømmelser)