sql query i need to add the same range for the year before MAX$15

i have this query that give me the data for this year i need to have last year data side with this year


--This Year Sale - Daywise

SET @StartDate=DATEADD(yy, DATEDIFF(yy, 0, @OrderDate), 0)

SELECT fn.[DayName],[login to view URL],ROUND(ISNULL(SUM(oh.Total_Price),0),2) AS GrossSales, ROUND(ISNULL(SUM(oh.Grand_Total),0),2) AS NetSales

FROM fnGetListOfMonths(@StartDate,@OrderDate) fn

LEFT OUTER JOIN Invoice_Totals oh ON CAST([login to view URL] AS DATE) = [login to view URL] AND oh.Store_ID=@StoreID

GROUP BY [login to view URL],[login to view URL]

Evner: SQL, MySQL, Microsoft SQL Server, PHP, Database Administration

Se mere: sql query tree structure records, asterisk call forward database sql query, sql query child child, need add printer, sql query tree children, getafreelancer message sql query help needed, sql query add decimal number oracle, need sql query, sql query sales year month, sql query generate sales month year, i need to write speech for 15 year old birthday girl, why does a 15 year old female need more iron than a 15 year old male, sql query date range from current date, sql - query every 15 minutes, excel vba sql query named range, sql server left outer join, sql left outer join, add array in sql query

Om arbejdsgiveren:
( 48 bedømmelser ) Jamaica, United States

Projekt ID: #31883594

Tildelt til:


Hi, I am an expert and can do it with in 30 min Please message me without wasting time elsewhere Thanks

$15 USD in 5 dage
(3 bedømmelser)

6 freelancere byder i gennemsnit $29 timen for dette job


Hello, I would like to help you, I have more than 10 years of experience working with MYSQL, POSTGRESQL, SQL SERVER, MARIADB, in many of its versions. It is my specialty en SQL y PL/SQL. Visit my profile without obliga Flere

$30 USD på 1 dag
(26 bedømmelser)

I've been working for a database designer for 5 years I have been experienced realtional databases like mysql, oracle, mssql. I am the one who came up with the idea of MongoDB the document oriented database. I also hav Flere

$30 USD på 1 dag
(5 bedømmelser)

Hi there SQL expert here My last job here is related to SQL job. you can check my review I can do your job within 10 minutes. kindly ping me Thanks

$30 USD på 1 dag
(8 bedømmelser)
(0 bedømmelser)

Hello There! I can help you with your project I am a professional Web and app developer and have huge Experience in Web development and E-commerce and I have worked on many projects. I Insist you to check my portfoli Flere

$20 USD in 7 dage
(0 bedømmelser)