I have a table called Bookings which has two important columns;
Booking_Start_Time and Booking_End_Time. These columns are both of type
DATETIME. Given any day how can I calculate how many hours are available
between the hours of 09.00 and 17.30 so a user can see at a glance how ...

I am trying to connect to an Interbase database using Impromptu series
7. As Cognos no longer supplies the ODBC driver, does anyone know
where to get it?
The database comes from a COTS application and I don't have any access

I have a query in Access which returns stock performance data in 3
columns.  I need to run COUNTIF and SUMIF functions on this data, and
reckon that the easiest way to do this is to export the data to an
Excel spreadsheet which contains the necessary functions, then import

I am going to make an application for distributed database
environment. From Microsoft, there are three development tools i.e.
Visual Basic, Visual C++(and the other IDEs for C++ for example
Borland's) and C#, and, from Sun, there is Java. I don't know about

hello..i want to know is there windows API avilable ( free/pay) which
can read data from PDF form & store it in SQL database
thank
pankaj

If I call SQLBindParameter() for a C data type that is a char *, what value
should I use for the ColumnSize parameter (argument 5 of SQLBindParameter())
if the char * points to an empty string (i.e. it is '\0').
Thanks!

This may be a simple question but somehow I couldn't figure out
I have a table A as following
ID  Name
========

I have a database with people and their relationships to others
(parent or child). With that data, I would like to build a family
tree.
Example

I have related fields that pulls data from a record if it matches the
serial number from the other record.
What i want to be able to do is if there is no number for it to get
the data from, i want to be able to type data into those fields but i

I have a file with a id number. filename: Internet
I have another file (filename: Customerserver) that when i put the
internet id number in i want the data of particular field to show up
in customerserver.

I have a database with tables for Members and Counties (Members---(One
To Many)--->Counties). I have a form that allows users to select a
county and get a list of all Members that do business in that county.
SELECT (LIST OF FIELDS)

I need to put a lot of data (ca. 1'000'000-3'000'000 records - 12 fields
each) in a MySQL database each 15 minutes. All of the data will be
frequently searched and indexes are indispensable. I've made some
performance tests on my PC (Celeron 1.7GHz/Barracuda 3 ATA Drive) and I'm

I am an intermediate SQL guy.
I would appreciate it if anyone can see if there's a way to simplify this
query?
It is a MS Access DB. But any tips will be great. Format('16-Sep-2003')

I have a base table magazines (ISSN, title, ... ) and two related
tables, holdings (ISSN, VOL, issues, ...) and subscriptions (ISSN, DATE,
amt, ck#, ...). The keys are the capitalized items.
I wish to create a query which displays the magazine data and the latest

I have an attribute that is required to be stored but it's value is very large and it is seldom used or get involved with normal database operations.  I am thinking of separating it from the parent relation and use another relation for it. This new relation will involve only two ...