USP_SEARCHLIST_OLAPDATASOURCE

Used to lookup an Data Mart (OLAP data source)

Parameters

Parameter	Parameter Type	Mode	Description
@SOURCENAME	nvarchar(255)	IN	Name
@MAXROWS	smallint	IN	Input parameter indicating the maximum number of rows to return.

Definition

Copy



CREATE procedure dbo.USP_SEARCHLIST_OLAPDATASOURCE
(
    @SOURCENAME nvarchar(255) = null,
    @MAXROWS smallint = 500
)
as
    set @SOURCENAME = dbo.UFN_SEARCHCRITERIA_GETLIKEPARAMETERVALUE(@SOURCENAME, 0, null);

    select top(@MAXROWS)
        ID,
        SOURCENAME,
        SOURCEDESCRIPTION
    from 
        dbo.OLAPDATASOURCE
    where
         ((@SOURCENAME is null) or (SOURCENAME like @SOURCENAME))
    order by 
        SOURCENAME asc;