Here! Here!  I whole-heartedly agree.  While I have seen a few folks (very few) with certifications that are actually good, they seem to be far and few between, at least in...

Not nearly as stupid as trying to emulate spreadsheets in a database, eh?   Should'a listened to you on THAT one...

Thanks again, Serqiy.

Oh... when you said "Did you try to be dummy?", I didn't realize I had to be THAT dumb to get this to work 

Thanks for trying, Serqiy... the tab gets converted to "~WRF0409.tmp" when pasted back into a CMD window.  Have tried ALT-0-9, Ctrl-I, etc... all have the same effect.  And, haven't been able...

Great... thanks for the feedback.

This is just a bit of frustration talking but it's amazing to me that the original post asked for how to solve the "Min of 3" problem and changed to...

Not exactly true... the original post asked specifically for the following...

The analyst has used the Excel Solver to find the lowest value of a each number in a set of...

Hi Remi,

Care to explain how you can expand your CASE statement to any number of columns to compare?

Justice and Remi,

The formula...

Justice,

You're ok... The "example using the random numbers" is just a setup for test data to show the code works (as explained in the comments) and should not be included...

"Just to minimise thinking efforts"... heck, Serqiy, what effort?   I don't think they (the analyst's) thought about it at all   and the users that...

You're welcome... thank you for the feedback.

Me too, Serqiy... however, sometimes you just gotta play the cards you've been dealt.   Do you have a code solution for this that...

Would 10000 rows in 16 milliseconds be fast enough?    Here's the test code and the demo of the formula...

--===== If the...

According to the datasheet available at:

http://download.microsoft.com/download/e/a/1/ea185159-79f1-43f7-8bc6-2027c6a7ebeb/SQLServerMobileDatasheet.doc

Subqueries are allowed and parameters are allowed...

Compact Yet Capable

SQL Server Mobile offers rich relational database functionality in the small footprint necessary...