Write/Modify a SQL report for a Volusion store

Kapalı İlan edilme: 7 yıl önce Teslim sırasında ödenir
Kapalı Teslim sırasında ödenir

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 Web Sitesi Tasarımı

Proje NO: #11054487

Proje hakkında

10 teklif Uzak proje Aktif 7 yıl önce

Bu iş için 10 freelancer ortalamada $28 teklif veriyor

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 Daha Fazla

$22 USD in 2 gün içinde
(11 Değerlendirme)
3.5
vw7590795vw

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

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(4 Değerlendirme)
2.4
ZishanChuhan

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

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(3 Değerlendirme)
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.

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(0 Değerlendirme)
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.

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(0 Değerlendirme)
0.0