CREATE PROCEDURE [dbo].[sp_GetPayments_byUserID]
@UserID int,
@Sum money =null output 
AS

SET NOCOUNT ON

select 
Payment.Dat,
Payment.TransactionID,
Payment.AmountPaid,
Payment.PaymentID, 
item.ItemID,
item.WebAddress
into #t
from Payment, item
where	Payment.UserID=@UserID
and		Item.ItemID=Payment.ItemID
order by PaymentID

select @Sum=sum(AmountPaid) from #t

select
PaymentID,
Dat,
AmountPaid,
TransactionID,
ItemID,
WebAddress
from #t
order by PaymentID