Hi all,
I have the following query::
UPDATE [dbo_vwAttendance Live] INNER JOIN offRolll ON ([dbo_vwAttendance Live].PER_DOB = offRoll.DoB) AND ([dbo_vwAttendance Live].PER_SNAME = offRolll .Surname) AND ([dbo_vwAttendance Live].PUP_UPN_DFEE = offRolll.UPN) SET [dbo_vwAttendance Live].PAT_TO_DATE = [LeavingDate]
WHERE ((([dbo_vwAttendance Live].PAT_FROM_DATE)=[EntryDate]) AND ((offRolll .LeavingDate)>[PAT_FROM_DATE]));
dbo_vwAttendance Live is a view, on Sql Server 2008, that is built from multiple tables.
My intention is to update the PAT_FROM_DATE for multiple rows in sql to the value in a local table, with a value in the EntryDate field.
However I am getting the following message when I run the query in Access 2003:
"Single-row update/delete affected more than one row of a linked table. Unique index contains duplicate values."
Any help would be appreciated...........
I have the following query::
UPDATE [dbo_vwAttendance Live] INNER JOIN offRolll ON ([dbo_vwAttendance Live].PER_DOB = offRoll.DoB) AND ([dbo_vwAttendance Live].PER_SNAME = offRolll .Surname) AND ([dbo_vwAttendance Live].PUP_UPN_DFEE = offRolll.UPN) SET [dbo_vwAttendance Live].PAT_TO_DATE = [LeavingDate]
WHERE ((([dbo_vwAttendance Live].PAT_FROM_DATE)=[EntryDate]) AND ((offRolll .LeavingDate)>[PAT_FROM_DATE]));
dbo_vwAttendance Live is a view, on Sql Server 2008, that is built from multiple tables.
My intention is to update the PAT_FROM_DATE for multiple rows in sql to the value in a local table, with a value in the EntryDate field.
However I am getting the following message when I run the query in Access 2003:
"Single-row update/delete affected more than one row of a linked table. Unique index contains duplicate values."
Any help would be appreciated...........
