First, I don't understand why the review_date_time of your "Resuts Before" is in ascending order, when the Order by clause of your SQL statement says "SIGHTING_TABLE.review_date_time desc"

However, have you tried:

Order...

Wayne,

noeld is right, you should always specify a field list in the INSERT clause.

However, having said that, I ran your first query in Query Analyzer, substituting literal strings for your e.emp_id...

I wasn't offended, but as a fellow professional I didn't want you to be under the impression that the solution you put forward would return the result set that I...

Chris,

Having SQL Server differentiate between different alpha characters was NOT the problem.  What I wanted was for SQL Server to differentiate between identical values that differ only in the case of...

Instead of having multiple RETURNs in the trigger, why not rewrite the trigger and structure it so that if an error condition is encountered the trigger bypasses the rest of...

Perfect, AJ!  That's exactly what I was looking for.

Thanks!

Don't expect much from me, I haven't worked with Db2 or Neon before.  I'm just brainstorming as a disconnected outsider.

Are you absolutely sure you are getting completely thrown out of the stored procedure? ...

Journeyman: cant you run a profiler trace on users or certain people, whom you suspect of doing so. And if you catch them, then fire them?

The only problem is, that's after the...

Sam,

If you have DTS packages that need to run sequentially, you can use a SQL Agent Job (Management => SQL Server Agent => Jobs in the tree on the left side...

Nicholas Cain: "Would preventing access to MSDB not accompish this?"

Possibly not.  A DTS packags can be executed by a SQL Agent Job, and the SQL Agent Job can be...

First, don't use "Set" to assign a value to a variable.  "Set" is used to initialize an Object, which a variable is not.

Secondly, you have to assign the output of...

Maybe because I didn't know I could, which is why I was asking how to do it in the first place?

Thanks for your help, everyone.

Let me be very clear, here.

I am trying to return the recordset to my DTS package.  I need to process the recordset in the DTS package, not process it in a...

From reading your post it looks like you want to know guests who will be in the hotel for at least one day between 8/1/05 and 8/10/05.  It also looks like...