Gets stats about the specified Dataset (optinally filtered by previous years).
SELECT
Count (patients added this month+year),
Year,
Month
TotalCount (running total of patients added to this month)
FROM @Dataset
Namespace: Caisis.DataAccessAssembly: Caisis.DataAccess (in Caisis.DataAccess.dll) Version: 4.0.4947.22627
Syntax
C# |
---|
public DataTable GetDataSetStats( string datasetSQL, Nullable<int> previousYears ) |
Visual Basic |
---|
Public Function GetDataSetStats ( datasetSQL As String, previousYears As Nullable(Of Integer) ) As DataTable |
Visual C++ |
---|
public: DataTable^ GetDataSetStats( String^ datasetSQL, Nullable<int> previousYears ) |
Parameters
- datasetSQL
- Type: System..::..String
[Missing <param name="datasetSQL"/> documentation for "M:Caisis.DataAccess.DataSetDa.GetDataSetStats(System.String,System.Nullable{System.Int32})"]
- previousYears
- Type: System..::..Nullable<(Of <(<'Int32>)>)>
[Missing <param name="previousYears"/> documentation for "M:Caisis.DataAccess.DataSetDa.GetDataSetStats(System.String,System.Nullable{System.Int32})"]
Return Value
Type: DataTable[Missing <returns> documentation for "M:Caisis.DataAccess.DataSetDa.GetDataSetStats(System.String,System.Nullable{System.Int32})"]