thanks for the suggestions.  This is what I was looking for.

Also,  What about the timing and order of, the full, diff and transaction backups?  What are some standard strategies for implementing...

My original postying was a simple example of what I was trying to do.  This is the following SQL that I used for the update.

INSERT INTO @update

 SELECT DISTINCT FILE_NBR, HOME_DEPARTMENT

 FROM        ...

Each FileNumber belongs to a single Departement.  (File Number is an Employee).

That would be too easy...

Sorry, their are Many different departements.

Thanks for sharing your thoughts on some of the options available for implementing the N-Many concept.  This is a topic that deserves further discussion as this situation is encountered in database design but...

noeld,

Your example has repeated information.  Not quite normalized.

Thanks Steve!

Here's what it looks like just to test out.  I can think of a few ways to put this to use...

CREATE TABLE [dbo].[Email] (

 [ID] [int] IDENTITY (1, 1) NOT...

I appoligize for the delayed reply.

Is taking a test common?  Yes, thats why I expect to take one.  For more than 1/2 the interviews I've taken a test was required.  Some were canned...

What is the source of your new zip codes? We subscribe to a zip code database. Do a complete import every 3 months as zips relation to city...

To land the position I now have, I was one of about 5 DBA's to pass a technical test that was much harder than any MCDBA exam. Certification or...

It seems like this 20G database has been used as the "Default" database for any new information. It didn't start out like this did it? Somewhere along the...

You seem to be using the "Identity" column for more than "Idnetity". Can you explain why? Their are many ways to generate a series of integers, terporary or...

How about apreading the 200 databases across more than one instance of SQL2K? You could still use the "backup every database" option in the maint plan but have multiple...

I have the same problem.

This just worked for me...

Right-Click over the database and refresh.

-Isaiah

You can also connect to SQL through ODBC and Access. The query interface is easy to work with.

-Isaiah