Käynnissä

Stored Procedure

SQL Server 2005

I have data in 3 tables – Sopa, SopaProjectType and ProjectType.

Sopa table contains the information about jobs. Each job may be without any type assigned, may have just one type assigned or may have more than one type assigned.

I would ask you to write a stored procedure which will give all jobs (distinct, one job must be presented ones in the return) with their types: If no job type was assigned to the job then the field has an empty string, if just one type was assigned then the field JobType has to have the Job Type taken from ProjectType table, and if more than ONE type was assigned to the job then there should be just the word MULTIPLE.

I populated the table _RequiredResult with the data I created manually, The stored procedure you create must return exact the same data as you see in the table. The stored procedure must be compatible with SQL Server 2005 and later. So, do not use any features existing in newer than 2005 versions.

I attached the database which was created in SQL Server 2008. Do not ask me to give you the script for the database or any other materials.

Taidot: PHP, tietojärjestelmäarkkitehtuuri, SQL

Näytä lisää: stored, word database sql, stored procedure create sql, sql stored, database procedure, sql multiple tables, create table script sql, empty existing database, write stored procedure sql, tables stored sql, sql job type, php create table word, sql stored procedure table, jobs sql, database tables jobs, sql table procedure, php sql jobs, return table stored procedure, script write sql server, write sql script, stored procedure script sql, sql procedure return, sql procedure, sql procedure return table, stored return table

About the Employer:
( 12 reviews ) United States

Projektin tunnus: #4296256

Myönnetty käyttäjälle:

danielbarragan13

I've got the skills needed to complete your project ASAP. Please view PM for sample.

30 $ USD 0 päivässä
(1 arvostelu)
1.1

20 freelanceria on tarjonnut keskimäärin 42 $ tähän työhön

w3bexpert

We have gone through your project requirements and are willing to work on this project. Please check PMB. Thanks

30 $ USD 0 päivässä
(63 arvostelua)
6.0
siberiangirl

Hello, I'm interested in your project. Would like to help. >if more than ONE type was assigned to the job then there should be just the word MULTIPLE. It's no problem. I can even indicate type comma delimeted Lisää

50 $ USD 2 päivässä
(131 arvostelua)
5.9
arvin8

Hi, I am a +10 year experienced visual communication designer specialised in web design and development. I hold 2 B.As in Visual Communication Design and Advertising Design separately. I don't bid on every p Lisää

50 $ USD 2 päivässä
(8 arvostelua)
5.8
cheapexcell

Will be done in a few hours.

40 $ USD 0 päivässä
(98 arvostelua)
5.6
thanhlongfree

Hi. I have gone through your requirements. It's easy for me.

30 $ USD 1 päivässä
(13 arvostelua)
5.0
manhpham

I am ready to help you. Pls contact me

50 $ USD 1 päivässä
(20 arvostelua)
4.6
nibiranijum

Hi, I am database expert with more than 5 years of experience in sql, pl/sql. I did lots of related projects. Rgds, Shafiq

45 $ USD 2 päivässä
(13 arvostelua)
3.8
feninsoftech

Hi, I can write SP based on your requirement. I have 8 years experience in SQL Server development.

50 $ USD 2 päivässä
(3 arvostelua)
3.5
hcy0212

Hi vladich, I am glad to help you to create the stored procedure. There was a question regarding the database file you provided, please check the PMB for my additional question. Sincerely yours, John

40 $ USD 1 päivässä
(4 arvostelua)
3.3
pramodv

I have very good knowledge of database development using SQL Server and MySql.

35 $ USD 1 päivässä
(14 arvostelua)
3.2
Dusan74

Hi, I am SQL developer with 10+ years of experience. Details of implementation are in the PM. Thanks!

30 $ USD 1 päivässä
(4 arvostelua)
2.5
igorfreelancer

hi vladich! I'm an expert coder and sql administrator. This procedure will be no problem. You will get the results exactly as in your example, fast and accurate! Thanks!

50 $ USD 1 päivässä
(1 arvostelu)
2.4
neelesh02784

Hi Please check my private mesaage... Thanks & Regards Neelesh

80 $ USD 1 päivässä
(0 arvostelua)
0.0
andygeek

Will be done in a few minutes

30 $ USD 1 päivässä
(0 arvostelua)
0.0
anomanpk

I would like to offer my services for this job.

50 $ USD 1 päivässä
(0 arvostelua)
0.0
tarrc

Will use TSQL to write the full stored procedured. I will document each part so you can understand how it works.

40 $ USD 1 päivässä
(0 arvostelua)
0.0
thegoldmoon

I am a microsoft SME and have 5 years working as a microsoft vendor. I have a full time job in an Indian MNC dealing with US projects. And I can finish the work with minimal information from you. This procedure wi Lisää

40 $ USD 2 päivässä
(0 arvostelua)
0.0
prasjos1990

Hey vladich, I am a Microsoft certified technology specialist in .NET 4.0 and SQL server 2008. I have vast experience when it comes to SQL server as i manage a huge data migration project containing more the 100 ta Lisää

30 $ USD 1 päivässä
(0 arvostelua)
0.0
professionalws

I can (and want to) start immediately!

30 $ USD 0 päivässä
(0 arvostelua)
0.0