We saw this problem with developers when we went public and had to start following SARBOX constraints concerning separation of duties... boy was that fun (and still is!)

I got this to work using the sa account but not when I run it with a SQL Server account. I gave rights to the SQL Server account to execute...

Adam, I figured it out... in your example change the small q to a captial Q

Thanks again, Bob

Thanks Adam... I had to tweak it just a bit but it works. One further question... when I run this from a command prompt, after it starts, there is a...

Thanks to both of you for your responses. I see where what you say is true. In my specific case it is not a problem because these fields are part...

Well said, Clinton!

I want to send the result set that it returns.

Yes... windows

It is a true 64-bit OS

Many thanks for the lesson... especially to govinn for the example... your example helped me perfectly!

Bob

I'm not keeping it in two different tables. Someone is manually filling out a spreadsheet that will contain updated information for the table.

I've got 600+ employees in the SQL Server...

Thanks Noel,

I tried what you suggest and it works to a point (I'm pretty new at this so please consider this source!)

Here is the Stored Procedure I set up...****************************

CREATE PROCEDURE...

In Query Analyzer, I get the exact same results from the following two queries...

SELECT {fn NOW()}

SELECT GETDATE()

You got it, Dave!

Thanks very much...

Would this same logic work with one of the variables being varchar and the other three being int?