UFN_AMPROIMPORT_LOOKUPITEM
Returns the ID from AUCTIONITEM for an item found in AuctionMaestro Pro.
Return
| Return Type |
|---|
| uniqueidentifier |
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @LOOKUPID | nvarchar(100) | IN |
Definition
Copy
CREATE function dbo.UFN_AMPROIMPORT_LOOKUPITEM
(
@LOOKUPID nvarchar(100)
)
returns uniqueidentifier
as
begin
declare @R uniqueidentifier = null;
select top 1
@R = ID
from dbo.AUCTIONITEM
where AUCTIONITEM.LOOKUPID = @LOOKUPID
order by DATEADDED;
return @R;
end