USP_SIMPLEDATALIST_DATAFORMINSTANCEFIELDS

create procedure dbo.USP_SIMPLEDATALIST_DATAFORMINSTANCEFIELDS
(
    @DATAFORMINSTANCEID uniqueidentifier
)
as

    set nocount on;

    with xmlnamespaces ('bb_appfx_commontypes' as common)
    select 
        dataform.fields.value('@FieldID', 'nvarchar(200)') as VALUE
    from dbo.DATAFORMINSTANCECATALOG as INSTANCE
        cross apply INSTANCE.FORMUIXML.nodes('common:FormMetaData/common:FormFields/common:FormField') as dataform(fields)
    where INSTANCE.ID = @DATAFORMINSTANCEID