Find Jobs
Hire Freelancers

Cumulative sum of products

€8-30 EUR

Lukket
Slået op over 6 år siden

€8-30 EUR

Betales ved levering
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
Projekt-ID: 15705146

Om projektet

7 forslag
Projekt på afstand
Aktiv 6 år siden

Leder du efter muligheder for at tjene penge?

Fordele ved budafgivning på Freelancer

Fastsæt dit budget og din tidsramme
Bliv betalt for dit arbejde
Oprids dit forslag
Det er gratis at skrive sig op og byde på jobs
7 freelancere byder i gennemsnit €23 EUR på dette job
Brug Avatar.
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 på 1 dag
5,0 (20 anmeldelser)
4,6
4,6
Brug Avatar.
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 på 1 dag
5,0 (2 anmeldelser)
1,8
1,8
Brug Avatar.
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 på 1 dag
5,0 (1 bedømmelse)
1,6
1,6
Brug Avatar.
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 på 5 dage
0,0 (0 anmeldelser)
0,0
0,0
Brug Avatar.
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 på 2 dage
0,0 (0 anmeldelser)
0,0
0,0
Brug Avatar.
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 på 5 dage
0,0 (0 anmeldelser)
0,0
0,0

Om klienten

Flag for GREECE
Athens, Greece
5,0
1
Betalingsmetode verificeret
Medlem siden nov. 1, 2017

Klientverificering

Andre jobs fra denne klient

Hire sql developer
€8-30 EUR
Tak! Vi har sendt dig en e-mail med et link, så du kan modtage din kredit.
Noget gik galt, da vi forsøgte at sende din mail. Prøv venligst igen.
Registrerede brugere Oprettede jobs i alt
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Indlæser forhåndsvisning
Geolokalisering er tilladt.
Din session er udløbet, og du er blevet logget ud. Log venligst ind igen.