USP_SIMPLEDATALIST_SCREENPLAN

A simple data list available screening plans.

Definition

Copy


            CREATE procedure dbo.USP_SIMPLEDATALIST_SCREENPLAN as                
                set nocount on;

                select 
                    ID as VALUE, NAME as LABEL 
                from 
                    dbo.SCREENPLAN
                order by 
                    NAME;