USP_DATALIST_SALESORDER_ONLINE_UNRESOLVED

                CREATE procedure dbo.USP_DATALIST_SALESORDER_ONLINE_UNRESOLVED
                as
                    set nocount on;

                    select 
                        [SALESORDER].[ID],
                        convert(nvarchar(20),[SALESORDER].[SEQUENCEID]) as [SEQUENCEID],
                        [SALESORDER].[AMOUNT],
                        dbo.UFN_CONSTITUENT_BUILDNAME([SALESORDER].[RECIPIENTID]) as [RECIPIENTNAME],
                        dbo.UFN_CONSTITUENT_BUILDNAME([SALESORDER].[CONSTITUENTID]) as [PATRONNAME],
                        [SALESORDER].[TRANSACTIONDATE],
                        (
                            select dbo.UDA_BUILDLIST(SALESORDERITEM.DESCRIPTION) 
                            from (
                                select distinct top 5 
                                    [SALESORDERID], 
                                    [TYPECODE], 
                                    [COMBINATION].[NAME] + ' - ' + [PRICETYPECODE].[DESCRIPTION] as [DESCRIPTION] 
                                from dbo.[SALESORDERITEM] 
                                inner join dbo.[SALESORDERITEMTICKET] 
                                    on [SALESORDERITEM].[ID] = [SALESORDERITEMTICKET].[ID]
                                inner join dbo.[TICKET] 
                                    on [SALESORDERITEMTICKET].ID = [TICKET].SALESORDERITEMTICKETID and [TICKET].STATUSCODE not in (2, 3)
                                inner join dbo.[SALESORDERITEMTICKETCOMBINATION] 
                                    on [SALESORDERITEMTICKET].[ID] = [SALESORDERITEMTICKETCOMBINATION].[ID]
                                inner join dbo.[COMBINATION] 
                                    on [SALESORDERITEMTICKETCOMBINATION].[COMBINATIONID] = [COMBINATION].[ID]
                                inner join dbo.[PRICETYPECODE] 
                                    on [SALESORDERITEMTICKET].[PRICETYPECODEID] = [PRICETYPECODE].[ID]
                                where [SALESORDERID] = [SALESORDER].[ID] and [TYPECODE] not in (3,4)

                                union all 
                                select top 10 
                                    [SALESORDERID], 
                                    [TYPECODE], 
                                    [DESCRIPTION] 
                                from dbo.[SALESORDERITEM]
                                left join dbo.[SALESORDERITEMTICKET] 
                                    on [SALESORDERITEM].[ID] = [SALESORDERITEMTICKET].[ID]
                                left join dbo.[SALESORDERITEMTICKETCOMBINATION] 
                                    on [SALESORDERITEMTICKET].[ID] = [SALESORDERITEMTICKETCOMBINATION].[ID]
                                where 
                                    [SALESORDERID] = [SALESORDER].[ID] and 
                                    [TYPECODE] not in (3,4) and 
                                    [SALESORDERITEMTICKETCOMBINATION].ID is null

                                order by [TYPECODE], [SALESORDERITEM].[DESCRIPTION]
                            ) as [SALESORDERITEM]
                        ) as [ITEMS]
                        from dbo.[SALESORDER]
                        where 
                            [SALESORDER].[STATUSCODE] = 7 and
                            [SALESORDER].[SALESMETHODTYPECODE] = 2