Thank you for the spackle Jeff but it looks like there is a small crack in it as it makes the assumption that the end time is always greater than...

Thank you Gregory for this clear and concise article.

I cannot resist pitching in some Window function version of the queries;

;WITH CUST_SALES_DETAILS AS

(

SELECT

SSOH.CustomerID

...

Think you nailed it here, just what I was trying to say :Whistling:

Hi Lynn,its an old habit I guess rather than belt and suspender kind of thing.

Thank you Jeff for a good "filler", there are many cracks "float"ing around when it comes to math and numbers on the platform. It is also far to easy to...

Chapeau to SQL Server Central!

Nice article and a classic subject.

One workaround is to use tokens when writing dynamic SQL statements, especially if nested more than one level;

DECLARE @TOKEN NVARCHAR(1) = ...