Write/Modify a SQL report for a Volusion store

Fermé Publié le il y a 7 ans Paiement à la livraison
Fermé Paiement à la livraison

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 Design de site internet

Nº du projet : #11054487

À propos du projet

10 propositions Projet à distance Actif il y a 7 ans

10 freelances font une offre moyenne de 28 $ pour ce travail

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 Plus

$22 USD en 2 jours
(11 Commentaires)
3.5
vw7590795vw

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

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(4 Commentaires)
2.4
ZishanChuhan

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

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(3 Commentaires)
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.

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(0 Commentaires)
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.

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(0 Commentaires)
0.0