SELECT Name FROM tbl_TER_Territories WHERE TerritoryId IN () SELECT cdr_dstname FROM tbl_CDR_Distributors WHERE cdr_recordid IN () ORDER BY cdr_dstname , #htmleditformat( cdr_dstname )# , #htmleditformat( mfrName )# SELECT UserName FROM #ERPDatabaseName#.Users U WITH (NOLOCK) WHERE U.UserID IN () SELECT firstName, LastName, firstName + ' ' + Lastname as RepName FROM tbl_FSPro_members M WITH (NOLOCK) WHERE FSPro_userid IN () AND ownerid = AND fsl_tablecode = ORDER BY LastName, firstName