Hi,
I am getting this SQL error:
Msg 2627, Level 14, State 1, Line 1
Warning: Null value is eliminated by an aggregate or other SET operation
I am trying to insert data from one table into another the first table does have duplicate records but using the max() function they have all been ruled out and i am displaying 12000 individual records when i check the select part of my query. I have check and there are no nulls either.
Any other reason i could be getting this error? Thanks for any help.
I am getting this SQL error:
Msg 2627, Level 14, State 1, Line 1
Warning: Null value is eliminated by an aggregate or other SET operation
I am trying to insert data from one table into another the first table does have duplicate records but using the max() function they have all been ruled out and i am displaying 12000 individual records when i check the select part of my query. I have check and there are no nulls either.
Any other reason i could be getting this error? Thanks for any help.
Code:
INSERT INTO wce_contact (UNIQUEID, EDRS, Company, phone,
address1, address2, city, county, postalcode, record_type)
select EDRS As Uniqueid, max(EDRS) As EDRS, max(Employer_name) As
Employer_name, max(emp_phone) As emp_phone, max(Emp_Address_1) As
Address1, max(Emp_Address_2) As Address2, max(Emp_Address_3) As
Address3, max(Emp_Address_4) As Address4,
max(Emp_Address_pcode1)+' '+ max(Emp_Address_pcode2) As
Postcode, 'Company' from wce_ilr where not edrs is null group by
edrs order by edrs