Database

PIEBALDconsult wrote:

And, perhaps, you could mock it up; have your own Guid class that returns:

Select * from SomeTable where ID = 1

Select * from SomeTable where ID = '00000000-0000-0000-0000-000000000001'

PIEBALDconsult wrote:

I find them superior in ways that matter to me

SELECT
	SaleDate,
	SUM(Amount)
FROM SalesDetail SD
	INNER JOIN Sales S ON S.SaleID = SD.SaleID	
WHERE SaleDate BETWEEN ThisDate AND ThatDate
GROUP BY SaleDate

SELECT 
    s.InvDate, SUM(sd.Qty) as Amount 
FROM SalesDetails sd 
    INNER JOIN Sales s ON s.ID = sd.SaleID 
WHERE s.InvDate BETWEEN DATE(dteStart) AND DATE(dteEnd) 
AND sd.ProdID = ProductID
GROUP BY s.InvDate;

DATE(dteStart)

treefirmy wrote:

Any rationale for either tactic would be greatly appreciated.

I are Troll