Link to home
Start Free TrialLog in
Avatar of davidcahan
davidcahanFlag for United States of America

asked on

Using a Group By in an Update Statement

I'm trying to compile the statement attached below.  I keep getting an error "Incorrect syntax near the keyword 'group'"  Can i not use a group by with an udpate?
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

Open in new window

ASKER CERTIFIED SOLUTION
Avatar of Guy Hengel [angelIII / a3]
Guy Hengel [angelIII / a3]
Flag of Luxembourg image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of davidcahan

ASKER

thanks...that's exactly what i ended up doing.