UFN_AUCTIONITEM_GETVALUE
Returns the value of an auction item or package.
Return
| Return Type |
|---|
| money |
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @AUCTIONITEMID | uniqueidentifier | IN |
Definition
Copy
create function dbo.UFN_AUCTIONITEM_GETVALUE
(
@AUCTIONITEMID uniqueidentifier
)
returns money
as begin
declare @TYPECODE tinyint;
declare @ITEMVALUE money;
select
@TYPECODE = TYPECODE,
@ITEMVALUE = VALUE
from
dbo.AUCTIONITEM
where AUCTIONITEM.ID = @AUCTIONITEMID
if @TYPECODE = 1
select
@ITEMVALUE = sum(VALUE)
from dbo.AUCTIONITEM
where AUCTIONITEM.PACKAGEID = @AUCTIONITEMID
return @ITEMVALUE;
end