Jeff: Now that is a heck of an answer.  Awsome stuff.  I've paid for answers that were not half that good   Thanks I...

The following also works with the example I provided above.  Not sure if it's any better but it does make use of a CTE to make it a little easier...

I'm sure there is a better way but the following works until I can optimize it:

if object_id('Meetings_') is not null drop table Meetings_;

if object_id('Reviews_') is not null drop table Reviews_;

create...

Anders: Without knowing the full design or his reasoning I can't answer for the original post, in mine I included it just to create the error.  From the data given...

Hmm, I was able to duplicate the problem, though I can not explain why.  It appears to be a parsing error by the 2000 engine.  Here is code that will...

Your welcome.  I noticed I didn't post the comments at the top that I intended to.  Basically I tried everything I could think of to get the "Open Symmetric Key"...

I don't see the problem in the statement you provided.  If I take that statement and duplicate it with a "union" between them it still compiles (syntax check anyway) so...

/*------ Set up the  encryption information -----

USE TestEncryptionDB;

go

DROP MASTER KEY;

GO

CREATE MASTER KEY ENCRYPTION BY PASSWORD = 'My p@55w0Rd';

GO

DROP CERTIFICATE cert_test

go

CREATE CERTIFICATE [cert_test]

   ENCRYPTION BY PASSWORD =...

David: Glad I/we could help, and yes I did forget the parenthesis to group the "OR" clause.  I'm also glad to see you got a lot of help/ideas on how to...

Create a stored procedure that has the logic for checking for past due times.  Basically compare current system datetime against the datetime something is due.  The SP can then format...

I couldn't test it but the following should work and makes the code a little less redundant.

select metrocity

      ,saledate

      ,saleprice

   into #temp_

   from property

   where saledate between '2005-01-01' and '2005-08-31'

     ...

Sorry if this is a stupid question, but have you checked the actual IP address on the machine before and after the problem occurs?  While it is unlikely (three hours...

Tom: Once it's set up properly debugging SQL is a FANTASTIC feature.  I love being able to step through the code, examine variable values, etc.  The only problem I've ever...

I can only speculate, but I have had dificulties in the past successfully setting break points in SQL Stored procedures.  There are two things that I found essential:

--Run the following...

Oops!

Your right switch back to the "inserted" table.  That what I get for not reviewing what I just posted.  I had the "deleted"...