I have a query that I have to place a beginning and ending date to select the
information needed.  The date is always 30 days for the current date.  Is
there a way to set up a query to select current date minus 30 days that I
will not have to change the date each time?  

I'm using VS 2005 with SQL Server 2005 (all are release versions).  I read
about the new Windows Functions SQL commands in a book, and, using the Query
Designer, created a SQL Query against my database that included
SELECT COUNT(field1) OVER (partition BY field1) AS Num

I have 3 tables Employee (empno,name,city)  , Emp-Pl (empno,noofleaves) , and
Emp-Cl (empno,noofleaves).  Now i require the report in the following format
Sample Data
employee

select case when '02/12/2005' >=  '01/02/2006'  then 'T' else 'F' end
the result return is 'T' why?? (2005 should be < 2006)

How to retrieve all record which has chr(10) in the value of a specific column?
select column1 from table1 where............? (how to write the where
statement)?
Thx!!

I thought this was simple but...
I have a table with a transdate of data type datetime and I want to select
all transactions either for today or for getdate() minus some value.  Looks
to me like the time portion is getting in the way of "where transdate =

I'm used to doing simple queries from individual tables, so I hope someone
can help with this.
I need to select unique data from a column in table1 based on the value of a
column in table2.  The data in the column of table1 is not all unique, so I

I posted this earlier and got an unusable answer, so I'm trying again...
I have a table with a transaction date of datatype datetime.  I need to
select all where where the transaction date is 2 days ago.  If I use
"where transaction date = (getdate( ) -2)" the selection fails ...

Not quite sure how to word this.
Is there any way to change the ordering of SQL Server
I need it to order
ABC2 then ABC12 then ABC110 (this is by entire string, rather than