Completado

2Build an SQL query for a report

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

,[url removed, login to view](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

Habilidades: Administración de bases de datos, MySQL, SQL

Ver más: freelance sql query report writer, sap sql query report, tree detail sql query, sql query select salary 1st sep 30th sep, mlm report sql query access, use sql query displaying report crystal report aspnet, sql query select latest accounts, aspnet crystal report sql query, sql query select employees age dob, crystal report sql query edit, creat report using sql query crystal report, sql query create matrix report, matric report sql query, aspnet crystal report rpt file sql query, sql query select last date customer order

Información del empleador:
( 3 comentarios ) Westboro, United States

Nº del proyecto: #16480517

Adjudicado a:

vw7590795vw

Please review my profile. https://www.freelancer.com/u/vw7590795vw.html I have 8 years and 4 months experience in SQL and 5 years and 3 months experience in SSRS, SSIS. Please let me know more details and when w Más

$30 USD en 0 días
(18 comentarios)
3.8

4 freelancers están ofertando el promedio de $31 para este trabajo

amitmondal

Around 6+ years of design and development experience for JAVA SE application and large scale of enterprise application using JAVA EE (Servlets/JSP/Spring MVC), Android OS modification and application development. Posse Más

$35 USD en 1 día
(1 comentario)
1.1
Grovattek

We have Expert in SQL and MY SQL . We have already work in US Public safty Software like XRMS (Record Management systems) in Vb.net/sql server with crystal Reports

$35 USD en 3 días
(0 comentarios)
0.0
developer2012sl

I am database guy and love to work on db [login to view URL] share me the db structure I will write down the optimized query for you.

$25 USD en 1 día
(0 comentarios)
0.0