Update Table With Inner Join

Posted on By David Kittell 
UPDATE table1
SET table1.column1 = table2.column1
	,table1.last_name = table2.last_name
	,table1.first_name = table2.first_name
	,table1.gender = table2.gender
FROM table1
INNER JOIN table2 ON table1.child_column2 = table2.column2
WHERE table1.child_column2 IS NOT NULL;
Originally Posted on September 18, 2013
Last Updated on October 26, 2015
All information on this site is shared with the intention to help. Before any source code or program is ran on a production (non-development) system it is suggested you test it and fully understand what it is doing not just what it appears it is doing. I accept no responsibility for any damage you may do with this code.
Code MSSQL SQL

Related Posts

Folder Exists

Posted on

Public Function FolderExists(ByVal FolderPath As String) As Boolean Dim f As New IO.DirectoryInfo(FolderPath) Return f.Exists End Function If FolderExists("c:windows") = False Then ‘Folder Does’t Exist Else ‘Folder Does Exist End If Originally Posted on December 14, 2013Last Updated on October 26, 2015 All information on this site is shared with…

Read More

LinkedIn API – Full Profile Details

Posted on

Using LinkedIn API Console this URL will provide full profile details XML https://api.linkedin.com/v1/people/~:(id,first-name,last-name,headline,picture-url,industry,summary,specialties,positions:(id,title,summary,start-date,end-date,is-current,company:(id,name,type,size,industry,ticker)),educations:(id,school-name,field-of-study,start-date,end-date,degree,activities,notes),associations,interests,num-recommenders,date-of-birth,publications:(id,title,publisher:(name),authors:(id,name),date,url,summary),patents:(id,title,summary,number,status:(id,name),office:(name),inventors:(id,name),date,url),languages:(id,language:(name),proficiency:(level,name)),skills:(id,skill:(name)),certifications:(id,name,authority:(name),number,start-date,end-date),courses:(id,name,number),recommendations-received:(id,recommendation-type,recommendation-text,recommender),honors-awards,three-current-positions,three-past-positions,volunteer)?format=xml JSON https://api.linkedin.com/v1/people/~:(id,first-name,last-name,headline,picture-url,industry,summary,specialties,positions:(id,title,summary,start-date,end-date,is-current,company:(id,name,type,size,industry,ticker)),educations:(id,school-name,field-of-study,start-date,end-date,degree,activities,notes),associations,interests,num-recommenders,date-of-birth,publications:(id,title,publisher:(name),authors:(id,name),date,url,summary),patents:(id,title,summary,number,status:(id,name),office:(name),inventors:(id,name),date,url),languages:(id,language:(name),proficiency:(level,name)),skills:(id,skill:(name)),certifications:(id,name,authority:(name),number,start-date,end-date),courses:(id,name,number),recommendations-received:(id,recommendation-type,recommendation-text,recommender),honors-awards,three-current-positions,three-past-positions,volunteer)?format=json All information on this site is shared with the intention to help. Before any source code or program is ran on a production (non-development) system it is suggested you test it and fully understand what…

Read More

C# String Like

Posted on

I had a need to find a string like function similar to MSSQL and found this useful function. public static bool StringLike(this string toSearch, string toFind) { return new Regex(@"A" + new Regex(@".|$|^|{|[|(|||)|*|+|?|").Replace(toFind, ch => @"" + ch).Replace(‘_’, ‘.’).Replace("%", ".*") + @"z", RegexOptions.Singleline).IsMatch(toSearch); } bool willBeTrue = StringLike("abcdefg","abcd_fg"); bool willAlsoBeTrue…

Read More