Write/Modify a SQL report for a Volusion store

Chiuso Pubblicato 7 anni fa Pagato alla consegna
Chiuso Pagato alla consegna

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 Progettazione Siti Web

Rif. progetto: #11054487

Info sul progetto

10 proposte Progetto a distanza Attivo 7 anni fa

10 freelance hanno fatto un'offerta media di $28 per questo lavoro

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 Altro

$22 USD in 2 giorni
(11 valutazioni)
3.5
vw7590795vw

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

$20 USD in 1 giorno
(4 valutazioni)
2.4
ZishanChuhan

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

$25 USD in 1 giorno
(3 valutazioni)
2.1
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 in 1 giorno
(0 valutazioni)
0.0
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 in 1 giorno
(0 valutazioni)
0.0