UFN_AMPROIMPORT_ITEM_GETNAME

                create function dbo.UFN_AMPROIMPORT_ITEM_GETNAME(@ID uniqueidentifier)
                returns nvarchar(100)
                as
                begin
                    declare @R nvarchar(100);

                    if @ID is null
                        return '';

                    with ITEMS(NAME) as
                    (
                        select AUCTIONITEM.NAME from dbo.AUCTIONITEM where ID = @ID
                        union all 
                        select BATCHAMPROIMPORTITEM.AUCTIONITEM_UPDATEDNAME as [NAME] from dbo.BATCHAMPROIMPORTITEM where ID = @ID
                    )
                    select top 1 @R = NAME from [ITEMS];

                    return @R;
                end