DrillthroughQuery
SELECT [Link]
, [Link]
, [Link]
, [Link]
FROM [Link] AS WSI
INNER JOIN [Link] AS WC ON
[Link] = [Link]
INNER JOIN [Link] AS PS ON
[Link] = [Link]
GROUP BY [Link], [Link], [Link], [Link]
MainQuery
SELECT [Link]
, CASE
WHEN MONTH(OrderDate) BETWEEN 1 AND 3 THEN 'Quarter 1'
WHEN MONTH(OrderDate) BETWEEN 4 AND 6 THEN 'Quarter 2'
WHEN MONTH(OrderDate) BETWEEN 7 AND 9 THEN 'Quarter 3'
ELSE 'Quarter 4'
END 'Quarter'
, DATEPART(YEAR,[Link]) AS 'Order Year'
, [Link]
, [Link]
, [Link]
, [Link]
, [Link]
FROM [Link] AS SO
INNER JOIN [Link] AS SOL
ON [Link] = [Link]
INNER JOIN [Link] AS WSI
ON [Link] = [Link]
INNER JOIN [Link] AS SI
ON [Link] = [Link]
INNER JOIN [Link] AS SCT
ON [Link] = [Link]
GROUP BY [Link], [Link], [Link],[Link], [Link],
[Link]
MapQuery
SELECT [Link]
, [Link]
, [Link]
, [Link]
, [Link]
FROM [Link] AS SC
INNER JOIN [Link] AS SCT
ON [Link] = [Link]
ORDER BY [Link]
OFFSET 0 ROWS
FETCH FIRST 500 ROWS ONLY
MobileQuery
SELECT OrderDate
, SUM([Link]) AS 'Total Transaction Amount'
, DATEPART(YEAR,[Link]) AS 'Order Year'
FROM [Link] AS SO
INNER JOIN [Link] AS SCT
ON [Link] = [Link]
GROUP BY [Link]
ORDER BY [Link]
MobileQueryByYear
SELECT SUM([Link]) AS 'Total Transaction Amount'
, DATEPART(YEAR,[Link]) AS Year
FROM [Link] AS SO
INNER JOIN [Link] AS SCT
ON [Link] = [Link]
GROUP BY DATEPART(YEAR,[Link])
StatesQuery
SELECT StateProvinceID
, StateProvinceCode
, StateProvinceName
FROM [Link]
StockItemsQuery
SELECT [Link]
, [Link]
, [Link]
FROM [Link] AS WSI
INNER JOIN [Link] AS WSISG
ON [Link] = [Link]
INNER JOIN [Link] AS WSG
ON [Link] = [Link]
GROUP BY [Link], [Link], [Link]
SupplierCategoriesQuery
SELECT SupplierCategoryID
, SupplierCategoryName
FROM [Link]
SupplierContactInformationQuery
SELECT SupplierCategoryID
, SupplierName
, PhoneNumber
, FaxNumber
FROM [Link]