USP_SEARCHLIST_TRACK

Searches for tracks specified by name.

Parameters

Parameter	Parameter Type	Mode	Description
@NAME	nvarchar(50)	IN	Name
@PROGRAMNAME	nvarchar(50)	IN	Program name
@MAXROWS	smallint	IN	Input parameter indicating the maximum number of rows to return.

Definition

Copy



            CREATE procedure dbo.USP_SEARCHLIST_TRACK
            (
                @NAME nvarchar(50) = null,
                @PROGRAMNAME nvarchar(50) = null,
                @MAXROWS smallint = 500
            )
            as
                set @NAME = COALESCE(@NAME,'') + '%' ;
                set @PROGRAMNAME = COALESCE(@PROGRAMNAME,'') + '%' ;

                select top(@MAXROWS)
                    TRACK.[ID],
                    TRACK.[NAME]
                from 
                    dbo.[TRACK]
                where
                    [TRACK].[NAME] LIKE @NAME and
                    (
                        exists(
                            select 1
                            from dbo.[TRACKITEM] with (nolock)
                            inner join dbo.[PROGRAM] with (nolock) on 
                                [TRACKITEM].[PROGRAMID] = [PROGRAM].[ID]
                            where
                                TRACK.ID = TRACKITEM.TRACKID and
                                [PROGRAM].[NAME] like @PROGRAMNAME
                        )
                        or
                        @PROGRAMNAME = '%'
                    )

                order by 
                    NAME asc