USP_REPORT_VSEREPORT
Returns the data for the VSE report.
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @STARTDATE | datetime | IN | |
| @ENDDATE | datetime | IN | |
| @INCLUDEINACTIVE | smallint | IN | |
| @INCLUDEDECEASED | smallint | IN | |
| @USEGIFTDATE | smallint | IN |
Definition
Copy
CREATE procedure dbo.USP_REPORT_VSEREPORT
(
@STARTDATE datetime = null,
@ENDDATE datetime = null,
@INCLUDEINACTIVE smallint = 0,
@INCLUDEDECEASED smallint = 0,
@USEGIFTDATE smallint = 0
)
with execute as owner
as
set nocount on;
declare @vsereporttype smallint
declare @mySTARTDATE datetime
declare @myENDDATE datetime
declare @my@INCLUDEINACTIVE smallint
if @INCLUDEINACTIVE <> 0
Set @my@INCLUDEINACTIVE = 1
else
Set @my@INCLUDEINACTIVE = 0
if @STARTDATE is null
Set @mySTARTDATE = CAST('17530101' AS DATETIME)
else
Set @mySTARTDATE = @STARTDATE
if @ENDDATE is null
Set @myENDDATE = CAST('99991231' AS DATETIME)
else
Set @myENDDATE = @ENDDATE
select Top 1 @vsereporttype = vsetypecode from dbo.vsetype
if @vsereporttype = 0
exec dbo.USP_REPORT_VSEREPORT_COLLEGE @mySTARTDATE,
@myENDDATE,
@my@INCLUDEINACTIVE,
@INCLUDEDECEASED,
@USEGIFTDATE
else
exec dbo.USP_REPORT_VSEREPORT_SECONDARY @mySTARTDATE,
@myENDDATE,
@my@INCLUDEINACTIVE,
@INCLUDEDECEASED,
@USEGIFTDATE