USP_SIMPLEDATALIST_PLANOUTLINEWITHSITE

                create procedure dbo.USP_SIMPLEDATALIST_PLANOUTLINEWITHSITE
                as
                    select
                        PLANOUTLINE.ID as VALUE, 
                        PLANOUTLINE.NAME + coalesce( ' (' + SITE.NAME + ')', '') as LABEL
                    from dbo.PLANOUTLINE
                        left join dbo.SITE on SITE.ID = PLANOUTLINE.SITEID
                    order by
                        PLANOUTLINE.NAME