SALES THIS DAY AND TIME Vrs PREVIOUS WEEKSDECLARE @Hour intSET @Hour = DATEPART(hh, getdate())-1 DECLARE @DayOfTheWeek nvarchar(20)SET @DayOfTheWeek = 'Saturday' SELECT@DayOfTheWeek + ' ' +CAST(DAY(TimeStamp) AS nvarchar) + '/' +CAST(MONTH(TimeStamp) AS nvarchar) + '/' +CAST(YEAR(TimeStamp) AS nvarchar) + ' ' + CAST(@Hour as nvarchar) + ':00' AS [Sale Before],SUM(TotalPrice) as [Sales Now] FROM OrdersWHERE DATENAME(dw, TIMESTAMP) =@DayOfTheWeek AND DATEPART(hh, TIMESTAMP) < @HourAND Orders.Status NOT IN (200,201,202,203,204,500,510,4000,10000)AND Orders.OrderType IN (1,4)GROUP BY YEAR(TimeStamp), MONTH(TimeStamp), DAY(TimeStamp)ORDER BY YEAR(TimeStamp) DESC, MONTH(TimeStamp) DESC, DAY(TimeStamp) DESC Sales - total figures per Country Over Date Range
DECLARE @StartDate DATETIME
DECLARE @EndDate DATETIME
SET @StartDate = '2016-04-16 00:00:00'
SET @EndDate = '2016-07-25 23:59:59'
SELECT
ShippingCountries.Country,
SUM(UnitPrice) AS [Total Sales Over Date Range],
SUM(UnitPriceIncVat) AS [Total Sales Inc Vat Over Date Range]
FROM
OrderItems
INNER JOIN
Orders
ON Orders.OrderID = OrderItems.OrderID
INNER JOIN
ShippingCountries
ON ShippingCountries.ShippingCountryID = Orders.ShippingCountryID
WHERE
OrderItems.[Timestamp] BETWEEN @StartDate AND @EndDate
AND
OrderType IN (1,4)
GROUP BY
ShippingCountries.Country
ORDER BY
ShippingCountries.Country
Sales By Year & Country
DECLARE @startDate DATETIME
DECLARE @endDate DATETIME
SET @startDate = '01/01/2015 00:00:00'
SET @endDate = '01/03/2016 00:00:00'
-- Date Format mm/dd/yyyy
SELECT
YEAR(Orders.TimeStamp) AS [Year],
ShippingCountries.Country,
Count(Orders.OrderID) AS [Total Number of Orders],
SUM(Orders.totalPrice) AS [Total Sales]
FROM
Orders
INNER JOIN
ShippingCountries
ON ShippingCountries.ShippingCountryID = Orders.ShippingCountryID
WHERE
orders.timestamp BETWEEN @startDate AND @endDate
Group BY
YEAR(Orders.TimeStamp),
ShippingCountries.Country
ORDER BY
YEAR(Orders.TimeStamp) DESC,
[Total Sales] DESC
Sales - SQL Monthly Order Stats
SELECT
SUM(totalPrice) AS [TOTAL SALES],
Month(TimeStamp) AS [Month],
Year(TimeStamp) AS [Year]
FROM Orders
WHERE Status NOT IN (500, 510, 4000, 10000)
AND ORDERTYPE=1
Group BY
YEAR(TimeStamp), MONTH(TimeStamp)
ORDER BY Year(TimeStamp) DESC, Month(TimeStamp) DESC