rmechaber (9/12/2008)

---

I cannot seem to get any variant of the following to work, as either a simple or searched CASE. Is it possible?

CASE Lunch

WHEN ('Lasagna' OR 'Sausage')...

See if you can't get SQL 2005 Developer... it's the enterprise edition with all the bells and whistles... but it installs onto a client OS (Vista, Win2k, XP, etc).

I used...

Come on if you follow the link to MS's site you find this glaring at you

SQL Server databases have three types of files:

* Primary data...

aaah nm figured it out... though the error is not intuitive...

I needed to run the sp_serveroption command for the source server on the destination server..

Sorin Petcu (8/8/2008)

---

I think you don't understand or you don't want to understand.

Let me see: how it is represented the number -5 in computer? as binar form as 1111111111111111111111111111111111111111111111111111111111111011 and...

Sorin Petcu (8/8/2008)

---

The Square Root of -1 is i, which is an imaginary/complex number."

The computer didn't know nothing about complex numbers. You assume that SQRT function, which is written by...

Sorin Petcu (8/8/2008)

---

mtassin (8/7/2008)

---

Sorin Petcu (8/7/2008)

---

Allof you, you have had wrong! I know from school, and everybody knows, that sqrt function did not support negative numbers (except complex numbers). But...

Sorin Petcu (8/7/2008)

---

Allof you, you have had wrong! I know from school, and everybody knows, that sqrt function did not support negative numbers (except complex numbers). But with this in...

Jack Corbett (8/7/2008)

---

I have no idea why the PRint returns a 6, but the select should return a 0 because sp_executesql completed successfully. If you want to return the...

Nm took a simpler route... made a Sproc that reads the version and returns a 1 for 6+ and a 0 for 5 or less... that works fine.

Thanks anyways.

Sorin Petcu (8/7/2008)

---

rbarryyoung (8/7/2008)

---

Actually, it was not any trick here. Because someone would select 16^16 which returns 0. And this means that the input for sqrt will be a negative...

Sorin Petcu (8/7/2008)

---

what a glitch!!

in BOL it says that SQRT ( float_expression )

and float could be, as definition of float,

float - 1.79E+308 to -2.23E-308, 0 and 2.23E-308 to...

Grant Fritchey (7/30/2008)

---

Not taking advantage of, for example, a Common Table Expression because it's not supported in DB2 (is it?) seems stupid when you consider that the piece of...

Ok maybe I'm just slow... 8 hours of training can do that... but...

If you can make a non-deterministic version of RAND() by feeding it a seed... why do I get...

Please provide appropriate create table, data insert, etc queries so that folks can troubleshoot this. Also, please state what the desired outcome as well as the current outcome are.

Thanks,