Peruttu

DataBase Query to verify quantitys

hello , i am looking to fix a query to verify some stock accounts those 4 to 5 tables some sums to check if the stock is right

must compare the current stock vrs the sum of initial+adjuments stock and if is wrong update with the right value.

SELECT [url removed, login to view],[url removed, login to view] as cantidadInv,sum([url removed, login to view]) as compraSt , sum([url removed, login to view]) as vendido,

SUM(IF([url removed, login to view] = 'addition', [url removed, login to view], 0))-SUM(IF([url removed, login to view] = 'subtraction', [url removed, login to view], 0))+sum([url removed, login to view]) as ajustes

FROM `sma_purchase_items` compra

inner join sma_products productos on [url removed, login to view] = compra.product_id

left join sma_sale_items vendidos on [url removed, login to view] = vendidos.product_id

left join sma_adjustment_items ajustes on vendidos.product_id = ajustes.product_id

group by [url removed, login to view]

this is mostly the query must be fixed due in some rows shows another information. if need i can share the db and explain via teamviewer or similar

Taidot: Tietokannan hallinto, Tietokantakehitys, Tietokantaohjelmointi, MySQL

Näytä lisää: websites to find information for an academic essay, crawl websites information, websites information web design, websites information fortune company, websites information, websites dat find jobs, fetch websites information, medical transcription websites information, websites information fortune 500 company, websites can find possible husband wife, script query database size, input output query database, wordpress query database, php drop list query database, oscommerce database tables products, information find swing tag label, script php query database, need products sale, php query database drop, user forms query database, online products sale, websites can find friendster com layouts, oscommerce database missing products, execution query database failed modx, arcgis serve query database

Tietoa työnantajasta:
( 11 arvostelua ) heredia, Costa Rica

Projektin tunnus: #13120054

Myönnetty käyttäjälle:

moeenahmed21

I am an experienced database developer and administrator. I will create query and solve your problem. Feel free to contact me for further discussion. Regards, Moeen Ahmed

30 $ USD 1 päivässä
(8 arvostelua)
3.3

19 freelancers are bidding on average $30 for this job

fanninson45

SHOWCASE An experienced Microsoft Certified Professional with Database Programming and Administration skills across both MS SQL and Business Intelligence Development. Having the ability to take the technical lead in p Lisää

25 $ USD 1 päivässä
(14 arvostelua)
5.5
mahmoudgamal008

I have more than 5 years of professional and practical experience in SQL and database development. I wrote hundreds and hundreds of SQL queries, I have more than 1800 answers in Stackoverflow(Q&A Site), you can vie Lisää

30 $ USD 1 päivässä
(29 arvostelua)
5.2
point5nyble

Hello, I have been working with a MNC based company since last ~ 6 years, as an IT BI DWH Professional. The project is a BI DWH project which covers 3 layers of BI (ETL, Data warehouse & Reporting) and helped me in Lisää

35 $ USD 1 päivässä
(32 arvostelua)
4.8
phiona06

Hi! I'm senior lecturer on databases with 10+ years experience in different DBMS (including MySQL). As I see in your query have one mistake - in group statement need to be the same columns as in select statement (witho Lisää

25 $ USD 0 päivässä
(16 arvostelua)
4.3
nojnish

Hi, I can help you with the task as I have 15+ years experience and 5 years in MySQL. can you share what additional info you are getting for the query shared as it would help resolve the problem otherwise I can prov Lisää

22 $ USD 1 päivässä
(2 arvostelua)
3.5
60 $ USD 1 päivässä
(4 arvostelua)
3.4
celalaybar

Hello. Thank you very much for taking time to read my proposal. I can help you. I am a fulltime freelancer. You can check my portfolio and reviews. We can discuss further details. Hopefully, both of us Lisää

29 $ USD 1 päivässä
(4 arvostelua)
2.3
swarm22

I am database developer , query writing and optimizing with mysql , oracle . I will able to do this task. Could you let me know , when could we arrange meeting regarding project

30 $ USD 1 päivässä
(13 arvostelua)
2.8
25 $ USD 2 päivässä
(0 arvostelua)
0.0
kunjmishra

Dear Client, With 6 years of experience in database (sql) and looking at the sample query provided it seems doable. Looking forward to hear from you. Regards, Kunj.

15 $ USD 1 päivässä
(0 arvostelua)
0.0
im146

hi, I have experience in developing complex queries and I am interested in this task please ping me so we can discuss it further and can start the work thanks

45 $ USD 1 päivässä
(0 arvostelua)
0.0
30 $ USD 3 päivässä
(0 arvostelua)
0.0
delphijdeveloper

I graduated from the department of Mathematics and specialized in Computer applications. I have been writing financial and business applications on Delphi and Mysql languages since last 20 years for small and big comp Lisää

45 $ USD 2 päivässä
(0 arvostelua)
0.0
30 $ USD 1 päivässä
(0 arvostelua)
0.0
aap31374

I have 10+ years database development experience in sql server, Mysql and Postgres. I have also worked in SSIS and SSRS. I assure that i will give you fully satisfaction about this assignment.

25 $ USD 1 päivässä
(0 arvostelua)
0.0
AppsUNeed

This looks reasonably simple to carry out. I would probably simplify this by creating a view in your database that will do all of the aggregation so that you don't need the long string of LEFT JOINs but will confirm w Lisää

25 $ USD 1 päivässä
(0 arvostelua)
0.0
35 $ USD 1 päivässä
(0 arvostelua)
0.0
arindamkumar

A proposal has not yet been provided

30 $ USD 1 päivässä
(0 arvostelua)
0.0
25 $ USD 1 päivässä
(0 arvostelua)
0.0