OK, if I'd read the question a bit more carefully I would have noticed the reversed assignments.

However, I do wonder if the principal purpose of QOTD is to trick or...

Top will accept a variable if...

It's interesting that a variable can be declared multiple times if it's within a "while" loop (provided that it's only declared once in each iteration).

When I first read the...

Dave, you're right - I should have clarified about regional settings.

But the fact remains that, whatever your regional settings, you can still use "datepart" to get next Saturday's date although...

If you are just looking for the number of Saturdays within the date range (as opposed to a list of all the Saturdays within that range) you can achieve it...

Thank you for the question. I tossed my 5-sided coin and got the right answer, then read up on endpoints.

http://www.simple-talk.com/sql/database-administration/sql-server-endpoints-soup-to-nuts/ gives a good description of endpoints.

I don't know if you consider it more elegant or not, but you can achieve the same result using patindex, eg:

declare @data table (DataValue varchar(10))

insert into

Because the AddressLine column always ends with the appartment number, this can be achieved using LEN. For example, the following code will return all appartment numbers up to 5 digits...