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

Kemahiran: Pentadbiran Pangkalan Data, MySQL, SQL

Lihat lagi: 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

Tentang Majikan:
( 3 ulasan ) Westboro, United States

ID Projek: #16480517

Dianugerahkan kepada:


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 Lagi

$30 USD dalam 0 hari
(18 Ulasan)

4 pekerja bebas membida secara purata $31 untuk pekerjaan ini


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 Lagi

$35 USD dalam sehari
(1 Ulasan)

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 dalam 3 hari
(0 Ulasan)

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 dalam sehari
(0 Ulasan)