Dear All
I have a simple query which I cannot seem to work out and would like some
help.
I have a small table with data like such

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 ...

Hi im working on a simple function. I have a table with two columns
(datetime) and I need to extract date rom one of them and time from another
one - and then to join it and save it in the variable (which is declered as a
datetime). Please, can somebody help me or advice another ...

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?

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,

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

I have a table that stores three columns of data, namely
1. Order_ID
2. Exam_Start_Date
3. Order_Received_Date

Hi SQL Query Guru,
I have a view like this:
Contract_KEY   Step
1                       1

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.

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.

Say I have a table like this
Name  F1  F2  F3
Joe     3    4    2
Bill      1    3   7

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.