Well kind of..., but really it is still one problem. 

You will probably get better replies than I will give you, but here's a start. 

You "may" need to ALTER...

You probably have done this, but the table name is correct as well? 

(Also, you are aware that  without a WHERE clause, you will be updating all records...) 

I think you are going to have to give us more information on this one.  You've already referenced multiple SP's, cursors, and tables... 

Can you make up dummy data?  I...

We use a table and a function

dbo.ReplaceSpecialCharacters

( @ValueToAlter AS varchar(2000)) RETURNS varchar(2000)

AS

BEGIN

 SELECT @ValueToAlter = REPLACE( @ValueToAlter, SearchForCharacter, ReplacementCharacter) FROM SpecialCharacters

 RETURN ( @ValueToAlter )

END

The table...

Yup!

Line feed is actually CHAR(10), while carriage return is CHAR(13). 

Try this:

 UPDATE @Main SET

     PN = REPLACE( REPLACE( PN, CHAR(13), ' '), CHAR(10), ' ')  

 FROM @Main 

Is this what you want? 

DECLARE @Table TABLE( ID integer IDENTITY, Fruit varchar(10))

INSERT INTO @Table

SELECT 'Orange' UNION ALL

SELECT 'Apple' UNION ALL

SELECT 'Peach'

SELECT * FROM @Table...

Oh my.  I'm not sure why you are creating, (dropping and then creating) the table #Counter.  You are using @Parameters and you already have all this information in #PredictiveDateRange. 

Also,...

I understood that, but 2079-06-06 is not within your sample data... Look forward to your solution. 

When I first started playing with this, I figured it was simply a subselect with grouping by ClientID and Value.  But when I look at your desired results, I am...

Feel for you buddy!  It probably started out as a "home made" system in Access or something. 

Take charge.  Put the #%^ IDENTITY integer...

If you end up needing that number from the varchar field, post some data and I am sure someone here will be able to help you strip it out.  Either...

Greg and Amita.  I would highly recommend re-visiting what PW said.  (I have read this site for some time now, and he is one of the better guru's.) 

[ btw,...

CHAR(33) is an exclamation point.  You can use CHAR(34) double quotes or CHAR(39) single quotes... But you will still probably need something within you SP to seperate out those @Parameters,...

@additional_parameters is going to need to be either on @parameter that is a concatenated string, or you will need to pass it in dynamically and read the two @parameter independently...