USP_SHELL_GETALLTASKS

create procedure dbo.USP_SHELL_GETALLTASKS
as 
select FA.FUNCTIONALAREASPECXML, TASKCATALOG.TASKSPECXML
    from dbo.FUNCTIONALAREACATALOG FA inner join dbo.TASKCATALOG on FA.ID = TASKCATALOG.FUNCTIONALAREAID
    order by FA.SEQUENCE, FA.[NAME], TASKCATALOG.SEQUENCE, TASKCATALOG.[NAME]