I had a few people from here assist in getting this query to be able to save in Visual Studio as I wasn't able to figure out the syntax error. Now, as I'm running it, it will not execute. Can anyone see what might be the issue?
-- ============================================= -- Author: Lloyd Pederson -- Updated On: 11/17/2015 -- Description: Checks the given Employer Code, or Employer Name -- against the Threshold Macro Table -- ============================================= ALTER PROCEDURE [dbo].[PHS_A_THRESHOLD_MACRO_SP] -- Add the parameters for the stored procedure here @strEmpCode varchar(20), @strEmpName varchar(20) AS BEGIN -- SET NOCOUNT ON added to prevent extra result sets from -- interfering with SELECT statements. SET NOCOUNT ON; -- Insert statements for procedure here SELECT Client_Name, Employer_Code FROM PHS_A_THRESHOLD_MACRO WHERE Client_Name LIKE '%' + @strEmpName + '%' OR (Employer_Code = @strEmpCode) END