USP_SIMPLEDATALIST_ORGANIZATIONPOSITIONMYTEAMLIST

A simple data list of hardcoded values for the Organization Position My Team.

Definition

Copy 


                CREATE procedure dbo.USP_SIMPLEDATALIST_ORGANIZATIONPOSITIONMYTEAMLIST
                as
                    set nocount on;

                    select cast('00000000-0000-0000-0000-000000000001' as uniqueidentifier) VALUE, 
                         cast('My team - Direct reports only' as nvarchar(50)) as LABEL 
                    union all
                    select cast('00000000-0000-0000-0000-000000000002' as uniqueidentifier) VALUE, 
                         cast('My team - Including indirect reports' as nvarchar(50)) as LABEL