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!
View or function 'DelDup' is not updatable because the modification affects multiple base tables.
;with DelDup as (select row_number() over (partition by AWARDS.CandidateID, PLANS.CourseTitle, PLANS.Courselevel order by CandidateID, CourseTitle, Courselevel, AwardDate) as RowNo from tbl_AwardsEnroll AWARDS join tbl_MyCourse PLANS on PLANS.CourseID = AWARDS.CourseID where AWARDS.AwardDate is not null and AWARDS.FullCertAchieved = 'Yes' ) Delete from DelDup where RowNo> 1
Join the community of 500,000 technology professionals and ask your questions.