USP_SIMPLEDATALIST_MKTQUERYVIEW

Returns a list of all available query views.

Parameters

Parameter	Parameter Type	Mode	Description
@ROOTONLY	bit	IN	Only show root level query views?

Definition

Copy



CREATE procedure dbo.USP_SIMPLEDATALIST_MKTQUERYVIEW
(
  @ROOTONLY bit = 0
)
as
  set nocount on;

  if @ROOTONLY is null
    set @ROOTONLY = 0;

  select
    [ID] as [VALUE],
    [DISPLAYNAME] as [LABEL]
  from
    dbo.[QUERYVIEWCATALOG]
  where
    (0 = @ROOTONLY or [ROOTOBJECT] = @ROOTONLY)
  order by
    [DISPLAYNAME];

  return 0;