stored procedure doesnt work

[ajde12]

Hi there,
I have sp which is "god looking" but doesnt work
....any time when I put number for input i Have sum "null"

CREATE PROCEDURE sp_pera
@myInput varchar
AS
SELECT SUM(CustFinTrxnLoyalPoints)
FROM CUSTOMERFINTRANSACTIONS
Where CustAccCardNum = @myInput
GO

CustAccCardNum is varchar in table
CustFinTrxnLoyalPoints is float

thanks

 

[vongrunt]

<deja vu>
varchar how many?
</deja vu>

And CustAccCardNum is of type...?

------
"There's a man... He's bald and wears a short-sleeved shirt, and somehow he's very important to me. I think his name is Homer."
(Jack O'Neill, Stargate)

 

[ajde12]

CustAccCardNum -type of field is varchar
CustFinTrxnLoyalPoints-type of field is float

 

[vongrunt]

I mean length - varchar without explicitely declared length is probably the reason why sproc doesn't work.

Make it to match length of CustAccCardNum field (varchar(20) or whatever it is).

------
"There's a man... He's bald and wears a short-sleeved shirt, and somehow he's very important to me. I think his name is Homer."
(Jack O'Neill, Stargate)

 

[ajde12]

yes
you have right now is ok

thank you very much
have nice day