Need an SQL query built

$10-30 CAD

Abgeschlossen

Veröffentlicht

vor mehr als 9 Jahren

$10-30 CAD

Bezahlt bei Lieferung

I need an SQL query written that works. I have two main tables with a joining table. One table has all of the main records, the second table has categories that the main records would be associated with. the link table. The joining table has entries with IDs from both the categories, and the main records, and it builds associations (main record id 2, to category id 245 as an example) I want to build a query that outputs all of the main records, with all of the categories for each row of the main records, as some rows can have many categories. What I would love it to do is output them in a delimited fashion so that I can keep it to one row per main record ex: ID | Name | Category ------------------------------------- 2 | thing | shiny,special,explosive I will provide sample data from each of the database tables that need to be referenced.

Microsoft SQL Server

Projekt-ID: 6374156

Über das Projekt

15 Vorschläge

Remote Projekt

Aktiv vor 10 Jahren

Möchten Sie etwas Geld verdienen?

E-Mail-Adresse

Vorteile einer Ausschreibung auf Freelancer

Legen Sie Ihr Budget und Ihren Zeitrahmen fest

Für Ihre Arbeit bezahlt werden

Skizzieren Sie Ihren Vorschlag

Sie können sich kostenlos anmelden und auf Aufträge bieten

Vergeben an:

@Texnomic

Dear Sir, I'm a Certified Microsoft SQL Server Developer. The SQL Query you requested needs a special T-SQL code which I already had wrote before. This query will take few minutes to writes (may be 1 hour max. in case we need to study tables relations). Note: We can start working right now if you are online and ready.

$20 CAD in 0 Tag

5,0

(1 Bewertung)

0,3

15 Freelancer bieten im Durchschnitt $22 CAD für diesen Auftrag

@mpalgeo

Hi i can do id , just send me the data and i will provide you the query, after you test the query i will write an SSIS package for the output to o csv file. i will give 5 hours free support for the next two months as a guarantee for my job.

$25 CAD in 1 Tag

4,9

(64 Bewertungen)

6,0

@LearningNew

A proposal has not yet been provided

$10 CAD in 1 Tag

5,0

(4 Bewertungen)

4,8

@acronymsolutions

Hi, I have gone through your requirements .I am a DBA at CMMI-5 Level company since August 2010.I am working on MySql,MSSQL Server,Oracle database, I can do your job confidently. I am very much Interested to do your work,Please revert me if you have any concern .I am ready to start now.

$40 CAD in 1 Tag

5,0

(3 Bewertungen)

3,8

@abdellatif81

Hello, I am IT engineer with European diploma since 2005 Certified as Technical specialist in Microsoft SQL Server databases, i have more than 8 years of experience working around databases and SQL development around (SQL Server ,Mysql ,Oracle ) . My last job was database consultant within Accenture ,for more than 4 years .I worked for several database projects and advanced SQL development on behalf of European Customers (Carrefour, LOREAL,Eurovia ..). I have strong skills in database development and SQL to develop all types of requirements related ,and given my experience, I am persuaded to give you High quality of work delivery withing budget and time Best regards,

$45 CAD in 0 Tag

4,8

(4 Bewertungen)

4,0

@brainwithstorm

I can make you this query. I can start now and will be done in max one hour. Check all my SQL previous work to see im capable of doing it. Thnx. DB dump would be perfect.

$25 CAD in 1 Tag

5,0

(2 Bewertungen)

3,1

@yubor

Hi. I am mssql server expert (mcse, mcitp). Ready to do this project for you. Regards, Yury .

$15 CAD in 2 Tagen

5,0

(1 Bewertung)

0,5

@niteshlal

A proposal has not yet been provided

$25 CAD in 1 Tag

0,0

(0 Bewertungen)

0,0

@aashishnakil

I clearly understood the requirement you specified. I will give you solution with the great exception handling within minimum time period. Thank You !

$10 CAD in 1 Tag

0,0

(0 Bewertungen)

0,0

@argeuiv

Senior professional with excellent SQL skills and experience in large transactional database with in applications like e-commerce and educational systems.

$35 CAD in 1 Tag

0,0

(0 Bewertungen)

0,0

@Pehu

hello sir, your defined task already done in my previous project definitetly done on time with quality Give me a chance please

$10 CAD in 1 Tag

0,0

(0 Bewertungen)

0,0

@adityarajput1505

A proposal has not yet been provided

$25 CAD in 1 Tag

0,0

(0 Bewertungen)

0,0

@seabytes

I have big SQL professional working experience, Job you requested is easy so I already resolved the problem. Test data will be: DECLARE @linqTable TABLE(ID INT, Value int) INSERT INTO @linqTable VALUES (1,11) INSERT INTO @linqTable VALUES (1,12) INSERT INTO @linqTable VALUES (1,13) INSERT INTO @linqTable VALUES (1,14) DECLARE @MainTable TABLE(ID INT, Value nvarchar(10)) INSERT INTO @MainTable VALUES (1,'Name1') DECLARE @CategoryTable TABLE(ID INT, CatName nvarchar(10)) INSERT INTO @CategoryTable VALUES (11,'cat1') INSERT INTO @CategoryTable VALUES (12,'cat2') INSERT INTO @CategoryTable VALUES (13,'cat3') INSERT INTO @CategoryTable VALUES (14,'cat4') What You need is SELECT statement that I will send you. Best regards, Seabytes

$10 CAD in 1 Tag