USE [spoffice] GO /****** Object: StoredProcedure [dbo].[GetTracksToPlay] Script Date: 03/22/2010 21:23:35 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO ALTER PROCEDURE [dbo].[GetTracksToPlay] ( @amount int = 3, @exclude varchar(500) = '' ) AS BEGIN SELECT TOP (@amount) ( SELECT TOP(@amount) t.* FROM Favourites AS fav LEFT OUTER JOIN TrackHistory AS trkhis ON trkhis.Track_Id = fav.Track_Id AND trkhis.Datetime = (SELECT MAX(Datetime) AS Dt FROM TrackHistory AS th WHERE (th.Track_Id = fav.Track_Id) GROUP BY th.Track_Id) LEFT OUTER JOIN Tracks AS t ON fav.Track_Id = t.Id WHERE ( (trkhis.Datetime < DATEADD(hour, ( SELECT 0 - SUM(trk2.Length) / 1000 / 60 / 60 / 2 AS TotalLength FROM Tracks AS trk2 ), SYSDATETIMEOFFSET())) OR (trkhis.Datetime IS NULL) ) AND t.Id NOT IN (SELECT convert(uniqueidentifier,Value) FROM dbo.Split(@exclude,',')) ORDER BY(NEWID()) UNION ALL SELECT TOP(@amount) t.* FROM Tracks AS t ORDER BY (NEWID()) ) END
USE [spoffice] GO /****** Object: StoredProcedure [dbo].[GetTracksToPlay] Script Date: 03/22/2010 22:10:20 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO ALTER PROCEDURE [dbo].[GetTracksToPlay] ( @amount int = 3, @exclude varchar(500) = '' ) AS BEGIN SELECT TOP (@amount) * FROM ( SELECT TOP(@amount) t.* FROM Favourites AS fav LEFT OUTER JOIN TrackHistory AS trkhis ON trkhis.Track_Id = fav.Track_Id AND trkhis.Datetime = (SELECT MAX(Datetime) AS Dt FROM TrackHistory AS th WHERE (th.Track_Id = fav.Track_Id) GROUP BY th.Track_Id) LEFT OUTER JOIN Tracks AS t ON fav.Track_Id = t.Id WHERE ( (trkhis.Datetime < DATEADD(hour, ( SELECT 0 - SUM(trk2.Length) / 1000 / 60 / 60 / 2 AS TotalLength FROM Tracks AS trk2 ), SYSDATETIMEOFFSET())) OR (trkhis.Datetime IS NULL) ) AND t.Id NOT IN (SELECT convert(uniqueidentifier,Value) FROM dbo.Split(@exclude,',')) ORDER BY(NEWID()) UNION ALL SELECT TOP(@amount) t.* FROM Tracks AS t ORDER BY (NEWID()) ) AS x END
But the real question is whether you pronounce 'SQL' as 'EssCueEll', 'Sequel', 'Squeal', or other.
I prefer 'sequel', much to Peter's distaste, but I care not for using more syllables than is strictly necessary. Of course, 'squeal' uses one less syllable, but it does sound rather like pulling little girls' pigtails, and so is to be avoided. :Y
You call a standard from 1986 /modern/? Jeez, Pete, get with the programme...we've had the 90s and the first decade of the new millennium since then. 1986 is so, so /dated/!
Squeal, bitch!
You're such a swinger, Pete.
sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequel sequ
&he…[Message Truncated]