HI All,I need help modifying my SP to check and see if there are duplicate "person_id" exist in NGweb_bulk_enrollment and prompt for " Person already exist" Can this be done with Prompt? Here is my code:what this SP does it grabs the person id from the application currently logged in and adds it to bulk enrollment table. I am not sure where/how to add the "Count(*) row or something like that to check for duplicates?Thanks a lot!!CREATE PROCEDURE [dbo].[AutoEnroll] @person_id varchar(36), @user_id int AS DECLARE @practice_id char(4) DECLARE @user_name varchar(50) DECLARE @psswrd varchar(10) DECLARE @enc_id uniqueidentifier SET NOCOUNT ON SELECT TOP 1 @practice_id = pe.practice_id FROM patient_encounter pe INNER JOIN patient pt ON pt.person_id = pe.person_id AND pt.practice_id = pe.practice_id INNER JOIN person p ON p.person_id = pe.person_id WHERE pe.person_id = @person_id AND p.email_address <> '' ORDER BY pe.enc_timestamp DESC -- Build the user name and password SELECT @user_name = RTRIM(LTRIM(last_name)) + RTRIM(LTRIM(LEFT(first_name, 1))) + RTRIM(LTRIM(CONVERT(varchar, person_nbr))) , @psswrd = date_of_birth FROM person WHERE person_id = @person_id begin INSERT INTO ngweb_bulk_enrollments(row_id, person_id,practice_id, user_name,password,security_answer,forgot_password_question,forgot_password_answer,created_by,create_timestamp,modified_by,modified_timestamp) Values (newid(),@person_id,'0001',@user_name, @psswrd,'red','color','red',@user_id,current_timestamp, @user_id,current_timestamp) ENDSET NOCOUNT off;GO