USP_DATALIST_GROUPSALESDEFAULT_PRICING

Lists the IDs for group sales defaults with specific information for flat rate pricing.

Definition

Copy 


            CREATE procedure dbo.USP_DATALIST_GROUPSALESDEFAULT_PRICING
            as
                set nocount on;

                select 
                    ID,
                    USEFLATRATEPRICING,
                    isnull((select top(1) 1 from dbo.RATESCALE),0)
                from dbo.GROUPSALESDEFAULT