I also recommend you lookup CREATE PROCEDURE in Books Online and study it... there's a wealth of information about parameters and defaults for parameters there.

Not sure, but I think "C2" auditing may do this... I've never used it so I don't know all of the details... check Books Online.

I assume they already know this... but they need to do a "disk cleanup" and probably a defrag before they start manually selecting files for deletion.

On second thought... it looks more like you're trying to do control of flow... lookup...

Yes... lookup CASE, BREAK, and RETURN in Books Online (comes free with SQL Server)

Start by removing the BEGIN TRAN/COMMIT statements. They serve no use here because you have no error detection.

Check your Java program... is it keeping a file open?

Get...

Cross posted 5 times... if you answer, recommend you use the first URL below...

http://www.sqlservercentral.com/Forums/Topic471471-9-1.aspx

http://www.sqlservercentral.com/Forums/Topic471473-9-1.aspx

http://www.sqlservercentral.com/Forums/Topic471475-169-1.aspx

http://www.sqlservercentral.com/Forums/Topic471478-65-1.aspx

http://www.sqlservercentral.com/Forums/Topic471481-5-1.aspx

Chandra... this type of cross posting just ticks people off and spreads resources. Good number of...

Cross posted 5 times... if you answer, recommend you use the first URL below...

http://www.sqlservercentral.com/Forums/Topic471471-9-1.aspx

http://www.sqlservercentral.com/Forums/Topic471473-9-1.aspx

http://www.sqlservercentral.com/Forums/Topic471475-169-1.aspx

http://www.sqlservercentral.com/Forums/Topic471478-65-1.aspx

http://www.sqlservercentral.com/Forums/Topic471481-5-1.aspx

Chandra... this type of cross posting just ticks people off and spreads resources. Good number of...

Cross posted 5 times... if you answer, recommend you use the first URL below...

http://www.sqlservercentral.com/Forums/Topic471471-9-1.aspx

http://www.sqlservercentral.com/Forums/Topic471473-9-1.aspx

http://www.sqlservercentral.com/Forums/Topic471475-169-1.aspx

http://www.sqlservercentral.com/Forums/Topic471478-65-1.aspx

http://www.sqlservercentral.com/Forums/Topic471481-5-1.aspx

Chandra... this type of cross posting just ticks people off and spreads resources. Good number of...

Cross posted 5 times... if you answer, recommend you use the first URL below...

http://www.sqlservercentral.com/Forums/Topic471471-9-1.aspx

http://www.sqlservercentral.com/Forums/Topic471473-9-1.aspx

http://www.sqlservercentral.com/Forums/Topic471475-169-1.aspx

http://www.sqlservercentral.com/Forums/Topic471478-65-1.aspx

http://www.sqlservercentral.com/Forums/Topic471481-5-1.aspx

Chandra... this type of cross posting just ticks people off and spreads resources. Good number of...

Cross posted 5 times... if you answer, recommend you use the first URL below...

http://www.sqlservercentral.com/Forums/Topic471471-9-1.aspx

http://www.sqlservercentral.com/Forums/Topic471473-9-1.aspx

http://www.sqlservercentral.com/Forums/Topic471475-169-1.aspx

http://www.sqlservercentral.com/Forums/Topic471478-65-1.aspx

http://www.sqlservercentral.com/Forums/Topic471481-5-1.aspx

Chandra... this type of cross posting just ticks people off and spreads resources. Good number of...

Why... Larry TCG does... 😉

Man, you've got me... never saw such a thing.

But, riddle me this... why do you want the derived table when the query works fine without it?

select dt,datediff(dd,'2003-07-01',dt) as...

Man, do I ever understand that... there was this one thread that I had made about 7 posts on based on something I thought I knew... one of the guys...

Heh... can't dance and it's too wet to plow 🙂

Thanks for the awesome compliment, Lynn... lot's of good folks...