SELECT * FROM tbl_OPR_ClientOperators WHERE OwnerId = AND FSLTableCode = AND oprcompanytype IN ('C','G') AND CRMActive = 'Y' ORDER BY oprcompanytype, CompanyName SELECT COUNT(*) Cnt FROM tbl_OPR_ClientOperators WHERE OwnerId = AND FSLTableCode = INSERT INTO tbl_OPR_ClientOperators (OwnerId, FSLTableCode, CompanyName, dbaName, Address, Address2, City, State, ZipCode, CountryID, recordSource, CRMActive, oprcompanytype ) VALUES (, , , , , , , , , , , , ) SELECT * FROM tbl_OPR_ClientOperators WHERE oprcompanytype IN ('C','G') AND OwnerId = AND FSLTableCode = SELECT TOP 1 * FROM tbl_CHO_Operators WHERE cho_dbaname = UPDATE tbl_OPR_ClientOperators SET oprparentco = WHERE OperatorId = AND OwnerId = AND FSLTableCode =