SELECT DISTINCT s.SALEDATE,d.NUMBEROFSALEDAYS, CASE WHEN d.SALENAME IS NULL THEN CASE WHEN d.SALETYPE = 'Video Sale' THEN 'Video Auction' ELSE CASE WHEN d.SALETYPE = 'Stampede Internet Sale' THEN 'Internet Auction' ELSE '' END END ELSE CASE WHEN d.SALENAME = 'Dairy Sale' THEN 'Dairy Auction' ELSE d.SALENAME END END AS SALENAME, d.AUCTIONID FROM AUCTIONSCHEDULE s INNER JOIN AUCTIONDATE d ON s.SALEDATE = d.SALEDATE INNER JOIN SALEDAY sd on sd.AUCTIONDATEID=d.AUCTIONDATEID WHERE (DATEDIFF(day, s.SALEDATE, GETDATE()) < 1) AND d.CATALOGRELEASED = 1 AND d.ISDAIRY != 1 AND AUCTIONID IS NOT NULL ORDER BY s.SALEDATE DESC  print (short)  (print detailed view)  View My Lots (0)