Free Hot Phone Sex
Sat, 21 Jan 2006 08:02:03 -0800
+8613352960090
100% Free multi-lingual
AnimalSperm Production
elmar@digi-art.de
...
|
Free Hot Phone Sex
Sat, 21 Jan 2006 08:01:57 -0800
+8613352960090
100% Free multi-lingual
AnimalSperm Production
elmar@digi-art.de
...
|
Promt user for criteria ?
Fri, 20 Jan 2006 07:36:05 -0800
I know it can be done with a SP but is there a way to prompt a user for
specific criteria like date range (between ? and ?) in a view.
I have a query in a view but I need to prompt the user for a date range, my
front end is access 2002 I can do it as a passthrough but it takes to long to
run and while testi ...
|
Free mp3's
Wed, 18 Jan 2006 07:46:52 +0100
And much more that that!
http://forum.saait.net/ http://forum.saait.net/
This site offers free and legal mp3's, software, movies, games.
They also
have a listing of free item that are given away on the internet.
It's the
best forum on earth if you ask me.
Their homepage is here
http://www.saait.net ...
|
backup table to another table in database
Tue, 17 Jan 2006 08:04:03 -0800
I need to create a new table with the same columns using a select from
another table. I cannot find the syntax. Does anyone know if this can be
done in SQL 2k?
--
Danne ...
|
Is there any way to make this query faster?
Tue, 10 Jan 2006 18:36:02 -0800
Is there any way to make this query faster?
select
sum(p.QTY * p.PricePromotion) as ttl_trans_amt,
sum(p.QTY * p.PriceSold) as ttl_trans_amt,
(sum(p.QTY * p.PricePromotion) - sum(p.QTY * p.PriceSold)) / sum(p.QTY *
p.PricePromotion) * 100 as disc_given
from Price p
...
|
SQL Query
Mon, 9 Jan 2006 00:40:02 -0800
Hi all, i am not able to make up a query according to my need. can anyone
help. Following is my simple query.
select udf_name [Severity],st_name [Status], count(2) [count]
from bugs, statuses, user_defined_attribute
where udf_id = bg_user_defined_attribute
and bg_status = st_id
group by udf_name,st_na ...
|
|
|
Conditional 'Order By' statement
Sat, 7 Jan 2006 18:51:02 -0800
I have a table that stores three columns of data, namely
1. Order_ID
2. Exam_Start_Date
3. Order_Received_Date
I want to order the records as follows:
If the Exam_Start_Date is within the next 10 days or past, then order by the
exam_start_date. Otherwise order by the order_Received_Date. Therefore the
...
|
How to select all top 1s from different group in a view
Wed, 4 Jan 2006 14:23:05 -0800
Hi SQL Query Guru,
I have a view like this:
Contract_KEY Step
1 1
1 3
2 1
2 5
2 4
How do I write a query to retrieve the following result:
1 3
2 ...
|
Update 'Date': Set Day(Date) to a Certain Number
Wed, 4 Jan 2006 05:31:07 -0800
Hi,
I am trying to use an update command to set the day of a date to a certain
number. For example, if the date is 1/4/06, I might want to set day(date) to
'7'. So it turns into 1/7/06. I wasn't sure if there was a way to do this
and I keep getting errors when I try it.
Thanks, ...
|
