Write/Modify a SQL report for a Volusion store
$10-30 USD
S-au achitat serviciile după ce au fost prestate
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.
ID Proiect: #11054487
Detalii despre proiect
10 freelanceri plasează o ofertă medie de 28$ pentru proiect
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.
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.
