Write/Modify a SQL report for a Volusion store

已关闭已发布的 7 年前货到付款

$10-30 USD

货到付款

已关闭货到付款

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 年前

想要赚钱吗？

在Freelancer上竞标的好处

设置你的预算和时间表

通过工作获取报酬

大致描述您的提案

免费注册并竞标工作

有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.

$20USD 在1天里

(4条评论)

2.4

ZishanChuhan

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

$25USD 在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.

$25USD 在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.