Merging two SQL Server tables conditionally into a third table -


Obviously, I'm not a SQL person, so I have to ask for help on simple tasks from the following.

I have two SQL Server 2008 tables: t1 and t2 several identical columns and one key column ( entry_ID ) with. T2 rows that are not present in t1 , but should.

I want to merge those rows with t2 which is not present in t1 , but from me t2 No line that is already present in t1 I want to set the result to fill the new t3

I have seen many solutions online, but the above scenario can not be resolved.

Thank you.

There are several ways to do this UNION ALL or OUTER JOIN .

Assuming that you are using Entry_ID to find similar records, and Entry_ID is unique within each table, here is a OUTER JOIN method:

This receives your record set: T1 and T2 are merged: 

  Select when T1.Entry_ID then 'T2' when T is 2.Entry_ID then ' T1 'All other' both 'end SourceTable, COALESCE (T1.Entry_ID, T2.Entry_ID) Entry_ID, COALESCE (T1.Col1, T2.Col1) Col1, COALESCE (T1.Col2, T2.Col2) Col2, COALESCE As (T1 Col3, T2.Col3) Col3, COALESCE (T1.Col4, T2.Col4) Col4 As T1 in complete form T1.Entry_DI = T2.Entry_ID join the order T2 COALESCE (T1.Entry_DI, T2.Entry_ID)

This is included in T3 Does: 

  Select T3 (Entry_ID, Col1, col2, Col3, Col4) as entry into COALESCE (T1.Entry_DI, T2.Entry_ID). Entry_ID, Collages (T1. Call 1, T2. Cole 1) Coal 1, Coalus (T1 Col2, T2.Col2) Col2, COALESCE (T1.Col3, T2.Col3) Col3, COALESCE (T1.Col4, T2.Col4) T1 Full Exterior Join as T1.Entry_DI = T2.Entry_ID

Then you can T must Entry_ID that must be unique within their tables, and it is used to match between the tables.

Also note the column from the selection row column list in the included statement - the order of the columns in the physical table does not make any difference, INSERT and SELECT will simply line up.


Comments

Post a Comment

Popular posts from this blog

ios - How do I use CFArrayRef in Swift? -

I am using Objective-class in my Swift Project through a bridging header. The method signature looks like this: - Some cement (some type) some parameters; I started by getting an example of class, calling method, and storing the value: var myInstance = MyClassWithThatMethod (); Var cfArr = myInstance.someMethod (some value); Then try to get the value in the array: var valueInArrayThatIWant = CFArrayGetValueAtIndex (cfArr, 0); However, I get the error unmanaged & lt; Cfarray & gt; Not like 'CFArray' . Unmanaged & lt; Cfarray & gt; also means? I looked, but I do not need to change the array in a fast array (though it would be good). I need to be able to get value from the array. I also tried CFArray method to pass in a function: func doSomeStuffOnArray (myArray: NSArray) {} Although I get the same error when using: doSomeStuffOnArray (cfArr); // unmanaged & lt; CFArray & gt; I am using CFArray because I want to sto...
Read more

eclipse plugin - Run java code error: Workspace is closed -

To create an automated project, I created a plug-in project with the following dependencies: Org.eclipse.core.resources org.eclipse.equinox.registry org.eclipse.core.runtime and the following The Java class is located in the src folder: Package Examiner; Import org.eclipse.core.resources.IProject; Import org.eclipse.core.resources.IWorkspaceRoot; Import org.eclipse.core.resources.ResourcesPlugin; Import org.eclipse.core.runtime.CoreException; Import org.eclipse.core.runtime.IProgressMonitor; Import org.eclipse.core.runtime.NullProgressMonitor; Public class tes {public static zero main (string [] args) {// TODO auto generated method stub IProgressMonitor progress monitor = new NullProgressMonitor (); IWorkspaceRoot root = ResourcesPlugin.getWorkspace (). GetRoot (); Ipoject project = root.jetproject ("desired projectname"); Try {Project.create (progress monitor); Project.open (progressMonitor); } Grip (CoreException E) {// TODO Auto generated blocking block e....
Read more

c - Error on building source code in VC 6 -

When I create my project in VC6, the BScMKE reports the following error Linking .. Creating Library ... .. / ... / PB / Bean / Debub / ICEERP.Lib and Object ........ P.B. / Bean / DBube / ICREPlay.APP Browse information file ... BSMMK: ​​error can not be read from BK 1505: file '../../PB/bin/TmpOut/ICReplay/Debug/ICReplay_PB.bsc' Error executing bscmake.exe Can someone help me? 2 Reason for reference from: "ICReplay_PB .bsc "file will be corrupted The trunk of the file will be happening with the compiler running out of disk space or is being interrupted when creating .sbr file I think this answer will help you!
Read more