YIKES! I hate to duplicate the logic but I may need to do that in order to avoid potential deadlocks.

1. Had a boss that committed my time to two different clients. I was ordered to login to the second client and edit a line of source code each...

If you're looking for a compiled help file, try this:

http://www.codeproject.com/KB/vb/DBdoc.aspx

YES, I want SQL Server 2000 service pack 5, 6, 7, ...

SQL 2000 Books Online:

Temporary tables are automatically dropped when they go out of scope, unless explicitly dropped using DROP TABLE:

A local temporary table created in a stored procedure is...

If you use T-SQL AVG, NULL values are ignored. If you force NULL values to 0 using ISNULL, your average will change because of the 0 data points.

Not to...

It takes 3 commands to dump the log and shrink the database and log files.

You may wish to change the DBCC commands to specify a target percentage to leave. ...

Some pseudo code that may help:

You may wish to lower the transaction isolation level depending on your needs. For example, IsolationLevel.RepeatableRead

Also, what kind of error should issue a rollback?...

I don't know where your reports are coming from but I would suggest contacting the person who is sending the report and ask that they export the data instead.

They will...

my guess is that you incur the sys table lookup to find out the name of the columns

also by not prefixing with dbo., you incur a sys table lookup for...

This is a great script but to be truly universal or generic, it needs to be enhanced in the if-else section. Right now, it assumes that the primary key...

i have done these types of conversion projects and almost always use a staging table (a permanent table used temporarily) with a cursor and RBAR.

why? because you can go...

Thanks Lowell and Greg.

I really appreciate the quick feedback and sample code!

Sometimes I go down tangents and write a whole bunch of code only to find out that there is...

If I'm understanding this correctly, I believe that would be...

WHERE RoadShowID = @RoadShowID

AND (RoadShowEventID = @RoadShowEventID OR (RoadShowEventID IS NULL AND @RoadShowEventID IS NULL))

AND (SellerID = @SellerID OR (SellerID IS...

Are you saying the column must match the parameter -OR- both the column and the parameter are null?

Wouldn't that be...

WHERE (RoadShowEventID = @RoadShowEventID OR (RoadShowEventID IS NULL AND @RoadShowEventID IS...