I have 2 tables with identical schema on 2 different servers; with one table
containing the most up-to-date data and another containing one day behind
data.  I want to compare these tables and insert the changes into a table
(also identical schema) on a third server.  How can I ...

SQL newbie alert...
I have a table with the fields Location, MachineName ,Hours and Date.
(The actual database is more complex but it will do for the purposes of this
post)

I’m trying to cast and integer type to a varchar and then concatenate
two varchar and ’01’ and convert it into datetime with the following
code:
CONVERT(datetime, { fn CONCAT({ fn CONCAT(CAST(PeriodYear AS varchar),

Hi.........
Its been awhile since I've touched SQL statements, so I need some help
with writing a JOIN statement to query 3 tables.
The dB has 3 tables with values

...just what are they and how do they work?  I've tried looking at SQL (2K)
help but can't find anything that really explains them.
For background, I'm coming from the angle of writing stuff in VB.Net, using
SQL as my data store.  I understand the use of indexes in tables but over

Dear group,
we are running a SQL-Server Database which is about 30 GB large. The
purpose of this database is to contain periodic data from automatic
devices which insert values into some tables.

Our HP representatives are telling us that backing/restoring our MS SQL
Servers with "HP Data Protector (HPDP)" is better and safer than using
MS Sql's backup/restore process.
I have strong hesitations, because MS Sql's processes gives us a great

My multiple level nested corelated query is not fetching correct
result. It work fine on small set of data, but fails on larger set of
data. Any clue?
Explaining data storing and discussing design would be tough for me

Hi EveryExpert!
We are using SQL Server 2000.
I want to get information about all the tables in a given database
('ABD'). Following information need for each table.

Do you guys know what's wrong with a one-to-one relationship?
The reason I want to make it like this is that at the very end of the chain,
the set of keys is huge.  I want to limit the number of columns to be the
key.  i.e. the [company] table has 1 column as the key.  The ...

In oracle you rarely need to rebuild indexes no matter whether you do
massive inserts or deletes. Does the same hold true in sql server?

I am having problems accessing DTS after install SP4 and was wondering
if someone could offer some advice.
I installed SP4 and got the following error after it competed.
Unable to write to response file 'U:\WINDOWS\setup.iss' during

I have a table that contains all the login dates and computer names.  I want
to get the last login date of each computer.
Here is my statement, but it is giving me an error in the FROM statement.
SELECT ComputerName, TimeWritten

This works except when there are duplicate paid values.   If 2 lines have
the same paid value, then top 1 becomes top 2.  Is there any way a single
top value when there are duplicates on the value you are sorting by? I don't
care which one I grab as long as I get one of the ones ...

Is there any way I can run this query faster? Should I take out the ORDER BY
clause? This is supposed to return 17,000 rows and takes around 30 minutes or
so. Is there no way at all to get this result faster?
select r.AttorneyName, r.sitename, r.applicationid, r.clientsurname, r.