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