First off thank you so much for trying to help me... I've tried the passing and parsing out - that doesn't work. I'm wondering if there's a setting I need.

The raise error - I'm not sure how that works but it didn't return anything -

=Code.ReturnXML(Parameters!C.Value,"C","CUSTOMER","CUSTOMER_NUMBER")

and the sp:

ALTER proc [dbo].[spCUSTOMER_PROMO] @C XML

--, @INPUT_DATE DATETIME

AS

declare @INPUT AS table (

CUSTOMER VARCHAR(35),

CUSTOMER_NUMBER VARCHAR(10),

PREM NUMERIC(18,2),

PREM_VALID VARCHAR(25),

PREM_CODE VARCHAR(25),

FREIGHT NUMERIC(18,2),

FREIGHT_VALID VARCHAR(25),

FREIGHT_CODE VARCHAR(25) )

INSERT INTO @INPUT (CUSTOMER,CUSTOMER_NUMBER,PREM,PREM_VALID,PREM_CODE)

SELECT CS.CUSTOMER_NAME, TA.CUSTOMER_NUMBER,TD.TP_DISCOUNT_AMOUNT,

CONVERT(VARCHAR,TP.TP_EFFECTIVE_START_DATE,101) + ' - ' + CONVERT(VARCHAR,TP.TP_EFFECTIVE_END_DATE,101),

TA.TP_PROMOTION_CODE

FROM TP_CUSTOMER_ASSOCIATIONS AS TA INNER JOIN

TP_PROMOTIONS AS TP ON TP.TP_PROMOTION_CODE = TA.TP_PROMOTION_CODE INNER JOIN

CUSTOMERS AS CS ON TA.CUSTOMER_NUMBER = CS.CUSTOMER_NUMBER INNER JOIN

TP_DISCOUNT_DETAILS AS TD ON TD.TP_PROMOTION_CODE = TP.TP_PROMOTION_CODE INNER JOIN

@C.nodes('/C/CUSTOMER') as m(item) on cast(CS.CUSTOMER_NUMBER as int) = m.item.value('CUSTOMER_NUMBER[1]','integer')

WHERE '03/10/2008' BETWEEN TP.TP_EFFECTIVE_START_DATE AND TP.TP_EFFECTIVE_END_DATE AND

--(CS.CUSTOMER_NUMBER IN (SELECT VALUE FROM dbo.FX_SPLIT(@C,','))) and

TP.TP_PROGRAM_ID IN ('PREMIUM')

INSERT INTO @INPUT (CUSTOMER,CUSTOMER_NUMBER,FREIGHT,PREM_VALID,PREM_CODE)

SELECT CS.CUSTOMER_NAME, TA.CUSTOMER_NUMBER,TD.TP_DISCOUNT_AMOUNT,

CONVERT(VARCHAR,TP.TP_EFFECTIVE_START_DATE,101) + ' - ' + CONVERT(VARCHAR,TP.TP_EFFECTIVE_END_DATE,101),

TA.TP_PROMOTION_CODE

FROM TP_CUSTOMER_ASSOCIATIONS AS TA INNER JOIN

TP_PROMOTIONS AS TP ON TP.TP_PROMOTION_CODE = TA.TP_PROMOTION_CODE INNER JOIN

CUSTOMERS AS CS ON TA.CUSTOMER_NUMBER = CS.CUSTOMER_NUMBER INNER JOIN

TP_DISCOUNT_DETAILS AS TD ON TD.TP_PROMOTION_CODE = TP.TP_PROMOTION_CODE INNER JOIN

@C.nodes('/C/CUSTOMER') as m(item) on cast(CS.CUSTOMER_NUMBER as int) = m.item.value('CUSTOMER_NUMBER[1]','integer')

WHERE '03/10/2008' BETWEEN TP.TP_EFFECTIVE_START_DATE AND TP.TP_EFFECTIVE_END_DATE AND

--(CS.CUSTOMER_NUMBER IN (SELECT * FROM dbo.fnDStringToTable(@C,','))) and

TP.TP_PROGRAM_ID IN ('FREIGHT')

select * from @INPUT ORDER BY CUSTOMER