SA0082 : Consider prefixing column names with table name or table alias

 1SELECT  v.[BusinessEntityID]
 2      , v.[Name]
 3      , ct.[Name] AS [ContactType]
 4      , p.[Title]
 5      , [FirstName]
 6      , [MiddleName]
 7      , [LastName]
 8      , [Suffix]
 9      , pp.[PhoneNumber]
10      , pnt.[Name] AS [PhoneNumberType]
11      , ea.[EmailAddress]
12      , p.[EmailPromotion]
13FROM  [Purchasing].[Vendor] AS v
14INNER JOIN [Person].[BusinessEntityContact] AS bec
15ON  bec.[BusinessEntityID] = v.[BusinessEntityID]
16INNER JOIN [Person].ContactType AS ct
17ON  ct.[ContactTypeID] = bec.[ContactTypeID]
18INNER JOIN [Person].[Person] AS p
19ON  p.[BusinessEntityID] = [PersonID]
20LEFT OUTER JOIN [Person].[EmailAddress] AS ea
21ON  ea.[BusinessEntityID] = p.[BusinessEntityID]
22LEFT OUTER JOIN [Person].[PersonPhone] AS pp
23ON  pp.[BusinessEntityID] = p.[BusinessEntityID]
24LEFT OUTER JOIN [Person].[PhoneNumberType] AS pnt
25ON  pnt.[PhoneNumberTypeID] = pp.[PhoneNumberTypeID];
26
27
28DELETE FROM edh
29FROM  HumanResources.EmployeeDepartmentHistory AS edh
30WHERE  ShiftID = 5 AND
31       edh.StartDate IN( '2010-05-22', '2010-05-22' ) AND
32       DepartmentID LIKE '43 '