SELECT FSPro_UserID FROM tbl_FSPro_Members WHERE OwnerID = AND FSL_TableCode = AND StaffMember = 0 AND OrgType = 'CDRD' AND OrgID = AND FSPro_UserID = UPDATE tbl_FSPro_Members SET Salutation = , FirstName = , LastName = , Title = , Email = , Phone = , PhoneExt = WHERE OwnerID = AND FSL_TableCode = AND StaffMember = 0 AND OrgType = 'CDRD' AND FSPro_UserID = SET NOCOUNT ON INSERT INTO tbl_FSPro_Members(OwnerID, FSL_TableCode, FirstName, LastName, OrgType, OrgID, StaffMember, Email, Salutation, Title, Phone, PhoneExt) VALUES (, , , , 'CDRD', , 0, , , , , ) select FSPro_UserID = @@identity SET NOCOUNT OFF