SQL Stored Procedure that reads comma separated string

$10-30 USD

Completed

Posted about 7 years ago

$10-30 USD

Paid on delivery

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

Database Programming

Microsoft SQL Server

Software Architecture

SQL

Project ID: 19503132

About the project

8 proposals

Remote project

Active 7 yrs ago

Looking to make some money?

Email address

Benefits of bidding on Freelancer

Set your budget and timeframe

Get paid for your work

Outline your proposal

It's free to sign up and bid on jobs

Awarded to:

@Buckner

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 in 1 day

0.0

(0 reviews)

0.0

@gurramsunitha

 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 2014/2012/2008R2/2008, SSAS, SSIS, SSRS and TSQL.  Over 2yrs of Canadian Experience in working with Client team and Vendors.  Extensive experience in Database development for OLAP Systems (SSAS, SSIS, SSRS) using SQL Server 2016/2014/2012/2008R2/2008.  Extensive experience in Analysis services development (both star and snow flake schemas) of multi-dimensional models and tabular models using SQL Server 2014/2012/2008R2/2008.  Extensive ETL experience using SSIS for Data Extractions, Transformations and Loads.  Extensive experience in providing Enterprise Reporting solutions using SSRS 2014/2012/2008R2/2008.  Hands on experience in all phases of SDLC (software development life cycle) and SCRUM involving Requirement analysis, Software design, development, implementation, testing, maintenance.

$20 USD in 1 day

0.0

(0 reviews)

0.0

8 freelancers are bidding on average $23 USD for this job

@sreenivas2903

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 in 1 day

4.9

(15 reviews)

4.2

@BestService222

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 with good collaboration. Awaiting for an affirmative response from your end. Thanks

$25 USD in 1 day

4.4

(9 reviews)

4.1

@fzk1990

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 and persistent. Please contact me on chat so we can discuss further details. Thanks

$25 USD in 7 days

5.0

(2 reviews)

1.2

@LucaLumetti

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 in 1 day

0.0

(0 reviews)

0.0

@vineethvv

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. Please contact me we can discuss further.

$15 USD in 1 day