Find Jobs
Hire Freelancers

Cumulative sum of products

€8-30 EUR

Mbyllur
Postuar over 6 years ago

€8-30 EUR

Paguhet në dorëzim
We have two different kind of orders: Order from Suppliers Order to Clients We need a query in which we show per week the stock available calculating the stock per week doing: Orders from suppliers - Order to Clients. We already made a query which is attached, but it doesn't show values when a week has no order. Data are in Greek so we have the translations in order to be easier to understand: Week >= Current_Week -> True false criteria Τρ.Εβδομάδα -> Running week GXCOMMERCENTRYKIND -> Type of order GXORIGIN -> Origing of order Ημερομηνία -> Date of order Αρ.Παραστατικού -> Number of order Παραστατικό κωδ. -> Order Code Παραστατικό περιγραφή -> Order Description Είδος περιγραφή -> Item description 1η ποσότητα -> Quantity of 1st unit measurement (pcs) 2η ποσότητα -> Quantity of 2nd unit measurement (Kg) Ημερομηνία Εξαγωγής -> Date of execution (Date that the stock will change) Εβδομάδα Εξαγωγής -> Week of execution (Week that the stock will change) Έτος Εξαγωγής -> Year of execution (Year the the stock will change) Συναλλασόμενος -> Client/supplier (trader) Σχόλιο 1 -> Comments of order Είδος κωδ ->Item code GXID -> Unique key of order Στοκ 1η ΜΜ -> Available stock in acumulative sum 1st measurement unit Στοκ 2η ΜΜ -> Available stock in acumulative sum 2nd measurement unit Ποικιλία -> Variety (Case result) Χώρα -> Country (Case result) Μέγεθος -> Size (Case result) Κλάση -> Type of product (Case result) In 1η ποσότητα ( Quantity of 1st unit measurement (pcs)) we already have a number with "-" when its from client that reduces the amount of products and a "+" sign when its from supplier. We have SQL SERVER 2008 R2
ID e Projektit: 15705146

Rreth projektit

7 propozime
Projekt në distancë
Aktive 6 yrs ago

Po kërkoni të fitoni para?

Përfitimet e ofertës për Freelancer

Vendosni buxhetin dhe afatin tuaj
Paguhuni për punën tuaj
Përshkruani propozimin tuaj
Është falas të regjistrohesh dhe të bësh oferta për punë
7 freelancers are bidding on average €23 EUR for this job
Avatari i Përdoruesit
I'd like to work with you on the project,Having 9+ Years of Experience as a Software Developer, successfully completed many projects (please see my reviews). Relevant Skills and Experience Experienced in ASP.Net, C#, VB.Net, MVC, WPF, Visual Basic, Excel VBA, MS SQL Server, MYSQL, Oracle, MS Access, Crystal Report, Telerik, Bootstrap, HTML 5, CSS,Java Script. Proposed Milestones €23 EUR - Final
€23 EUR në 1 ditë
5,0 (20 përshtypje)
4,6
4,6
Avatari i Përdoruesit
Hello there, I get your idea a bit but because of language problem I did not get completely. Please write in English or initiate a chat to clear all the requirements. By the way I have skills and experience on the thing that you are looking for.
€34 EUR në 1 ditë
5,0 (2 përshtypje)
1,8
1,8
Avatari i Përdoruesit
Hi i'm a professional software engineer i have +3 years experience in this field i have lot of expertise in Database development we can discuss more details over chat regards Relevant Skills and Experience SQL Proposed Milestones €15 EUR - milestone
€15 EUR në 1 ditë
5,0 (1 review)
1,6
1,6
Avatari i Përdoruesit
Hi, I can try to do this task in 5 days. Just require some help from you i.e. the structure of table with some dummy data. Thanks Preetpal Relevant Skills and Experience I have done this kind of task in my organisation. It was to show some balances of accounts which have not done transaction in a day. in that case i have to keep the track of prev day balance.
€23 EUR në 5 ditë
0,0 (0 përshtypje)
0,0
0,0
Avatari i Përdoruesit
I checked your given details. I need the details of dbo.z_531b_patata table full column and their data(dummy). Hope that will help to pick the records as your wish. Relevant Skills and Experience I am having 4+ years of Experience in SQL Development and I faced this kind of issues in my Environment. Proposed Milestones €10 EUR - To get understanding of the requirement and get to finalize the task €9 EUR - To provide the result query
€19 EUR në 2 ditë
0,0 (0 përshtypje)
0,0
0,0
Avatari i Përdoruesit
I am 6 years experienced Software Development Professional with Advance level skills woking on SQL Server. New to Freelancer.com. Please test me Relevant Skills and Experience Microsoft SQL Proposed Milestones €29 EUR - 100%
€29 EUR në 5 ditë
0,0 (0 përshtypje)
0,0
0,0

Rreth klientit

Flamuri i GREECE
Athens, Greece
5,0
1
Mënyra e pagesës u verifikua
Anëtar që nga nën 1, 2017

Verifikimi i klientit

Punë të tjera nga ky klient

Hire sql developer
€8-30 EUR
Faleminderit! Ne ju kemi dërguar me email një lidhje për të kërkuar kredinë tuaj falas.
Ndodhi një gabim gjatë dërgimit të email-it tuaj. Ju lutemi provoni përsëri.
Përdorues të regjistruar Punë të postuara
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Po ngarkohet shikimi paraprak
Leja u dha për Geolocation.
Seanca e hyrjes ka skaduar dhe ke dalë. Hyr sërish.