Find Jobs
Hire Freelancers

Cumulative sum of products

€8-30 EUR

Closed
Posted over 6 years ago

€8-30 EUR

Paid on delivery
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
Project ID: 15705146

About the project

7 proposals
Remote project
Active 6 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
7 freelancers are bidding on average €23 EUR for this job
User 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 in 1 day
5.0 (20 reviews)
4.6
4.6
User 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 in 1 day
5.0 (2 reviews)
1.8
1.8
User 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 in 1 day
5.0 (1 review)
1.6
1.6
User 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 in 5 days
0.0 (0 reviews)
0.0
0.0
User 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 in 2 days
0.0 (0 reviews)
0.0
0.0
User 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 in 5 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of GREECE
Athens, Greece
5.0
1
Payment method verified
Member since Nov 1, 2017

Client Verification

Other jobs from this client

Hire sql developer
€8-30 EUR
Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.