I have a Datawarehouse as below, and it seems WHERE
is not responding. Why would that be ? many thanks in advance.
SELECT
SalesOrderNumber AS InvoceNumber,
OrderDate,
SUM(SalesAmount) AS SalesAmount,
SUM(TaxAmt) AS TaxAmt,
SUM(OrderQuantity) AS OrderQuantity
FROM FactInternetSales
WHERE SalesOrderNumber = 'S067876'
GROUP BY SalesOrderNumber, OrderDate