USP_DATALIST_SCREENPLAN

This datalist returns all screening plans.
Definition



            CREATE procedure dbo.USP_DATALIST_SCREENPLAN
            as
                set nocount on;

                select     SCREENPLAN.ID,
                        SCREENPLAN.NAME,
                        SCREENPLAN.DESCRIPTION,
                        count(SCREENPLANSTEP.ID)
                from dbo.SCREENPLAN
                left outer join dbo.SCREENPLANSTEP
                    on SCREENPLANSTEP.SCREENPLANID = SCREENPLAN.ID
                group by SCREENPLAN.ID, 
                         SCREENPLAN.NAME, 
                         SCREENPLAN.DESCRIPTION
                order by SCREENPLAN.NAME;