Never been to CodeSnippets before?

Snippets is a public source code repository. Easily build up your personal collection of code snippets, categorize them with tags / keywords, and share them with the world (or not, you can keep them private!)

About this user

Georgi

1 total

On This Page:

  1. 1 Update From sample

Update From sample

to sql update from by horhito on Jan 30, 2007
// sample "update from" sql statement

UPDATE 
	[Crm].[tbPartyLegalEntityData]
SET 
	[CompanyType] = ape.[CompanyType],
	[EmployeesCount] = ape.[EmployeesCount]
FROM 
	[Crm].[tbPartyLegalEntityData] p
INNER JOIN 
	App.[tbApplicationPersonEmployer] AS ape 
ON 
	ape.[Bulstat] = p.[Bulstat]
WHERE 
	ape.[Bulstat] <> '!' 
	AND [ape].[EmployeesCount] IS NOT NULL 
	AND [ape].[CompanyType] IS NOT NULL
1 total

On This Page:

  1. 1 Update From sample