question

I keep getting an error when i try to create my SP any one can provide me with a push that would be great. Msg 102, Level 15, State 1, Procedure usp_Bernard_AddProspectPurge, Line 42 Incorrect syntax near '@ClientKey'. CREATE PROCEDURE [dbo].[usp_AddProspectPurge] @DateCriteria varchar(500), @DateCriteriaOld varchar(500), @ClientKey varchar (50) as BEGIN SET NOCOUNT ON; /********************************************************************************************************************** * Creator: * Date: * Title: * Description: * Examples: * Modifications: Developer Name Date Description ------------------ ---------- ----------------------------------------------------------- * **********************************************************************************************************************/ -------------------------- --- Body of Procedure -- -------------------------- insert into dbo.purgeSetup select ClientID ,DatabaseInstance ,ClientKey ,@DateCriteria ,1 ,null, @DateCriteriaOld From ClientSettings where ClientKey = @ClientKey