SELECT * FROM tbl_CRM_NoSaleReasons WHERE OwnerId = AND OwnerType = AND ISNULL(mfrid,0) = 0 SELECT COUNT(*) Cnt FROM tbl_CRM_NoSaleReasons WHERE OwnerId = AND OwnerType = INSERT INTO tbl_CRM_NoSaleReasons (OwnerId, OwnerType, ReasonName, ReasonCode, SortRank) VALUES (, , , , )