Help finishing a SQL query

$10-30 USD

Fullført

Lagt ut

omtrent 6 år siden

$10-30 USD

Betalt ved levering

I have 2 tables (attached examples) This is what I want from the _pricing table SELECT InvoiceNumber, TransactionNumber, TransDate, Confirmation, ItemPrice, ItemTax, ItemTotalCost FROM _pricing WHERE (TransDate BETWEEN '2018-04-01' AND '2018-04-02') Here is where I need help. I need the 'SalesPrice' from the _sold table. The problem is the SalesPrice is for the total items sold not individually as they are listed in the _pricing table. Also the _pricing table and the _sold table show the confirmation a little differently. in the _sold table the confirmation starts with 'CRS-' so the comparison would need to be SUBSTRING([login to view URL],5,LEN([login to view URL])) (if that's the best way??) So what I'm looking for is a SQL query that takes all the data from the _pricing table and adds a column 'sold' from the _sold table BUT the sold Total needs to be divided by the number of items, in other words I need the individual sold price.

Database Programming

SQL

Prosjekt-ID: 16697388

Om prosjektet

12 forslag

Eksternt prosjekt

Aktiv 6 år siden

Ønsker du å tjene penger?

E-postadresse

Fordeler med budgivning på Freelancer

Angi budsjettet og tidsrammen

Få betalt for arbeidet ditt

Skisser forslaget ditt

Det er gratis å registrere seg og by på jobber

Tildelt til:

@FerriSoft1

Hi, can you send a .bak with a subset of data, I can solve this for you right now, no need to be awarded. I'll show you results then you award me, expected delivery time next 1-2hours Thanks Felice

$30 USD om 1 dag

5,0

(10 omtaler)

5,7

12 frilansere byr i gjennomsnitt $23 USD for denne jobben

@sreenivas2903

hi I am expertise in querying ping me if you need help on this , I am good mysql and ms sql server sql querying

$15 USD om 1 dag

4,9

(13 omtaler)

4,3

@vw2107604vw

I'm a software engineer in the Pacific Northwest with a decade of experience. I can help you with your query and I will be easier to get ahold of because of my timezone. I'd like to help you with your query. Please message me about your project so we can discuss it. Thanks, Gabriel Paparella

$25 USD om 1 dag

5,0

(2 omtaler)

2,6

@sun0815

Hello,sir. How are you? I've just read your job description very carefully and looked at your attached files. I am a SQL database expert. I have 6+ years of experience to develop various databases using SQL. For example, DBMS for booking system, train reservation system, payment system. so your job is very fit for me and my major skills. You may check my abilities and skills about SQL query. I am ready to work with you and can confirmly complete your job within 1 hour. I am very confident that you will be completely satisfied with the quality, timeliness, and professionalism of my work. Please contact me with reasonable price for this project in more detail. I am hoping to hear from you soon. Best regards.

$30 USD om 1 dag

4,9

(3 omtaler)

2,2

@sfeuh

hi, i am available now, contact me for trying resolve the query. user the inner join methode ------------ ---------------- --------------------------- ---------------------------------------

$15 USD om 1 dag

5,0

(4 omtaler)

1,7

@awxmem

Hello, I have 3+ years of experience working with relational database like mssql and mysql. I am confident that I can of great help to finish the query. Best regards.

$20 USD om 1 dag

5,0

(1 omtale)

1,0

@Denishpatel96

Hi, I can solve this within an hour or two. Give me your database or access to database so I can add column you asked for in it. Hope to hear from you. Thank you.

$25 USD om 0 dag

0,0

(0 omtaler)

0,0

@amflorentin

I work every day with sql data base.

$23 USD om 1 dag

0,0

(0 omtaler)

0,0

@patelrinku248

As I have just joined this site. I will give my 100% and deliver the service you want to make my profile look good. so, just fire your requirement and work will be done in no time.

$20 USD om 1 dag