USP_REPORT_DEPARTMENTCODES

Stored procedure as datasource for filtering departments.

Definition



            create procedure dbo.USP_REPORT_DEPARTMENTCODES
            as
                set nocount on;

                begin try
                    select ID, DESCRIPTION, SEQUENCE
                    from dbo.DEPARTMENTCODE
                    union all
                    select null as ID, 'All departments' as DESCRIPTION, 0 as SEQUENCE
                    order by SEQUENCE
                end try

                begin catch
                    exec dbo.USP_RAISE_ERROR;
                    return 1;
                end catch

                return 0;