Yes, that's nice. Not much posting here anyway these days! Easy points

What response time do you expect on such a table without using indexing???

http://www.lazydba.com hosts a DB2 mailing list. You might want to post there.

Celko's book is more for the mensa crowd. Certainly good brain teasers, but I doubt practical use in T-SQL. Computations of the median, for example, do not need to be...

Isn't it strange, Kenneth? Each time I see a posting from you I can add a link to Erland Sommarskog

I might write an article about it

You might consider reading one first

http://www.sommarskog.se/error-handling-II.html

http://www.sommarskog.se/error-handling-I.html

should help

Well, I guess that's exactly what you have to do, if you like it or not

http://www.sommarskog.se/dyn-search.html. Erland discusses there exactly what you're after.

HTH

Oh well Dale, you just got me involved in this evil thread

However, Frank Kaliz and others made it great because they have...

Oh man, once again I recommend reading this this

Dynamic SQL itself is mostly a sub-optimal solution, but dynamic sql in a cursor seems to be even worse.

I knew, I was missing something .

Btw, Kenneth, is the SSWUG SQL2k dead?

Not much mails there lately.

Not sure if I understand you, but are you looking for something like this:

DECLARE @a INT

SET @a = 20040522

SELECT CONVERT(DATETIME,CONVERT(CHAR(8),@a,112))

...

Just for fun, you can do this from with T-SQL

DECLARE @delta INT

EXEC master.dbo.xp_regread

'HKEY_LOCAL_MACHINE'

, 'SYSTEM\CurrentControlSet\Control\TimeZoneInformation'

, 'ActiveTimeBias'

, @delta...

This is no black or white topic, but rather an 'it depends', IMHO.

You might want to have a look at this one