We value your feedback.
Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!
Update a Set a.[Name] = upper(Max(b.ResortName)), a.Address1 = upper(Max(b.Address1)), a.Address2 = upper(Max(b.Address2)), a.City = upper(Max(b.City)), a.[State] = upper(Max(b.State)), a.PostalCode = upper(Max(b.PostalCode)), a.Country = upper(Max(b.Country)), a.Phone = b.Phone, a.Featured = b.Featured, a.DateModified = getdate(), a.ModifiedUserID = @UserID From dbo.PackageImportStaging b join dbo.Resorts a on b.ExternalIDResort = a.ExternalID Where b.Bad = 0 and b.ImportID = @ImportID group by b.ExternalIDResort