Mine should work on SQL 2000. Did you try it?

Yep, they are that way on my SQL 2008 box also.

Well here is a corrected and tested version that should work for all of the databases, including the Reporting DBs:

ALTER...

Try editing the Connection properties and on the Definition tab, edit the Command Text and put the following in front of the text that is already there:

EXEC sp_setapprole 'test',{encrypt N...

Hmm, thats a new one on me. Of course I hardly ever get to work with DB's with different collations.

Try this altered version and let me know...

What edition of SQL Server do you have?

And what kind of step is it? (CmdExec, T-SQL, etc.)

As far as I know.

Heh, I made the same mistakes. Here is a correct version:

Select MID,

(((1.0+Dt1/100.0)

*(1.0+Dt2/100.0)

*(1.0+Dt3/100.0)

*(1.0+Dt4/100.0)

*(1.0+Dt5/100.0)

*(1.0+Dt6/100.0)

*(1.0+Dt7/100.0)

*(1.0+Dt8/100.0)

*(1.0+Dt9/100.0)

*(1.0+Dt10/100.0)

*(1.0+Dt11/100.0)

*(1.0+Dt12/100.0))-1.0) * 100.0

from Prod_Issue

This gives the same results as the Excel.

Karthik: Product multiplies, Sum adds. What you want is something like this:

Select MID,

( 1.0+Dt1/100.0-1.0

+ 1.0+Dt2/100.0-1.0

+ 1.0+Dt3/100.0-1.0

+ 1.0+Dt4/100.0-1.0

+ 1.0+Dt5/100.0-1.0

+ 1.0+Dt6/100.0-1.0

+ 1.0+Dt7/100.0-1.0

+ 1.0+Dt8/100.0-1.0

+ 1.0+Dt9/100.0-1.0

+ 1.0+Dt10/100.0-1.0

+ 1.0+Dt11/100.0-1.0

+ 1.0+Dt12/100.0-1.0) * 100.0

from...

Simple way:

Delete From YourTable T

Where EXISTS( Select * from YourTable T2

Where T.REFNOCOLUMN = T2.REFNOCOLUMN

...

As I recall in .Net, you need to switch from SQLClient.net to ODBCClient. (not sure?)

Yes, it takes more space. But Unicode/NChar is the solution for this and this is exactly the reason that it exists.

I don't know about the "N" before the quote,...

I have seen it both ways, though I myself may not be actually "using" it. Most of the time...

Plain text. By the way the ODBC Encrypt does not store the password,...

Actually, I do notice one difference between your code and the BOL Example. This line:

Is actually like this in the example:

EXEC sp_setapprole 'test',{encrypt N...

Sadly, I have never had the opportunity to implement the ODBC Encryption feature, so I cannot help you much. Hopefully, someone else here can. If you do figure...