Thanks your method works! Just needed to truncate WorkOrder table and resubmit query.

This is what I did:

insert into w.CategoryID

select distinct c.CategoryID, c.CategoryName

from Category c

join WorkOrder w join WorkOrderDetailedReports wod

on c.CategoryName = wod.Category

on w.WorkOrderID = wod.Id

What would you suggest?

Thanks for the response. I just stared using T-SQL and SQL Server, so this is all new to me. I was given a task to normalize data and produce a...