USP_SIMPLEDATALIST_PAGETABS

create procedure dbo.USP_SIMPLEDATALIST_PAGETABS
(
    @PAGEID uniqueidentifier
)
as
    set nocount on;

    with xmlnamespaces ('bb_appfx_pagedefinition' as tns, 'bb_appfx_commontypes' as common)
    select 
        page.tab.value('@ID', 'uniqueidentifier') as VALUE,
        page.tab.value('@Caption', 'nvarchar(max)') as LABEL
    from dbo.PAGEDEFINITIONCATALOG as P
      cross apply P.PAGEDEFINITIONSPEC.nodes('tns:PageDefinitionSpec/tns:Tabs/tns:Tab') as page(tab)
    where P.ID = @PAGEID