Viewing 15 posts - 1,606 through 1,620 (of 3,221 total)
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...
November 23, 2010 at 1:02 pm
Hugo Kornelis (11/23/2010)
bitbucket-25253 (11/23/2010)
CREATE the temptable as ##
Run the insert code ... do NOT close that instance of SSMS.
Perform the SELECT * FROM ## statement .. right...
November 23, 2010 at 11:33 am
Removed further testing showed T-SQL posted was incorrect
Sorry about that, my mistake
November 23, 2010 at 11:23 am
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...
November 23, 2010 at 8:56 am
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,...
November 23, 2010 at 6:54 am
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...
November 21, 2010 at 5:44 pm
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,...
November 21, 2010 at 4:54 pm
victorsavinescu (11/21/2010)
So, any beginner just heard the word database today, for the first time,...
November 21, 2010 at 2:34 pm
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...
November 21, 2010 at 1:41 pm
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...
November 21, 2010 at 12:52 pm
Have you considered using sp_MSForEachDB? Here is a variation on accomplishing the same effect
http://www.sqlservercentral.com/Forums/Topic705561-146-1.aspx
November 21, 2010 at 11:24 am
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...
November 21, 2010 at 10:15 am
ChrisM@home (11/21/2010)
bitbucket-25253 (11/20/2010)
That's not really a clue so much as asking us to do math.
Now did you know the year WWII ended (1945) or did you have to Google...
November 21, 2010 at 9:05 am
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...
November 20, 2010 at 6:15 pm
Stefan Krzywicki
That's not really a clue so much as asking us to do math.
Now did you know the year WWII ended (1945) or did you have to Google that?
But yes...
November 20, 2010 at 5:03 pm
Viewing 15 posts - 1,606 through 1,620 (of 3,221 total)