create a hierarchy table to remove records in one table which don't exist in another table

SQLServerCentral » Latest topics

create a hierarchy table to remove records in one table which don't exist in another table

CRM developer wants to create a hierarchy table to remove records in Service table that don't exist in Problem table (using column FKCase to detect this). That hierarchy table will then be available for BI developer to get the data from and inse

more info...