select territoryName, brokerLevel from request.qmd_userTerritories where territoryId = SET NOCOUNT ON INSERT INTO tbl_CDR_Distributors(OwnerID, FSL_TableCode, cdr_dstname, cdr_dstaddress1, cdr_dstaddress2, cdr_dstcity, cdr_dststate, cdr_dstzip, cdr_dstcountryID, classificationId, cdr_territoryId, setMethod, recordSource, createDate, createUserID, userAdded) VALUES (, , , , , , , , , , , , , getDate(), , ) SELECT NewDistributorID = @@identity SET NOCOUNT OFF