Building an sql query for a report

$30-250 USD

Cancelled

Posted

about 6 years ago

$30-250 USD

Paid on delivery

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

Project ID: 16480476

About the project

14 proposals

Remote project

Active 6 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

14 freelancers are bidding on average $138 USD for this job

@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 in 3 days

4.8

(237 reviews)

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 in 4 days

4.8

(28 reviews)

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 in 2 days

4.9

(22 reviews)

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 in 3 days

4.8

(20 reviews)

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 in 3 days

5.0

(10 reviews)

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 in 3 days

0.0

(0 reviews)

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 in 3 days

0.0

(0 reviews)

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 in 3 days