create PROCEDURE [dbo].[SendWelcomeEmails] 
    @Is_Admin bit
AS
BEGIN
-- SET NOCOUNT ON added to prevent extra result sets from
-- interfering with SELECT statements.
SET NOCOUNT ON;


DECLARE @Is_Admin bit,
@Found bit,
@Email varchar(100),
@Name varchar(100),

AS
DECLARE @subject_msg NVARCHAR(MAX),
@Email NVARCHAR(MAX)

IF(@Is_Admin=0) 
SELECT @subject_msg ='subject line message text here',@Email = 'email message text here'

ELSE if (@Is_Admin=1) SELECT @subject_msg1 ='subject line message text here' ,@Email = 'email message text here'