with datediff all I can get it to return is months or a total of the
days...
so if the difference in dates is 12 months 4 days how do I adjust the
SQL to accommodate both?

Is SQL Query Analyzer available anywhere as a stand alone application?
Thanks

I have a database with 2 users - 'dbo' and 'user1'.
Currently:
=> 'dbo' is tied to login - 'login1'
=> 'user1' is not tied to any login.

I need some help.
I am trying to write a query which does the following
SELECT * from table1 where field1=(SELECT distinct field1 FROM table1
WHERE field2='2005' or field2='2010')

Dear Group
I'd be grateful if you can give me some advice on the following.
An application I wrote uses an MSDE backend and I wonder whether
there's a way (even for the system administrator) of not seeing or

I am responsible for backing up two Windows 2003 servers, one of which
contains a non-simple SQL database.
The tapedrive is a DLT1 without any automated loading (I must load a new
tape each day by hand).

I want to find who and when the changes wasdone to a particular database or
table into the database of SQL 2000 server.
Is there any way to monitor it ?
With regards

I have a table called WorkItem.  It models a chunk of work done during
a working day.
It has two columns that I'm interested in:
Start (smalldatetime) - the TIME the work block is begun

I need what would be similar to a cross tab query in Access.
First Column down needs to show all the months, column headings would
be the day of the month....
     1 2 3 4 etc...

I have problem with linked servers (MS SQL Server 2k)- when I try to execute
query(update, insert..) with linked servers, I have message Login failed for
user 'null'. This is very strange problem, some computers in AD (2k3 std)
don't have this error, when the other have this problem ...

Environment
1)We are using VBA,MS Access 2000/2003 and SQL Server 2000 in our
project.
2)We need to use Rational clear case as the SCM tool.

I have a problem to insert(update) a long text (more than 64K) into
SQL 2000 (datatype - 'text'). It cuts the data and insert only 64K.
MSDN says: "When the ntext, text, and image data values get larger,
however, they must be handled on a block-by-block basis. Bot

I have two tables with the same layout, and I need to join them in a way
that all the records from each table will be "on top" of each other (not
sure how else to word that).
For example:

I have three tables that I need to join and I'm not sure how to do it.
tblCompany - main address table for all companies, key is CompanyID
tblUsers - list of users, joined to tblCompany with CompanyID, unique key is
UserID

I have a database with three tables
tbl_listings - listings of houses on for sale
tbl_intersted - table which tracks if a user is interested in the
listing, it has two columns mls(the key for tbl_listings) and user(user