Write/Modify a SQL report for a Volusion store

Stängt Publicerat 7 år sedan Betalades vid leverans
Stängt Betalades vid leverans

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 Webbdesign

Projekt-id: #11054487

About the project

10 offerter Distansprojekt Aktivt 7 år sedan

10 frilansare har lagt bud på i genomsnitt $28 för det här jobbet

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 Mer

$22 USD inom 2 dagar
(11 omdömen)
3.5
vw7590795vw

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

$20 USD inom 1 dag
(4 omdömen)
2.4
ZishanChuhan

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

$25 USD inom 1 dag
(3 omdömen)
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 inom 1 dag
(0 omdömen)
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 inom 1 dag
(0 omdömen)
0.0