UFN_COMBINATIONAVAILABILITY_GETSALESMETHODS

This function returns combination availability sales methods given its ID.

Return

Return Type
table

Parameters

Parameter	Parameter Type	Mode	Description
@COMBINATIONAVAILABILITYID	uniqueidentifier	IN

Definition

Copy



        create function dbo.UFN_COMBINATIONAVAILABILITY_GETSALESMETHODS
    (
      @COMBINATIONAVAILABILITYID uniqueidentifier
    )
        returns table
        as return
            select
                ID,
        SALESMETHODID
            from
                dbo.COMBINATIONAVAILABILITYSALESMETHOD
            where
                COMBINATIONAVAILABILITYID=@COMBINATIONAVAILABILITYID;