In your declare cursor statement, your select statement is returning many fields.  For each field in this select list, you must supply a variable in the FETCH NEXT statement to hold the...

exec sp_recompile <tablename> marks dependant stored procedures and triggers for recompilation.

exec sp_refreshview <viewname> refreshes the metadata for views

Does anyone know how to recompile or refresh user defined functions?

This should work:

Declare @CCRecv varchar(4000)

Declare @CreditScore nvarchar(5)

Declare @ErrorText nvarchar(1000)

DECLARE my_cursor CURSOR FOR

 select c.CCReceive

 from CreditScoreQueue c

 where queuetime between '2004-08-26' and '2004-08-27'

OPEN my_cursor

FETCH NEXT FROM my_cursor

INTO @CCRecv

WHILE @@FETCH_STATUS = 0

BEGIN

 exec...