no_return should actually be no_output and, in this case, it will be of NO_HELP...  no_output is part of xp_cmdshell and it just means not to display any output it may...

>>Margalit- you may want to identify yourself as the Product Manager for DBMaestro.

It DID sound like a shameless plug... now I know why... almost as bad as spam but lower....

Aw heck... let's continue the corruption to the max... give it an sp_ prefix and drop it into Master

Are you sure it's not just ASCII?

Mostly, because it's just not allowed... read the following from Books Online...

Rules for Regular Identifiers

The rules for the format of regular identifiers are dependent on the database compatibility level, which...

I think the point here is that it doesn't appear that they're teaching such basics anymore.

Eyes must be strained a bit... just can't find that anywhere in your original post.

Please tell me you didn't just publish the real login/password to your site...

I agree with Serqiy on this one... your code is better if you don't use a UDF here.

In SQL 2005, you can use GETDATE() in a UDF... you can also...

Ok... let's say you do want an explicit transaction for that... where's the error check and rollback code that should go with it?

That's probably right in SQL Server 2000... dunno about 2005 with that nice new RowNum and PARTITION OVER statement.

I do gotta ask though,  why on Earth are you declaring an...

Hi there, Koji,

Got your private message and thought I'd post my reply here so that others can see it, as well...

Koji,

There's not much to a Triangular Join (least, not up front)......

Please don't cross-post...

Please don't cross-post...

Please don't cross-post...