I added to data to your original sample data

Columns left to right ID_U, Bulding A in, Building A out, Building B in, Building B out and so on

1232010-06-01 00:00:00.0002010-08-08 00:00:00.0002010-08-08...

Hugo Kornelis (11/23/2010)

---

bitbucket-25253 (11/23/2010)

---

Want some more ...

CREATE the temptable as ##

Run the insert code ... do NOT close that instance of SSMS.

Perform the SELECT * FROM ## statement .. right...

Removed further testing showed T-SQL posted was incorrect

Sorry about that, my mistake

Want some more ...

CREATE the temptable as ##

Run the insert code ... do NOT close that instance of SSMS.

Perform the SELECT * FROM ## statement .. right it returns the...

Hugo Kornelis

The server does not matter, the client does. You need at least the SSMS version that ships with SQL Server 2005. It should work against any version server,...

Jeff Moden (11/21/2010)

---

LutzM (11/20/2010)

---

bitbucket-25253 (11/20/2010)

---

...

All this gibbering and jabbering about age -- Your are all youngsters.

I've got a GREAT GRAND DAUGHTER born on April 2nd, 2010. As Jeff...

Here is a proper Merge statement from

http://technet.microsoft.com/en-us/library/bb510625.aspx

Here is the code itself, I believe you should be able to insert your table names, which seem to change, from post to post,...

victorsavinescu (11/21/2010)

---

I have to say: "The truth is somewhere in the middle". The world is gray scale.

So, any beginner just heard the word database today, for the first time,...

Read this, try to impliment the sample code, using a temporary file to receive the output. Once that is done do a Select * FROM the temp file to...

You want to the output $action, dleleted, insert and update items to be output to a temp file , then when the merge complete join the temp file to the...

Have you considered using sp_MSForEachDB? Here is a variation on accomplishing the same effect

http://www.sqlservercentral.com/Forums/Topic705561-146-1.aspx

In order to receive tested help, please post table definition, some sample data in an easy to use format following the procedure listed in article referenced by clicking on the...

ChrisM@home (11/21/2010)

---

bitbucket-25253 (11/20/2010)

---

Stefan Krzywicki

Now did you know the year WWII ended (1945) or did you have to Google...

mandar.dasgupta

Without table definitions, sample data it is difficult to assist you in a meaningful way. To receive a tested answer please post table definition(s), sample data and desired...

Stefan Krzywicki

Now did you know the year WWII ended (1945) or did you have to Google that?

But yes...