USP_DATALIST_REPORTSNAPSHOTS

Returns a list of report snapshots.

Parameters

Parameter	Parameter Type	Mode	Description
@REPORTCATALOGID	uniqueidentifier	IN	Input parameter indicating the context ID for the data list.
@SNAPSHOTNAME	nvarchar(50)	IN	Snapshot name

Definition

Copy



                    CREATE procedure dbo.USP_DATALIST_REPORTSNAPSHOTS
                    (
                        @REPORTCATALOGID uniqueidentifier,
                        @SNAPSHOTNAME nvarchar(50) = null
                    )
                    as
                        set nocount on

                        select
                            ID,
                            HISTORYID,
                            NAME,
                            DESCRIPTION,
                            DATEADDED
                        from dbo.REPORTSNAPSHOT
                        where 
                            REPORTCATALOGID = @REPORTCATALOGID and
                            (@SNAPSHOTNAME is null or NAME = @SNAPSHOTNAME)
                        order by DATEADDED