Write/Modify a SQL report for a Volusion store

Imefungwa Ilichapishwa Miaka 7 iliyopita Kulipwa wakati wa kujifungua

$10-30 USD

Kulipwa wakati wa kujifungua

Imefungwa Kulipwa wakati wa kujifungua

need a sql query written for a Volusion store (which means not all SQL functions work)

results needs to look like the attached spreadsheet and I have provided a sample query which has the columns and the tables needed to get the data.

what I need is it to be done like a pivot, but pivot doesn't seem to work in this particular SQL instance (Volusion), so an aggregate CASE WHEN would be ideal, I just don't know the syntax for that.

so the summary of the report is, need a report of sales total by customer, by month (months in columns) to be able to compare one month to another.

ASP.NET HTML JavaScript SQL Kubuni Tovuti

Kitambulisho cha Mradi: #11054487

Kuhusu mradi

10 mapendekezo Mradi wa mbali Ipo mtandaoni %project.latestActivity_relativeTime|badilisha%

Unapania kutengeneza pesa?

Faida za kutoa zabuni kwenye Freelancer

Weka bajeti yako na muda
Lipwa kwa kazi yako
Onyesha ombi lako
Ni bure kujisajili na kuweka zabuni kwa kazi

10 wafanyakazi huru wanazabuni wastani wa $28 kwa kazi hii

Picha ya Profaili ya davedcb
davedcb

Hello, I am interested in your project. I am software engineer and I have profissional experience with SQL. Could you please provide the spreadsheet you referred in the description? Thank you, Best regards, D Zaidi

$22 USD kwa siku 2
(Maoni 11)
3.5
Picha ya Profaili ya vw7590795vw
vw7590795vw

Please provide your spread sheet, give me more details and when will we start.

$20 USD kwa siku 1
(Maoni 4)
2.4
Picha ya Profaili ya ZishanChuhan
ZishanChuhan

I am expert in SQL , can do the task as per your requirements. .

$25 USD kwa siku 1
(Maoni 3)
2.1
Picha ya Profaili ya jagdishbhatt38
jagdishbhatt38

I am having more than 7 years of experience in IT industry.I have worked on .net(c#,asp,asp.net,mvc) with sql server and oracle.I can provide you better solution by utilizing my knowledge and skills.

$25 USD kwa siku 1
(Maoni 0)
0.0
Picha ya Profaili ya mannharleen
mannharleen

9 years of IT application including SQL experience. New to Freelancer, I want to make a mark here with my quick and intuitive solutioning skills.

$20 USD kwa siku 1
(Maoni 0)
0.0
Tuma Mradi Kama huu