UFN_MERCHANDISEPRODUCTINSTANCE_CHECKOPTIONCOUNT

Checks to see if product instance options count matches product options count.

Return

Return Type
bit

Parameters

Parameter	Parameter Type	Mode	Description
@MERCHANDISEPRODUCTINSTANCTID	uniqueidentifier	IN

Definition

Copy



create function dbo.UFN_MERCHANDISEPRODUCTINSTANCE_CHECKOPTIONCOUNT(@MERCHANDISEPRODUCTINSTANCTID uniqueidentifier)
returns bit
as begin
    declare @COUNTSMATCH as bit = 0
  declare @OPTIONCOUNT as integer
  declare @INTANCEOPTIONCOUNT as integer

  select
    @OPTIONCOUNT = count(*)
  from
    dbo.MERCHANDISEPRODUCTINSTANCE inner join dbo.MERCHANDISEPRODUCTOPTION on
      MERCHANDISEPRODUCTINSTANCE.MERCHANDISEPRODUCTID = MERCHANDISEPRODUCTOPTION.MERCHANDISEPRODUCTID
  where
    MERCHANDISEPRODUCTINSTANCE.ID = @MERCHANDISEPRODUCTINSTANCTID

  select
    @INTANCEOPTIONCOUNT = count(*)
  from
    dbo.MERCHANDISEPRODUCTINSTANCE inner join dbo.MERCHANDISEPRODUCTINSTANCEOPTIONVALUE on
      MERCHANDISEPRODUCTINSTANCE.ID = MERCHANDISEPRODUCTINSTANCEOPTIONVALUE.MERCHANDISEPRODUCTINSTANCEID
  where
    MERCHANDISEPRODUCTINSTANCE.ID = @MERCHANDISEPRODUCTINSTANCTID

  if @OPTIONCOUNT = @INTANCEOPTIONCOUNT
    set @COUNTSMATCH = 1
  else
    set @COUNTSMATCH = 0      

    return @COUNTSMATCH

end