Building an sql query for a report

$30-250 USD

Zrušeno

Zveřejněno

přibližně před 6 roky

$30-250 USD

Zaplaceno při doručení

have perhaps 90% of the query completed. I'm having trouble getting the dataset I need. It is a little complex to spell out but simple enough to show. This is the request: --I need all sales orders in house, --I need each sales order to list the configured stain for that order. --I also need the list price for each of those sales order. select top 300 sod.ORDNUM_28 + sod.LINNUM_28 + sod.DELNUM_28 as orderlindel, sod.PRTNUM_28,sum(sod.PRICE_28)--, cs.CFGDES_45 ,[login to view URL](cs.CFGDES_45,sod.PRTNUM_28) from SO_Detail sod left join Configuration_Str cs on sod.ORDNUM_28 + sod.LINNUM_28 + sod.DELNUM_28 = cs.CUORDR_45 where STATUS_28 < '4' group by sod.ORDNUM_28, sod.LINNUM_28, sod.DELNUM_28, sod.PRTNUM_28, cs.cfgdes_45, sod.prtnum_28

Database Administration

Database Development

MySQL

SQL

IČ projektu: 16480476

O projektu

14 nabídky

Vzdálený projekt

Aktivní před 6 roky

Chcete si vydělat nějaké peníze?

E-mailová adresa

Výhody podávání nabídek na Freelancer

Stanovte si rozpočet a časový rámec

Získejte za svou práci zaplaceno

Načrtněte svůj návrh

Registrace a podávání nabídek je zdarma

14 freelanceři nabízejí v průměru $138 USD za tuto práci

@gopalvora

Hi i can work for Building an sql query for a report i am expert at ,Database Administration,Database Development,MySQL,SQL So send me Private message at PMB so we can discuss more about it Thanks

$122 USD v 3 dnech

4,8

(237 recenze)

7,6

@schoudhary1553

Hi there..... Warm Greetings We came along with your request for Building an sql query for a report and we reviewed your project description. We'd like to help you with confidence and satisfying results... We have professionals working here with 100% results and more creative and renovative ideas for our clients ! We have worked on several similar projects before! We are offering our services for more than 5 years in the field of Database Administration, Database Development, MySQL, SQL We have worked on 300+ Projects. Please check the profile reviews Feel free to message us to discuss briefly about your project !

$200 USD v 4 dnech

4,8

(28 recenze)

5,9

@sherifamgadnabih

i am a lead .NET software engineer and responsible for creating a web and desktop applications using different languages and technologies if u r interested just send me a message thank you and good luck

$133 USD v 2 dnech

4,9

(22 recenze)

5,4

@ludwig333

hello i have read your description very carefully. i am full stack web developer. i can do your job in time

$155 USD v 3 dnech

4,8

(20 recenze)

5,1

@SeniorWebDev1

Dear sir. I have a sample project I have made before. I am a sql expert. I can do your sql management perfectly in 1 hr. I've ever done lots of works like that. Please send me your sql and db. Don't worry about my ability. Thank you.

$155 USD v 3 dnech

5,0

(10 recenze)

4,1

@emon777asd

I have 6 year experience Freelancer,up work,Fiverr & 99design market placeI have seen your project that i can to do easily because I have many experience to Graphic Design,Webdesign,Web Develop & programming .So I could create it for you as soon as that easy but how this have done ,,,,please discuses before start job,,,,

$155 USD v 3 dnech

0,0

(0 recenze)

0,0

@spiritualgroup

I have 12+ years experience in web development and special in asp.net technology. I will submit project on time and very hard worker and 3-5 hour daily work. You can check my work on tareework dot com. thanks

$111 USD v 3 dnech

0,0

(0 recenze)

0,0

@naeemkhan989

I have 3 Years Experience on MySQL & SQL Server Working on Triggers, Joins, Cursors, Primary & Foreign Key Constraints and Stored Procedures. Diagram Designing.

$155 USD v 3 dnech