There's some good advice above, and documenting is #1.

document your concerns, get your IT director a copy and ask him to sign off. I'd also contact an HR person or...

Perhaps you could explain what the wrong results are?

Or you can use Dateadd() with other values (hour, minute, etc) and randomly add those to the beginning date.

I've worked with top notch coders, meaning they write great code that isn't buggy, runs well and fast, tests well.

And doesn't meet my needs.

Communication is key, and it's important that...

In sysindexes there's a GROUPID, which is hte filegroup ID, you can join that to sysfilegroups to get the name of the filegroup. Not sure you can get to the...

I'd use an int identity column and then a computed column or a view that concatenates them.

You can't do a varchar auto-incrementing field.

It is the same precision, but can you get

7:00:00.000

7:00:00.000

7:00:00.003

7:00:00.003

7:00:00.007

7:00:00.007

On my desktop (dual core, 2GHz), I get:

.200 (repeated over 100 times)

.310 (repeated, difference of 110ms)

.373 (repeated, difference of 63ms)

.467...

Maybe ascii(substring(field, 1,1))

Very nice, Denis. I like the waterfall and beach pictures.

OK, I've confirmed it's a login thing. So if you have a login, you can leave a comment.

When we put this up, the synch wasn't there and since then, we've...

Just an FYI, this wasn't me. Ted Pin wrote this one and I thought it would be a nice editorial.

I hope I'm a better DBA and writer than musician....

I'll have to check Too tired to dig in tonight, but I thought comments were enabled.

Those are the only kinds of questions we can do without an interview.

That's why the interview is important.

The QOD can't cover every condition. It's designed in this case to see if you understand SUBSTRING rather than picking the best way to do things.

I enjoyed this when David sent it in and hoped it would be received well.

Perhaps all this attention will get Mr Poole writing a bit more. He's good at it...