---> insert into tbl_BCRM_Objectives ( OwnerID, OwnerType, ObjName, ObjDescription, ObjType, ObjOwnerType, ObjOwnerID, OwnerRefNum, TargetType, DueDate, PublishDate, UnpublishDate, TotalQuota, QuotaType, OprDistributorRestrict, OprPriorityRestrict, ObjPriority, ObjManagerID, ObjManager2Id, ObjManager3Id, BundleID, limitParticipation, timeframeYear, timeframePeriod, territoryid, allowAutoTargetLinks, objlevel, parentobjectiveid, teamid, oppClosedOnlyAchievement, OprAffiliationRestrict, OprTypeRestrict, QuotaDurationUnit, allowRepTargeting, allowFollowUpStatus, oppApplyToDate, campaignId, MfrOprTypeRestrict, allowProtectBaseStatus, allowMultipleVisits, minItemCaseAmt, minItemAnnualCaseAmt, surveyId, oprAssignedOnlyRestrict, allowRepUnenrollment, unenrollmentNotifyOwner, unenrollmentApprovalRequired, ready, dateReady ) select OwnerID, OwnerType, as ObjName, as ObjDescription, ObjType, ObjOwnerType, ObjOwnerID, OwnerRefNum, TargetType, DueDate, PublishDate, UnpublishDate, 0 TotalQuota, QuotaType, OprDistributorRestrict, OprPriorityRestrict, ObjPriority, as ObjManagerID, as ObjManager2ID, as ObjManager3ID, BundleID, limitParticipation, timeframeYear, timeframePeriod, as territoryid, allowAutoTargetLinks, 'C' objlevel, as parentobjectiveid, teamid, oppClosedOnlyAchievement, OprAffiliationRestrict, OprTypeRestrict, QuotaDurationUnit, allowRepTargeting, allowFollowUpStatus, oppApplyToDate, campaignId, MfrOprTypeRestrict, allowProtectBaseStatus, allowMultipleVisits, minItemCaseAmt, minItemAnnualCaseAmt, surveyId, oprAssignedOnlyRestrict, allowRepUnenrollment, unenrollmentNotifyOwner, unenrollmentApprovalRequired, ready, dateReady from tbl_bcrm_objectives where ownerid = and ownertype = and objectiveid = ;