tSQL sum help

$15-25 USD / hour

Cancelled

Posted

almost 6 years ago

$15-25 USD / hour

I cannot give you access to my database. I am looking for help summing when the account number changes. See Example. I want to Sum to total Cost from Table 'a' based on the Account#. In other words when the account number changes I want to stop, Add a line for the Totals. I don't want to repeat the Total Sales Price from Table 'b' over and over, I just want it once on the Total Line. Finally I want to add a column for Profit. Total From Table 'b' - Total from Table 'a'

SQL

Project ID: 17132557

About the project

15 proposals

Remote project

Active 6 yrs ago

Looking to make some money?

Email address

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

15 freelancers are bidding on average $22 USD/hour for this job

@softcarve

Hi, I have good proficiency in T-SQL. I would like to write the additional line for showing the total and profit. Available to start now. Regards, Manish

$22 USD in 40 days

4.9

(62 reviews)

5.3

@kchg

Dear, sir. I've read your job description and I am fit for your project. I am strong on SQL. I am sure that I can provide high quality service to you. Let's keep in touch. Regards, Heng

$22 USD in 40 days

4.2

(12 reviews)

5.8

@diegofpr

Hello, I can solve your requirement, please let me know if you are interested and how we should verify that the query is working. Also please give details on that profit column you mention.

$20 USD in 2 days

5.0

(8 reviews)

3.8

@SeniorWebDev1

Hi there I read your proposal and understood your idea. I am a senior web developer. So I can help you. Thanks for your attention.

$22 USD in 40 days

5.0

(2 reviews)

3.6

@OWDGroup

Hi, I'm a database architect and programmer having more than 15 years of experience with different types of domains like telecom, banking, payroll, crm, ecommerce etc with high data volumes and I'm experienced with oracle and ms-sql. Please contact me for more information and also assure that you 'll get100% optimized query. Cheers!

$16 USD in 40 days

4.6

(5 reviews)

3.2

@jpadula

Hi there, We are a team based in Argentina with strong experience in software and mobile development. We are able to do your project starting ASAP. Do not hesitate to contact me if you are interested. You will not regret, Thank you very much, Best regards, Jorge.

$40 USD in 40 days

0.0

(0 reviews)

0.0

@ushaudayam25

I have 13+ yrs of experience as a Oracle Database PL/SQL Developer and 10+ yrs of experience as Java developer. My enthusiasm, ability to learn and adapt new technologies not only helped me in completing projects in different technologies but also made me more passionate in learning.

$27 USD in 40 days

0.0

(0 reviews)

0.0

@alekseimendez

I have more than 15 years of experience asking questions and answers about databases, I would love to know more about your project, which brand database is (SqlServer, Oracle, etc), and to obtain the desired result.

$22 USD in 40 days