SELECT OrderDate AS 'Order Date',
	    PaymentAmount AS 'Total Payments',
	    TotalShippingCost AS 'Shipping Received',
	    SalesTax1 AS 'Sales Tax Received',
	    PaymentDeclined AS ' Payment Declined'
FROM Orders
WHERE PaymentDeclined IS NULL
ORDER BY OrderDate DESC

SELECT 
	OrderDate AS 'Order Date',
	PaymentAmount AS 'Total Payments',
	TotalShippingCost AS 'Shipping Received',
	SalesTax1 AS 'Sales Tax Received',
	PaymentDeclined AS ' Payment Declined'
FROM 
	Orders
WHERE 
	PaymentDeclined IS NULL
	AND OrderDate >= CAST(SYSDATETIME() AS DATE)
	AND OrderDate <  DATEADD(DAY, 1, CAST(SYSDATETIME() AS DATE))
ORDER BY 
	OrderDate DESC

quote:

---

Originally posted by Lamprey

SELECT 
	OrderDate AS 'Order Date',
	PaymentAmount AS 'Total Payments',
	TotalShippingCost AS 'Shipping Received',
	SalesTax1 AS 'Sales Tax Received',
	PaymentDeclined AS ' Payment Declined'
FROM 
	Orders
WHERE 
	PaymentDeclined IS NULL
	AND OrderDate >= CAST(SYSDATETIME() AS DATE)
	AND OrderDate <  DATEADD(DAY, 1, CAST(SYSDATETIME() AS DATE))
ORDER BY 
	OrderDate DESC

---