I've come up with this but need help on the conditions part.

UPDATE currentevents

SET Event_Description = (SELECT Event_Description

...

Specifically assuming the PK's are correct do the joins and measures look correct?

I'm going to post my Visual Studio project and if anyone can get the connection string to work and tell me how they did it I would appreciate it.

Ok, here is my current connection string. I now throws the error:

Invalid value for key attachdbfilename

Connection string: (this is where the rest of my databases are located)

<connectionStrings>

...

I like the first option you gave. What is the entire path in the "This User" above in the example you provided?

So let me understand. Where do I install my SQL Server during the installation? Or is it a problem with the VS project? Confused.

Im going to post my connection string from my VS project. Can you tell me what the path should look like?

<connectionStrings>

<add name="DefaultConnection" providerName="System.Data.SqlClient" connectionString="AUSTENSSAMSUNG\SQLEXPRESS;Initial...

Not sure how to go about doing that. Can someone walk me thru it? Thanks