spAddUpdate_UserRoles

            CREATE   Procedure [dbo].[spAddUpdate_UserRoles]
            (
            @ClientUsersID int,
            @ClientRolesID int
            )
            AS

            IF NOT EXISTS (SELECT TOP 1 ClientRolesID FROM UserRoles WHERE ClientRolesID=@ClientRolesID AND ClientUsersID=@ClientUsersID)
            /* only insert if the record doesn't yet exist */

            INSERT INTO UserRoles
            (
            ClientUsersID,
            ClientRolesID
            )

            VALUES
            (
            @ClientUsersID,
            @ClientRolesID
            )