Yes. It's actually a task-list for an intranet, but the end result will be more like a forum. I need to order all the comments & replies in...

Well, the first issue is syntactic - the last two inserts are dupes.

However, the other, real, issue is that it also can't handle a third tier. Try...

Adrienne's doesn't seem to work with more than two tiers.

Farrell, I can't make yours work. I've never seen a subquery in a join. Is it missing a parenthesis?

I always did it by this painful process:

@newdate=convert(varchar(4),year(date))+'-'+convert(varchar(2),month(date))+'-'+convert(varchar(2),day(date))+' '+convert(varchar(2),hour(date))+':'+convert(varchar(2),minute(date))

I manually create dates this way to be sure that 'now' is =

00:00 <= now <= 11:59; otherwise you might not get...

Did you two ever resolve this? Were there any changes to the code?

Thanks for the assist, all. The problem in my case is being cause by creation and use of temp tables. Because the newly attached databases have a different...

Ok, the answer is this line:

"Alert based tokens only contain a value when the job is invoked via an alert, otherwise the value is always represented as an empty string."

That...

Is it possible to add triggers to system tables in 2k?

It looks like I can't create a trigger on the sysdatabases table - is that correct?

Uugh. Nothing like a SMOOOOTH upgrade...

How about a script that lists the issue-laden columns?

Anyone?

I'd love to make this as generic as possible. Is there a way to simply reference something like WHERE lookupPK() = inserted.lookupPK()? So it can just be added...

For example, here I've implemented a cursor. This is way inefficient - it took two minute to run against 1564 rows.

DECLARE @userList CURSOR,
@uID int,
@content varchar(8000),
@timestamp datetime

SET @userList = CURSOR...

Well, this is good. Does any one know how to do it without UDFs? I'm running on SQL 7.

Any ideas?