Hi! what command should i include in the SELECT query statement so that i can
filter away the duplicate record(see only unique row)...eg by time. Thks!

I USE SQL SEVER 2000
I HAVE A TABLE IN A DB CALLED "Trend_Velocità"
I HAVE A QUERY ON A ADO OBECT "SELECT * FROM Trend_Velocità" in a Vb program
IF THE DEFAULT VALUE OF LANGUAGE IS ENGLISH NO PROBLEM

I have a business need to display some date specific data to a selcect group
of users 3 bussiness days before everyone else is allowed to see it.
THere are many fields I will be displaying across many tables. The date I am
using is ONLY in the primary table (meaning I don't have ...

This is a tuff one not sure if it can be done with an SQL query, I'm
thinking along the lines of an inner join, but I'm not really sure.
I have a table that is used to refer to location_names as nodes and sites as
the leaf nodes it is the site names that I want to return based on ...

I have a hierarchy structure copied from excel to a table in databse SQL.
Here is what i have in SQL table:
Continent    Country    City
Europe       

I have a column that have numbers & letters combined in a field. What sql
command would remove the letters only, not the numbers?
I have a table called “customer” and the column in that table is called
“customtext4”. I want to change over 5000 records in this “customtext4” field

I'm quering about 5 tables using inner join.  On one of the tables i just
want to count or sum up the results. Here is the example I'm trying to get
working.  When I add the SUM(Private.PrivateIDs) I get an error.  Is
something like this possible?

Which is the more efficient way to clear the contents of a table:
DELETE FROM tableName
TRUNCATE TABLE tableName
Or DROP the table then create it again?

I am looking at a table, using Enterprise Manager, that has several fields
defined
as Binary.  All I seem to be able to see is the literal "<Binary>" in these
fields.

I wish to use a variable i a query that can change under execute.
Here are some of my rows, i wish to make the f3 colonne
F1   F2   F3(my new colonne)
10   text 10

The @parameters that I am receiving into my SQL query in SQL Serer 2000
Reporting Services are based on user selection from a drop down combo box.
If the user selects a name it will return an integer. An alternative to
selecting a single name the user can select 'ALL' of which ...

I'm trying to create a JSP page which access's a database of about 3 million
records. What i am trying to do is display this in a webpage table with 15
results per page. I can get a display of 15 records but the only start from
the first row in the table. I have found out that ...

Does anyone have logic to take an hl7 file format and create a flat file.
I am having a bit of difficulty..............
Any help would be a lifesaver....
Thanks

FYI, all about SQL is new to me. I would appreciate it if someone could help
me on
the following :-
1) I have one text file containing 8 fields separated by pipes (|) and 1000

I have a problem to run a query like this scenario:
i have players in a table who have scored in many matches and i want to take
the 5 latest.
The latest i want to multiply with 1.0 and then after with 0.8, 0.6, 0.4 and