Завершен

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

begin

--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]

Навыки: SQL, MySQL, SQL-сервер Microsoft, PHP, Управление базами данных

Показать больше: 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

О работодателе:
( 48 отзыв(-а, -ов) ) Jamaica, United States

ID проекта: #31883594

Поручен:

Peefect

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

$15 USD за 5 дней(-я)
(3 отзывов(-а))
2.1

6 фрилансеров(-а) готовы выполнить эту работу в среднем за $29

niarfedevelop

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 Больше

$30 USD за 1 день
(26 отзывов(-а))
4.5
temaural

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 Больше

$30 USD за 1 день
(5 отзывов(-а))
3.6
novikovyaroslavd

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 за 1 день
(8 отзывов(-а))
3.6
(0 отзывов(-а))
0.0
MithleshShakya

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 Больше

$20 USD за 7 дней(-я)
(0 отзывов(-а))
0.0