Your description is not quite clear - I find it hard to understand what you are trying to do.
-- insert everything from Cv3ordercatalogmasteritem into
-- CV3CatalogClassTypeValue
INSERT INTO CV3CatalogClassTypeValue
([GUID], CatalogMasterGUID)
SELECT
NEWID(), [GUID]
FROM
Cv3ordercatalogmasteritem;
-- insert everything from CV3CatalogClassTypeValue into
-- CV3ClassType
INSERT INTO CV3ClassType
([GUID], ClasstypeGUID)
SELECT
NEWID(), [GUID]
FROM
CV3CatalogClassTypeValue;
finally, once I insert thru a load process (takes more than an hour) I check the values thru this sql. if this helps.
select distinct ocmi.name,
ct.code,
ctv.value
from
cv3ordercatalogmasteritem ocmi
join CV3CatalogClassTypeValue ctv on ctv.CatalogMasterGUID = ocmi.guid
join CV3ClassType ct on ct.guid = ctv.ClassTypeGUID
where
ocmi.expirydate is null
and ct.code like 'Acute Kidney Injury - AKI'
and value='nephrotoxicity'
and ctv.active = 1
and ct.active = 1
order by ocmi.name