Write/Modify a SQL report for a Volusion store

종료 등록 시간: 7년 전 착불
종료 착불

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 웹사이트 디자인

프로젝트 ID: #11054487

프로젝트 소개

10 건(제안서) 재택 근무형 프로젝트 서비스 이용 중: 7년 전

이 일자리에 대한 프리랜서 10 명의 평균 입찰가: $28

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 기타

$22 USD (2일 이내)
(11 리뷰)
3.5
vw7590795vw

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

$20 USD (1일 이내)
(4 리뷰)
2.4
ZishanChuhan

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

$25 USD (1일 이내)
(3 리뷰)
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 (1일 이내)
(0 리뷰)
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 (1일 이내)
(0 리뷰)
0.0