V_PDAPPLICATIONSEGMENT

Fields

Field	Field Type	Null	Description
ID	uniqueidentifier
NAME	nvarchar(100)

Definition

Copy


    CREATE view dbo.V_PDAPPLICATIONSEGMENT as 
    -- select statements here
        select ID, NAME  from dbo.PDAPPLICATIONSEGMENT where APPLICATIONVALUE in (0,1,2,3,4,5,7,11,13,15,18,19)
            union             
        select ID, NAME from dbo.PDAPPLICATIONSEGMENT where APPLICATIONVALUE in (9,10,16) and dbo.UFN_INSTALLEDPRODUCTS_PRODUCTIS('BB1C17BC-9E0B-4683-B490-EE40D511FA05') = 1
            union 
        select ID, NAME  from dbo.PDAPPLICATIONSEGMENT where APPLICATIONVALUE = 12  and dbo.UFN_INSTALLEDPRODUCTS_PRODUCTIS('0321D454-B28B-4FAB-BD58-F2ECC7050594') = 1
            union 
        select ID, NAME  from dbo.PDAPPLICATIONSEGMENT where APPLICATIONVALUE in (6,8) and dbo.UFN_INSTALLEDPRODUCTS_PRODUCTIS('3117D2C8-7F46-42F2-ABEB-B654F2F63046') = 1