Least Cost Provider
The rows look like
1 TX CompanyA 2.25
2 TX CompanyB 2.00
3 NY CompanyB 3.00
4 TN CompanyA 1.25
5 TN CompanyB 1.50
to get the cheapest rate and provider for each location.
Results:
TX CompanyB 2.00
NY CompanyB 3.00
TN CompanyA 1.25
View Complete Forum Thread with Replies
Related Forum Messages:
How Do I Increase A Cost By A Percentage?
currently training on SQL - doing alright so far until this sub-question... Migrate all data from the JOB_COST table into the TOTAL_COST table. For those records that match the COST_ID, update the UPPER_LEVEL and increase the cost by 15%, otherwise insert the records.
View Replies !
Calculate Calls Cost
calculate costs of calls in my work.. I get the calls duration in seconds but I need to make the charging by minute for example 30 second = 1 minute 110 secons = 2 minutes etc
View Replies !
100% CPU COST And Auto Creat Many Documents In DATA
mysql on windows 2003 when i delete all these files , and restart mysql service , it also created may files as : #sql_7c0_0.MYD #sql_7c0_0.MYI #sql_1058_0.MYD #sql_1058_0.MYI error log: 090310 20:57:38 InnoDB: Starting log scan based on checkpoint at InnoDB: log sequence number 0 243222487. InnoDB: Doing recovery: scanned up to log sequence number 0 243222487 090310 20:57:38 InnoDB: Started; log sequence number 0 243222487 090310 20:57:38 [Note] E:Program FilesMySQLMySQL Server 5.0inmysqld-nt: ready for connections. Version: '5.0.45-community-nt' socket: '' port: 3306 MySQL Community Edition (GPL) 090310 20:58:24 InnoDB: Database was not shut down normally! InnoDB: Starting crash recovery. InnoDB: Reading tablespace information from the .ibd files... InnoDB: Restoring possible half-written data pages from the doublewrite InnoDB: buffer... 090310 20:58:25 InnoDB: Starting log scan based on checkpoint at InnoDB: log sequence number 0 243222487. InnoDB: Doing recovery: scanned up to log sequence number 0 243222487 090310 20:58:26 InnoDB: Started; log sequence number 0 243222487 090310 20:58:26 [Note] E:Program FilesMySQLMySQL Server 5.0inmysqld-nt: ready for connections. Version: '5.0.45-community-nt' socket: '' port: 3306 MySQL Community Edition (GPL) 090310 20:59:48 InnoDB: Database was not shut down normally! InnoDB: Starting crash recovery. InnoDB: Reading tablespace information from the .ibd files... InnoDB: Restoring possible half-written data pages from the doublewrite InnoDB: buffer... 090310 20:59:53 InnoDB: Starting log scan based on checkpoint at InnoDB: log sequence number 0 243222487. InnoDB: Doing recovery: scanned up to log sequence number 0 243222487 090310 20:59:57 InnoDB: Started; log sequence number 0 243222487 090310 20:59:57 [Note] E:Program FilesMySQLMySQL Server 5.0inmysqld-nt: ready for connections. Version: '5.0.45-community-nt' socket: '' port: 3306 MySQL Community Edition (GPL) 090310 21:02:41 InnoDB: Database was not shut down normally! InnoDB: Starting crash recovery. InnoDB: Reading tablespace information from the .ibd files... InnoDB: Restoring possible half-written data pages from the doublewrite InnoDB: buffer... 090310 21:02:44 InnoDB: Starting log scan based on checkpoint at InnoDB: log sequence number 0 243222487. InnoDB: Doing recovery: scanned up to log sequence number 0 243222487 090310 21:02:44 InnoDB: Started; log sequence number 0 243222487 090310 21:02:44 [Note] E:Program FilesMySQLMySQL Server 5.0inmysqld-nt: ready for
View Replies !
NySQL Hosting Provider
would be interested in any advice since this is new territory for me -- my experience has only been with Access so far, and for situations where only I could modify the database. But now I have a web application where lots of users need to have password access and be able to modify their own data etc, and where I need to be able to administer the whole thing.
View Replies !
Recommendation For A MySQL Ole DB Provider
I am developping with Visual Studio 2003 + C# + MySQL 4.1 and the OleDb components and am wondering which MySQL OLE DB provider to use. Right now I am using an Ole DB provider for MySQL which I found on www.MySQL.com, but it was written in Feb/2001 and I am wondering if it could be the source of my many problems. I mean, it's great that current Microsoft tools are backward compatible, but I am sure more performant OLE DB drivers have been written for MySQL since. Any OLE DB MySQL developer out there who can help make a recommendation?
View Replies !
OLEDB Provider For MySQL
I'm looking for an OLEDB provider for MySQL. The MySQL website just have some old reference about it. There's some part where it is mentioned but then it points you to the .Net provider which is not the same. Then I found a direct link to download some named MyOLEDB 3.0 which date is 2001! So, I want an OLEDB provider to use MySQL with the Ado components in Borland's Delphi. Is it the only path to use the "OLEDB provider for ODBC" and then the MySQL ODBC Driver the only way to work with MySQL on Delphi?
View Replies !
Cannot Open File Provider=MSDASQL.1;
I'm using Navicat to import some tables into my MySQL Database but I get a weird error and was wondering if anyone around here knew how to resolve it. I feel like it's because I'm trying to make a SQL Server Database and MySQL Database, maybe I need some drivers. The error is: Cannot open file Provider=MSDASQL.1; Persist Security Info=False;....
View Replies !
ADO Error - Data Provider Or Other Service Returned An E_FAIL Status.
I am passing this simple query to MySQL through ADO: SELECT * FROM Images WHERE MasterKey=4313; MySQL returns this result from the command line: mysql> SELECT * FROM Images WHERE MasterKey=4943 ORDER BY OrderNo; +---------+-------------+-----------+----------+-------------+----------------+----------+---------+------------+ | ImageID | Path | MasterKey | Comments | RotateAngle | TimeStamp | CDLetter | OrderNo | EmailByRef | +---------+-------------+-----------+----------+-------------+----------------+----------+---------+------------+ | 28438 | C:img1.JPG | 4943 | | 0 | 20030605080500 | | 1 | 0 | | 28439 | C:img2.JPG | 4943 | | 0 | 20030605080500 | | 2 | 0 | | 28440 | C:img3.JPG | 4943 | | 0 | 00000000000000 | | 3 | 0 | | 28441 | C:img4.JPG | 4943 | | 0 | 00000000000000 | | 5 | 0 | | 28442 | C:img5.JPG | 4943 | | 0 | 00000000000000 | | 6 | 0 | | 28443 | C:img6.JPG | 4943 | | 0 | 20030605080500 | | 7 | 0 | | 28444 | C:img7.JPG | 4943 | | 0 | 00000000000000 | | 8 | 0 | | 28445 | C:img8.JPG | 4943 | | 0 | 00000000000000 | | 9 | 0 | | 28446 | C:img9.JPG | 4943 | | 0 | 00000000000000 | | 10 | 0 | | 28447 | C:imgA.JPG | 4943 | | 0 | 00000000000000 | | 11 | 0 | +---------+-------------+-----------+----------+-------------+----------------+----------+---------+------------+ 10 rows in set (0.03 sec) (I did change the field `Path` to make the grid a bit smaller) When sitting on the second record, I attempt rs.MoveNext() to advance to the third row in the recordset (note that field `TimeStamp` is zeroed out). I then get an error produced by the ADO Cursor Engine with description Data provider or other service returned an E_FAIL status. I've done other testing and it only seems to fail when a field is NULL in the next record. Setting the `TimeStamp` on the third record (`ImageID` = 28440) to a valid date allows me to use rs.MoveNext() to access that row. Also, Field `TimeStamp` is defined in the table description as allowing NULL's. This is becoming quite frustrating. The control center and the command line return the correct records, but ADO is getting stuck.
View Replies !
Cost Of Single Primary Key VS Multiple Primary Key
Could someone advise me on difference between the cost of using a single primary key and multiple primary key? Especially on their effect on joins? For example, with the following table: ---+-----+-------+----- ID | Name| Class | Test ---+-----+-------+----- is it more cost effective to use a single unique primary key (ID) or use a multiple primary key pair (Name + Class + Test)
View Replies !
|
TRACKER
