V_PDCONSTANTSEGMENT

    create view dbo.V_PDCONSTANTSEGMENT as 
    -- select statements here

    -- the purpose of this view is to allow constant valued segments to use same methodology as the regular segments.

    -- it should NEVER return any rows

        Select NAME, ID from dbo.DESIGNATION where 1=2