Great article, very informative

With the "one job in ten years" policy I'm sure my resume would at the...

...I like to poke fun at developers who dabble in SQL...

Hey, I resemble that remark

The only problem is with milliseconds for times of '23:59:59.003' to '23:59:59.997' which if present on day-8 then your query would include it.

Therefore you would to use CONVERT(varchar(12), DATEADD(day, -8,...

SET DATEFIRST 1

SELECT (DATEDIFF(week,'20060101',GETDATE())*5)+DATEPART(weekday,GETDATE())

providing it is not run on a Sat/Sun

WHERE DATEDIFF(day,[Date],GETDATE()) <= 7

but this will not utilise any index on the date column

whereas Peters solution will

Your problem occurs when you have multiple deletes invlolving multiple accounts

This would be my (ANSI-92  standard) way of doing it

UPDATE a

SET a.balance = a.balance - d.adjustment

FROM accountBalance a...

Plus it would be more efficient to put the results of the two tables combined into a temp table first and then using that table. This would avoid the multiple...

Try this

SELECT b.[RANK], MAX(b.[Url]) AS [Url], b.[DomainName]

FROM (SELECT MAX(ss.[RANK]) AS [RANK], docs.[DomainName]

    FROM ContainsTable(Machinery_Docs, *, 'Lathe') AS ss

    INNER JOIN Machinery_Docs docs ON ss. = docs.[Url]

   ...

Lookup CHECKSUM in BOL, the recommendation of the use of an additional indexed hash column (int) may improve your queries.

...a well-formed XML schema againt which well-formed HTML can be validated.

There is a XML Schema for XHTML