Viewing 15 posts - 57,361 through 57,375 (of 59,059 total)
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...
October 20, 2006 at 2:43 pm
Hi Remi,
Care to explain how you can expand your CASE statement to any number of columns to compare? ![]()
Justice and Remi,
The formula...
October 20, 2006 at 7:32 am
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...
October 20, 2006 at 6:24 am
"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...
October 19, 2006 at 10:12 pm
Me too, Serqiy... however, sometimes you just gotta play the cards you've been dealt.
Do you have a code solution for this that...
October 19, 2006 at 4:23 pm
Would 10000 rows in 16 milliseconds be fast enough?
Here's the test code and the demo of the formula...
--===== If the...
October 19, 2006 at 11:16 am
According to the datasheet available at:
Subqueries are allowed and parameters are allowed...
Compact Yet Capable
SQL Server Mobile offers rich relational database functionality in the small footprint necessary...
October 18, 2006 at 8:39 pm
Crud... didn't see it before but Vladan beat me to the explanation for Cory a long time ago... sorry.
October 18, 2006 at 8:03 pm
Because GETDATE() has a time associated with it. The want all of yesterday... in order to do that, you must strip the time back to midnight of yesterday... all that...
October 18, 2006 at 8:02 pm
There's probably a dozen ways... here's a couple without UDF or Tally table...
declare @table table (ad_str1 varchar(50))
insert @table
select 'apple avenue w' union all
select 'melon road e' union all
select...
October 18, 2006 at 7:54 pm
Junkie,
Would you post the query that creates the example output that you posted? I think that's probably the key, here.
October 18, 2006 at 6:42 pm
Nicasio,
In order for the EXE to release it's grip, it must close connections, destroy the connections, AND successfully exit the command processor window you've invoked. When you run it as...
October 18, 2006 at 6:35 pm
What ever you make with a permanent table, should also work with a temp table except FK constraints. ![]()
October 18, 2006 at 6:05 pm
Actually, Martin gave you the previous answer... but thank you, anyway.
I've not had the time to "play" with it, but you are missing a column alias in your stored procedure which...
October 18, 2006 at 12:35 am
Viewing 15 posts - 57,361 through 57,375 (of 59,059 total)