LP_GET_CONTR! too many arguments

Sorry - that formatting was pretty FAIL... here's a better version

SE [impresario]
GO
/****** Object:  StoredProcedure [dbo].[LP_GET_CONTR1]    Script Date: 02/07/2011 09:24:18 ******/
SET ANSI_NULLS OFF
GO
SET QUOTED_IDENTIFIER OFF
GO
 
ALTER PROCEDURE [dbo].[LP_GET_CONTR1]
(
-- @LIST_NO INT = NULL,
@CUSTOMER_NO INT)
AS
Set NoCount On  -- added auto CWR 8/9/2001

DECLARE @CYGIVING MONEY = 0
DECLARE @CYCREDITS MONEY = 0
DECLARE @LYGIVING MONEY = 0
DECLARE @LYCREDITS MONEY = 0

--SET @LIST_NO = 12

-- SET @CUSTOMER_NO = 586 -- TESTING ON M. LONG --
--SET @CUSTOMER_NO = (SELECT CUSTOMER_NO FROM T_LIST_CONTENTS WHERE LIST_NO = @LIST_NO)

/***** GET CURRENT YEAR CONTRIBUTIONS *****/

-- GET THE CURRENT FISCAL YEAR --
declare @cyfyear int

if (month(getdate())>=7)
 begin
 set @cyfyear=year(getdate()+1)
 end
else
 begin
 set @cyfyear=year(getdate())
 end

--select @cyfyear'CURRENT_FISCAL_YEAR'
-- GOT IT --

-- GET INDIVIDUAL GIVING --
SELECT @CYGIVING = SUM(B.CONT_AMT)
FROM T_CUSTOMER A
 LEFT JOIN T_CONTRIBUTION B ON A.CUSTOMER_NO=B.CUSTOMER_NO
 LEFT JOIN T_CAMPAIGN D ON B.CAMPAIGN_NO=D.CAMPAIGN_NO
WHERE A.CUSTOMER_NO = @CUSTOMER_NO
 AND D.DESCRIPTION LIKE '%Annual Individual Giving'
 AND D.FYEAR = @CYFYEAR
 AND B.REF_NO NOT IN (SELECT REF_NO FROM T_CREDITEE)
GROUP BY A.CUSTOMER_NO

-- GET CREDITED GIVING --
SELECT @CYCREDITS = SUM(B.CREDIT_AMT)
FROM T_CUSTOMER A
 LEFT JOIN T_CREDITEE B ON A.CUSTOMER_NO = B.CREDITEE_NO
 LEFT JOIN T_CONTRIBUTION C ON B.REF_NO=C.REF_NO
 LEFT JOIN T_CAMPAIGN D ON C.CAMPAIGN_NO=D.CAMPAIGN_NO
WHERE A.CUSTOMER_NO = @CUSTOMER_NO
 AND D.DESCRIPTION LIKE '%Annual Individual Giving'
 AND D.FYEAR = @CYFYEAR
GROUP BY A.CUSTOMER_NO

-- GET LY INDIVIDUAL GIVING --
SELECT @LYGIVING = SUM(B.CONT_AMT)
FROM T_CUSTOMER A
 LEFT JOIN T_CONTRIBUTION B ON A.CUSTOMER_NO=B.CUSTOMER_NO
 LEFT JOIN T_CAMPAIGN D ON B.CAMPAIGN_NO=D.CAMPAIGN_NO
WHERE A.CUSTOMER_NO = @CUSTOMER_NO
 AND D.DESCRIPTION LIKE '2010 Annual Individual Giving'
-- AND D.FYEAR = @CYFYEAR-1
 AND B.REF_NO NOT IN (SELECT REF_NO FROM T_CREDITEE)
GROUP BY A.CUSTOMER_NO

-- GET LY CREDITED GIVING --
SELECT @LYCREDITS = SUM(B.CREDIT_AMT)
FROM T_CUSTOMER A
 LEFT JOIN T_CREDITEE B ON A.CUSTOMER_NO = B.CREDITEE_NO
 LEFT JOIN T_CONTRIBUTION C ON B.REF_NO=C.REF_NO
 LEFT JOIN T_CAMPAIGN D ON C.CAMPAIGN_NO=D.CAMPAIGN_NO
WHERE A.CUSTOMER_NO = @CUSTOMER_NO
 AND D.DESCRIPTION =  '2010 Annual Individual Giving'
-- AND D.FYEAR = @CYFYEAR-1
GROUP BY A.CUSTOMER_NO

DECLARE @CYTOTAL MONEY
SET @CYTOTAL = @CYGIVING+@CYCREDITS
DECLARE @LYTOTAL MONEY
SET @LYTOTAL = @LYGIVING+@LYCREDITS

DECLARE @SUGGESTED_CONTR_AMT_1 MONEY
SELECT @SUGGESTED_CONTR_AMT_1 = CASE WHEN @CYTOTAL BETWEEN .01 AND 299.99 THEN 300
   WHEN @CYTOTAL BETWEEN 300 AND 4999.99 THEN @CYTOTAL
   WHEN @CYTOTAL >=5000 THEN 0
   WHEN @CYTOTAL = 0 AND @LYTOTAL BETWEEN .01 AND 299.99 THEN 300
   WHEN @CYTOTAL = 0 AND @LYTOTAL BETWEEN 300 AND 4999.99 THEN @LYTOTAL
   WHEN @CYTOTAL = 0 AND @LYTOTAL >= 5000 THEN 0
   ELSE 300 END
   
SELECT @SUGGESTED_CONTR_AMT_1'@suggested_contr_amt_1'

Looks like @list_no has been commented out in your sp. Are you still trying to pass that when you run it? Also, are you running this through an infomaker report or directly in Management Studio?

Hi Brian - thanks for the response!

@list_no was left over from me testing the SP against a list of folks - I commented it out so that i wouldn't be required. 

The procedure is being called when a subscription rollover is done to populate a suggested contribution field in T_CUST_SUBSCRIPTION_SUMMARY.  My understanding was all I would need from the SP was to return a suggested contribution amount.  Since our logic is farily simple, I eliminated the other data Tessitura's sample procedure called for (source_no, no_seats, season_no, etc..) and set the SP to only require a customer_no to run.

Does that help?