SQL Query Help Please....(you guru's should know it).
Tue, 3 Jan 2006 12:06:07 -0800
1. I have a table of Service Request Status Changes.
2. Each time the Service Request is updated, a new RevisionID is generated
which shows what the revision was.
3. The Service Request can be updated several times in a month.
4. I need to report on how many distinct Service Requests were updated in a
month ...
|
Max of different columns
Thu, 29 Dec 2005 23:11:02 -0800
Hi,
Say I have a table like this
Name F1 F2 F3
Joe 3 4 2
Bill 1 3 7
Bob 4 4 2
How can I write a query to select the name and max of F1, F2, F3 so my
results are
Joe 4
Bill 7
Bob 4
Thank you,
Joe ...
|
time(urgent)
Thu, 29 Dec 2005 07:18:02 -0800
Hi
How can i take time > hh:mmAM/PM and time < hh:mmAM/PM from a datetime field.
please give me a sample query for this.
--
Thanks ...
|
Earn money Online - without risk!
Sun, 25 Dec 2005 03:46:15 +0100
Earn money Online - without risk!
For all people, who can utilize money.
Are you on the search for a lucrative source of income? Would you like to
work of at home out of, without
yourself you someone makes directions? Would you yourself like to
determine, when, how much and like often you
salary? Wo ...
|
THE > SUPER-MONEY-SOURCE <
Fri, 23 Dec 2005 01:00:19 +0100
THE > SUPER-MONEY-SOURCE <
Would store / would copy this text or side before the administrator could
remove this letter.
This special program is acquire copyrighting-protected, only with the
participation you the copyrighting at this program. Prohibited utilization
leads to the notice!
THE > SUPER- ...
|
Indexing a table using a Query
Thu, 15 Dec 2005 11:55:03 -0800
Hi,
I have a table as follows:
ID Forename Surname
------ ------------- ---------------
2 John Rodgers
1 Mike Williams
3 Joe Browne
4 Pete Anthony
5 Ken Browne
I would like a query or group of querys that will change ...
|
CNN h??q
Wed, 14 Dec 2005 08:49:46 -0800
mms://a805.v9135e.c9135.g.vm.akamaistream.net/7/805/9135/0029/peta.download.akamai.com/9135/downloads/jcruel_china_dog_med.wmv
...
|
|
|
CNN h??q
Wed, 14 Dec 2005 08:49:45 -0800
mms://a805.v9135e.c9135.g.vm.akamaistream.net/7/805/9135/0029/peta.download.akamai.com/9135/downloads/jcruel_china_dog_med.wmv
...
|
Those animals are innocent in CHINA
Wed, 14 Dec 2005 04:50:41 -0800
mms://a805.v9135e.c9135.g.vm.akamaistream.net/7/805/9135/0029/peta.download.akamai.com/9135/downloads/jcruel_china_dog_med.wmv
...
|
Those animals are innocent in CHINA
Wed, 14 Dec 2005 04:50:36 -0800
mms://a805.v9135e.c9135.g.vm.akamaistream.net/7/805/9135/0029/peta.download.akamai.com/9135/downloads/jcruel_china_dog_med.wmv
...
|
