USP_SIMPLEDATALIST_SALESORDERADDAGENT

Returns username of application users who have made orders.

Definition



        CREATE procedure dbo.USP_SIMPLEDATALIST_SALESORDERADDAGENT
        as
            select 
                [APPUSER].[ID] as VALUE,
                dbo.UFN_APPUSER_GETNAME([APPUSER].[ID]) as LABEL
            from dbo.[APPUSER]
            where exists(
                select [SALESORDER].[ID] 
                from dbo.[SALESORDER] 
                where [SALESORDER].[APPUSERID] = [APPUSER].[ID]
            )
            order by LABEL asc;