I know this might be a little off topic, but I couldn't find a more relevent
group so I thought I would start here. I am looking for some data and was
wondering if anyone could help point me the right direction. The data I'm
looking for a basically a list of countries that is then ...

   This application is being developed on Win2K.
   I'm building my first Firebird application.  It's
running fine and I can insert and select data from my
first table.  Now I want to make it an embedded app.

Suppose I have table t1:
CREATE TABLE t1
 (BHID             BIGINT          NOT NULL,
  CONTROLLER       INTEGER,

I am a longtime DB developer but have been doing alot more DBA (Oracle
8i) type responsabilities lately.  One thing I am somewhat struggling
on is the maintainence of indices.  I have read many posts on
fragmentation, most of which tell you to look in the data dictionary,

I'm new!
(I'm familiarized with Yahoo Groups but not at all with Google Groups)
I would like to have some Help...
Thanks!!!

I have a series of numbers and I'd like to find for each serie :
- the average value
- the count of values greater than 5
- the count of values greater than 15

I am a SQL newbie. Please help.
I don't know how to express this query in SQL:
"Find projects in which 'John' and 'Gabriel' (but not limited to) are working".
Can anybody show an SQL query for this question?

I have a formula in Crystal Reports 9:
if(isnull({RECORDED_SERVICE.SERVICE_STATUS_MONIKER})) then
{RECORDED_SERVICE.UNITS}
else

Thank you all once again!
Sincerely,
Abhi

Go molam bilo koj sto znae kako da najdam golem broj email adresi hostirani
na MK provajderi

I have a view in which I have 3 cols...(pno,ptno,diff)..diff is the
difference in time in minutes.I want to calculate Median(diff) group
by pno,ptno...using a sql query for SQL server...
Any help is greatly appreciated..

I need to write one database application for MS Windows soon, but I am
not sure which database to use. I am familiar with MySQL which I like,
but I am not sure if it is good anywhere else than in the web. I know
something about MS Access also and I think this could be one of the

Further to a recent post, can anyone suggest a resource that will assist in
the conversion of what appears to be a Btrieve db (developed in the mid
'90s) to SQL 2k?  I plan to use DTS and hope (very much indeed) that I can
find an appropriate driver for this old monster.

i have one big table with measurement data consisting of a timestamp and
a station id and 3 value columns:
to get an info about the newest data i developed this SQL:
SELECT max( tstamp ), stat FROM mw0000 WHERE  1 GROUP BY stat ORDER BY

Could SOmeone tell me how to connect the database to visual basic 6.0.
The database is using Microsoft Access XP Version. Then i convert it
to 97 version. I went to the control panel, administrative Tools,Data
Souce(ODBC), I click on Microsoft Access Database, Add, Driver to