In Progress

SQL Procedure \ Function Help

I need some helps on sql server 2008. I have a hard time to figure out how to get back the data as I want.

The multiple ids in people field are stored in the same rows and seperated by pile(|),

Jobs column are doing the same.

I know It doesn't look right on database design, but the datatable is provided by 3rd parties,

so I have no choose to modify it.

I believe I need a store procedure\function or some sql server special function to do that

this is my tables

*Helpdesk Table

id People Jobs

-------------------------------------------------------------

100 1|2 7|8|9

*People Table

id FullName

-----------------------------------------------------

1 Nick

2 John

*Jobs Table

id JobName

-----------------------------------------------------

7 Software

8 Hardware

9 Network

So, I want to select the data like this way and return the data like this:

select id, ConvertFunc(People,'id','FullName') as NewPeople, ConvertFunc(Jobs,'id','JobName') as NewJobs from helpdesk

and return:

id NewPeople NewJobs

------------------------------------------------------

100 Nick, John Software, Hardware, Network

Skills: SQL

See more: t sql jobs, network jobs, need sql help, jobs that help people, jobs id, database design jobs, column jobs, choose help, on sql, nick t, it helpdesk jobs, hardware jobs, sql software, helpdesk it, get sql help, function, database design sql, function stored procedure, sql stored function, stored procedure function, function design, sql select select, help modify, sql select, function time

About the Employer:
( 64 reviews ) las vegas, United States

Project ID: #881548

Awarded to:

emmett25ro

Hello, I will do this for you, please see PM. Regards, Emmett

$30 USD in 1 day
(2 Reviews)
1.8

38 freelancers are bidding on average $53 for this job

AlosDeveloper

Hello, please check PMB

$55 USD in 1 day
(28 Reviews)
6.1
djain01

Hi, Lets start it. SQL Expert is here. Thanks, djain

$50 USD in 0 days
(15 Reviews)
4.6
supportitremote

It is easy task for us, please check PMB for more details. Thanks

$40 USD in 1 day
(2 Reviews)
4.4
servicebenq

Hi Please see your PM. Thanks

$40 USD in 0 days
(10 Reviews)
4.2
rakib062

hi, I am a professional database administrator in oracle and sql. I have also completed several projects in freelancer relating database. I am ready to start right now. waiting for your reply. thanks

$40 USD in 2 days
(8 Reviews)
4.2
crajeshbe

Hi Good day, SQL 2005/2008 Developer Bid. Ready to start the work. Regards C.Rajesh

$100 USD in 2 days
(9 Reviews)
4.1
dkirby9172

Please see PMB

$75 USD in 1 day
(1 Review)
3.3
ghikmawan

Please check PM, thank you

$30 USD in 0 days
(2 Reviews)
2.3
freelancerbuzzo

Ready to start right now.

$60 USD in 1 day
(2 Reviews)
2.0
japaj

Please check PM.

$30 USD in 1 day
(1 Review)
1.7
WaseemSh

Hello, I'm Interested in this assignment, please check pm for details

$30 USD in 1 day
(1 Review)
1.2
siftikhar

I can give you the script for this.

$30 USD in 1 day
(1 Review)
1.0
mneo

Easy, please contact me via PMB for a sample. Thanks

$30 USD in 0 days
(4 Reviews)
1.0
krVasanth

It is very simple to solve your problem

$40 USD in 1 day
(0 Reviews)
0.0
zolutionstech

Hello, I'm Interested in this assignment

$30 USD in 1 day
(0 Reviews)
0.0
bmircea

Please check PM

$80 USD in 0 days
(0 Reviews)
0.0
mtluan

Hello! I have extensive programming background with c#,vb.net,Java,SQL server,oracle ..; with 4 years experience in ADO.net, I can perform your job in a short time, hope to cooperate with you thanks

$30 USD in 1 day
(0 Reviews)
0.0
akovalev

Hello 2 hours

$30 USD in 1 day
(0 Reviews)
0.0
anjanece

sql function or procedure

$100 USD in 5 days
(0 Reviews)
0.0
jtsagara

Too easy I think... MSSQL,Oracle,Mysql Developer

$30 USD in 1 day
(0 Reviews)
0.0