USP_AMPROIMPORT_GETORCREATEAUCTIONITEMSUBCATEGORY

Returns the ID for a given auction item subcategory and optionally creates the subcategory if it does not exist.

Parameters

Parameter	Parameter Type	Mode
@ID	uniqueidentifier	INOUT
@SUBCATEGORY	nvarchar(100)	IN
@CATEGORYID	uniqueidentifier	IN
@CREATEIFNEEDED	bit	IN
@CHANGEAGENTID	uniqueidentifier	IN
@CHANGEDATE	datetime	IN

Definition

Copy



            create procedure dbo.USP_AMPROIMPORT_GETORCREATEAUCTIONITEMSUBCATEGORY
            (
                @ID uniqueidentifier = null output,
                @SUBCATEGORY nvarchar(100) = '',
                @CATEGORYID uniqueidentifier = null,
                @CREATEIFNEEDED bit = 0,
                @CHANGEAGENTID uniqueidentifier = null,
                @CHANGEDATE datetime = null
            )
            as
            set nocount on;

            set @ID = null;
            select top 1 @ID = ID from dbo.AUCTIONITEMSUBCATEGORY where NAME = @SUBCATEGORY and AUCTIONITEMCATEGORYID = @CATEGORYID;

            if @ID is null and @CREATEIFNEEDED = 1
            begin
                set @ID = newid();

                insert into dbo.AUCTIONITEMSUBCATEGORY(ID, NAME, AUCTIONITEMCATEGORYID, ADDEDBYID, CHANGEDBYID, DATEADDED, DATECHANGED)
                    values(@ID, @SUBCATEGORY, @CATEGORYID, @CHANGEAGENTID, @CHANGEAGENTID, @CHANGEDATE, @CHANGEDATE);
            end