Хранимая процедура Lin_GetPledgeAdena

BEGIN
EXEC dbo.sp_executesql @statement = N'/************************************************
lin_GetPledgeAdena
    Get pledge adena
INPUT
    @pledge_id INT
OUTPUT
return
made by
    young
date
    2003-12-11
******************************************************/
CREATE PROCEDURE [dbo].[lin_GetPledgeAdena ]
(
    @pledge_id INT
)

as

set nocount on

select isnull( sum(amount) , 0) from user_item (nolock) where warehouse = 2 and char_id = @pledge_id and item_type = 57

'
END