I tried connecting to a Paradox database using DataDirect ODBC drivers (per this question: http://www.experts-exchange.com/Database/Miscellaneous/Q_24276765.html), but I keep getting this erro...
Hi
I am relatively new to databases. I am using MS SQL Server 2005.
I have this huge table (several millions rows) and I need to frequently do lookups with the following WHERE clause on...
Write a query that returns a list of the Regions and the number of employees in each region. The employee only gets added to the count if they had total sales greater than $50,000 last month....
hi,
the domain user in plesk cannot ftp to the account however when i manually add another ftp account they can ftp.
although during the account creation it says "ftp account"
i have ...
Hello i need to create results for stockroom database
i have products, orders, and sales tables and i need to make a operation sum for [orders - sales]
I use sub Queries for the correct resu...
I am trying to execute a sql script that will be used on occassion to delete anywhere from a few records to hundreds of records. Is anyone familiar with the H2 database and can tell me how I c...
could some one represent the attach database on visio
Why can't you embed a Select query in the Set part of an Update. (In access 2007)
Ex.
Update [order] set orderid = (Select Sum(subtotal) from included);
what is a workaround?
Also,...
I have a table that has over 250 fields and a lot of them are not being used. The table has over 50000 rows. I want to have a query that will give me count of how many rows in each table have...
Hi,
I am trying to extract a DB in the above file formats while being able to also read the key fields when the extract is done. I would like to get these into an SQL DB so I can create so...
I am working on the table designs for price quotes and and orders for a website. The quote requests and subsequent quotes will have 1 table for a header record and 1 for the detail records r...
Hi.
I have an old system that uses system dsn odbc drivers and it won't work on 64 bit windows.
If I create an ODBC with odbcad32.exe in system32 i get a 64 bit driver whitch won't work
a...
Apologies for sweeping and general nature of the question. But I don't know where to start. I've inherited a large Access 2003 database. About 500k records and its just under 2GB. (limit of Ac...
I have two SQL statements that produce the desired results. Is there a way that I can combine these to produce the desired results? I am using this code on an ASP Intranet web page.
I attache...
this is the table
Destination Code Rate Month Year companyId
abc 93 0.12 12 2009 3
...
I'm considering the benefits of having a generic DAL based on the DBProviderFactory. This class would have the basic SQL Helper functions like GetDataSet, GetDataReader, ExecuteScalar, Execute...
while executing applet from jsp it askin me to download the missed plugins but i couldn't download any plugins there..
We use Kaseya and I noticed on a report that I was getting this message... a lot!
8:11:24 am 14-Sep-09 Kaseya Agent None 5013 N/A
Overflow detected. The Agent stopped collecting Info...
I have 4 columns with values like these:
begin_left end_left begin_right end_right
81 75 78 64
I want to make a SQL query ...
I'm using Pervasive (v9.5) with some fairly large files. It would be convenient to be able to use external index files, but I can't figure out how to use them. I have used the Pervasive tools ...
Need to pull street number and street name separately from an address. It should be noted that some of these street names may have more than one word in them, i.e.: 123 Oak Lawn Dr.
Thanks!
hi,
I have multiple webstores each with their own separate Mysql databases. The way I envisage my architecture to work is have the webstores interface to the database through a middleware. Ea...
Summary: How to move the cursor to the record identified by unique key when using the simple CTable<> ?
It is related to my earlier question http:Q_24934451.html
Hi experts,
I am abl...
Hi.
Faced completely strange issue with extremely bad performance of MySQL .Net Connector.
Situation is following:
* I have .NET 3.5 application processing files in specific way and w...
Hi
I have following example table
DateTimeField
Value1
I want to select all the rows where DateTimeField is > [xxxx]
until the DateTimeField changes
example data
---...
