2Build an SQL query for a report

$10-30 USD

已完成

已发布

大约 6 年前

$10-30 USD

货到付款

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

MySQL

SQL

项目 ID: 16480517

关于此项目

4提案

远程项目

活跃6 年前

想赚点钱吗？

电子邮箱地址

在Freelancer上竞价的好处

设定您的预算和时间范围

为您的工作获得报酬

简要概述您的提案

免费注册和竞标工作

颁发给：

@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 we will start. Sky pe jikenjd

$30 USD 在0天之内

5.0

(18条评论)

3.8

4威客以平均价$31 USD来参与此工作竞价

@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. Possess a BS in Computer Science and Engineering.

$35 USD 在1天之内

5.0

(1条评论)

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 在3天之内