Good work.

I have used "SQL making SQL" before in generating audit trail triggers.

Security needs to be addressed as well, by adding grants at the end.

Maybe pull the rights from the...

I use the variable type prefix in stored procs, but you need to think about the column names to consistantly indicate their general datatype (number, character, decimal, etc..) to the...

FROM http://vyaskn.tripod.com/code/write_to_file.txt

CREATE PROC write_to_file

@msg VARCHAR(100),

@file VARCHAR(100),

@overwrite BIT = 0

AS

/*

Written by: Narayana Vyas Kondreddi

Date written: January 12th 2001

Purpose: To log messages to text...

This works for me.

if object_id( 'tempdb..#MyTempTable' ) is not null  drop table #MyTempTable

We Don't need to specify that the object is a table, so ignore that...

I haven't used either but ... I know that Embarcadero has a SQL debugger, and I think that Visual Studio also has one. They both claim to work on...

Might as well add the milliseconds while you are at it.

23:59:59.997

because of time clock precision and rounding, you won't be able to go higher than .997.

Looking forward to a...

Opps, I'm Sorry, you are correct. I didn't read that.

But looking at the other postings (spread out here). I still don't think that the question gives enought context to allow...

What was left unsaid was how often you will need to run this query.

As in real life, one query doesn't exist by itself. If you only run this report once...

Its not exactly 'documentation' but ...

Don't forget the ability of VSS or your source control system to use keywords to keep the basic date/time last changed info up to...

Stick with Sybase?