Lengkap

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]

Kemahiran: SQL, MySQL, Pelayan Microsoft SQL, PHP, Pentadbiran Pangkalan Data

Lihat lagi: 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

Tentang Majikan:
( 48 ulasan ) Jamaica, United States

ID Projek: #31883594

Dianugerahkan kepada:

Peefect

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

$15 USD dalam 5 hari
(3 Ulasan)
2.1

6 pekerja bebas membida secara purata $29 untuk pekerjaan ini

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 Lagi

$30 USD dalam sehari
(26 Ulasan)
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 Lagi

$30 USD dalam sehari
(5 Ulasan)
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 dalam sehari
(8 Ulasan)
3.6
(0 Ulasan)
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 Lagi

$20 USD dalam 7 hari
(0 Ulasan)
0.0