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,
,[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
17 freelancere byder i gennemsnit $130 på dette job
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
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
I have 3 Years Experience on MySQL & SQL Server Working on Triggers, Joins, Cursors, Primary & Foreign Key Constraints and Stored Procedures. Diagram Designing.
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