USP_BBNC_GETSELECTIONLISTDATA

Retrieves a list of all selections contained in the list specified for BBNC.
Parameters

Parameter	Parameter Type	Mode	Description
@INLISTXML	xml	IN
@ORDERBYNAME	bit	IN
Definition

Copy


            create procedure [dbo].[USP_BBNC_GETSELECTIONLISTDATA](@INLISTXML xml, @ORDERBYNAME bit = 1)
            with execute as caller
            as

            begin
                set nocount on;

                if @ORDERBYNAME = 1
                    select 
                        BBNCIDSETIDMAP.ID, IDSETREGISTER.NAME, RECORDTYPE.NAME as RECORDTYPE, IDSETREGISTER.STATIC, coalesce(IDSETREGISTER.NUMROWS,0) as NUMROWS, IDSETREGISTER.DATEADDED
                    from 
                        dbo.IDSETREGISTER
                    inner join 
                        dbo.BBNCIDSETIDMAP on IDSETREGISTER.ID = BBNCIDSETIDMAP.IDSETREGISTERID
                    inner join 
                        dbo.RECORDTYPE on IDSETREGISTER.RECORDTYPEID = RECORDTYPE.ID
                    where
                        BBNCIDSETIDMAP.ID in (
                            select
                                T.c.value('(@ID)[1]','int') AS 'ID'
                            FROM   
                                @INLISTXML.nodes('/IDList/I') T(c)
                            )
                    order by
                        IDSETREGISTER.NAME
                else
                    select 
                        BBNCIDSETIDMAP.ID, IDSETREGISTER.NAME, RECORDTYPE.NAME as RECORDTYPE, IDSETREGISTER.STATIC, coalesce(IDSETREGISTER.NUMROWS,0) as NUMROWS, IDSETREGISTER.DATEADDED
                    from 
                        dbo.IDSETREGISTER
                    inner join 
                        dbo.BBNCIDSETIDMAP on IDSETREGISTER.ID = BBNCIDSETIDMAP.IDSETREGISTERID
                    inner join 
                        dbo.RECORDTYPE on IDSETREGISTER.RECORDTYPEID = RECORDTYPE.ID
                    where
                        BBNCIDSETIDMAP.ID in (
                            select
                                T.c.value('(@ID)[1]','int') AS 'ID'
                            FROM   
                                @INLISTXML.nodes('/IDList/I') T(c)
                            )
            end