MicroStrategy ONE

Microsoft SQL Server

The tables listed below describe the MicroStrategy function support for Microsoft SQL Server databases:

Microsoft SQL Server 2005
Microsoft SQL Server 2008
Microsoft SQL Server 2008 R2 Parallel Data Warehouse
Microsoft SQL Server 2012
Microsoft SQL Server 2012 Parallel Data Warehouse
Microsoft SQL Database

Microsoft SQL Server 2005

Function type	Functions that can be evaluated on the database
Basic functions	Add Average Avg Count GeoMean Max Min Multiply Stdev StdevP Sum Var VarP
Date and time functions	AddDays AddMonths CurrentDate CurrentDateTime CurrentTime Date DayOfMonth DayOfWeek DayOfYear DaysBetween Hour MilliSecond Minute Month MonthEndDate MonthsBetween MonthStartDate Quarter Second Week Year YearEndDate YearStartDate
Internal functions	Banding BandingC Coalesce
Null and Zero functions	IsNotNull IsNull NullToZero ZeroToNull
OLAP functions	OLAPRank
Rank and NTile functions	Rank
String functions	Concat ConcatBlank InitCap LeftStr Length Lower LTrim Position RightStr RTrim SubStr Trim Upper
Arithmetic operators	- x + / U-
Comparison operators	< <= <> = > >= Begins With Between Contains Ends With In Like Not Begins With Not Between Not Contains Not Ends With Not In Not Like
Comparison operators for rank	<= <> = >= Between NotBetween
Logical operators	AND IF Not Or
Data mining functions	None
Financial functions	None
Mathematical functions	Abs Acos Acosh Asin Asinh Atan Atan2 Atanh Ceiling Cos Degrees Exp Floor Int Int2 Ln Log Log10 Mod Power Quotient Radians Randbetween Round Round2 Sin Sqrt Tan Trunc
Statistical functions	None

Microsoft SQL Server 2008

Function type	Functions that can be evaluated on the database
Basic functions	Add Average Avg Count GeoMean Max Min Multiply Stdev StdevP Sum Var VarP
Date and time functions	AddDays AddMonths CurrentDate CurrentDateTime CurrentTime Date DayOfMonth DayOfWeek DayOfYear DaysBetween Hour MilliSecond Minute Month MonthEndDate MonthsBetween MonthStartDate Quarter Second Week Year YearEndDate YearStartDate
Internal functions	Banding BandingC Coalesce
Null and Zero functions	IsNotNull IsNull NullToZero ZeroToNull
OLAP functions	OLAPRank
Rank and NTile functions	Rank
String functions	Concat ConcatBlank InitCap LeftStr Length Lower LTrim Position RightStr RTrim SubStr Trim Upper
Arithmetic operators	- x + / U-
Comparison operators	< <= <> = > >= Begins With Between Contains Ends With In Like Not Begins With Not Between Not Contains Not Ends With Not In Not Like
Comparison operators for rank	<= <> = >= Between NotBetween
Logical operators	AND IF Not Or
Data mining functions	None
Financial functions	None
Mathematical functions	Abs Acos Acosh Asin Asinh Atan Atan2 Atanh Ceiling Cos Degrees Exp Floor Int Int2 Ln Log Log10 Mod Power Quotient Radians Randbetween Round Round2 Sin Sqrt Tan Trunc
Statistical functions	None

Microsoft SQL Server 2008 R2 Parallel Data Warehouse

Function type	Functions that can be evaluated on the database
Basic functions	Add Average Avg Count GeoMean Max Min Multiply Stdev StdevP Sum Var VarP
Date and time functions	AddDays AddMonths CurrentDate CurrentDateTime CurrentTime Date DayOfMonth DayOfWeek DayOfYear DaysBetween Hour MilliSecond Minute Month MonthEndDate MonthsBetween MonthStartDate Quarter Second Week Year YearEndDate YearStartDate
Internal functions	Banding BandingC Coalesce
Null and Zero functions	IsNotNull IsNull NullToZero ZeroToNull
OLAP functions	Lag Lead OLAPRank
Rank and NTile functions	Rank
String functions	Concat ConcatBlank InitCap LeftStr Length Lower LTrim Position RightStr RTrim SubStr Trim Upper
Arithmetic operators	- x + / U-
Comparison operators	< <= <> = > >= Begins With Between Contains Ends With In Like Not Begins With Not Between Not Contains Not Ends With Not In Not Like
Comparison operators for rank	<= <> = >= Between NotBetween
Logical operators	AND IF Not Or
Data mining functions	None
Financial functions	None
Mathematical functions	Abs Acosh Asin Asinh Atan Atanh Ceiling Cos Exp Floor Int Int2 Ln Log Log10 Mod Power Quotient Round Round2 Sin Sqrt Tan Trunc
Statistical functions	None

Microsoft SQL Server 2012

Function type	Functions that can be evaluated on the database
Basic functions	Add Average Avg Count GeoMean Max Min Multiply Stdev StdevP Sum Var VarP
Date and time functions	AddDays AddMonths CurrentDate CurrentDateTime CurrentTime Date DayOfMonth DayOfWeek DayOfYear DaysBetween Hour MilliSecond Minute Month MonthEndDate MonthsBetween MonthStartDate Quarter Second Week Year YearEndDate YearStartDate
Internal functions	Banding BandingC Coalesce
Null and Zero functions	IsNotNull IsNull NullToZero ZeroToNull
OLAP functions	Lag LastInRange Lead MovingAvg MovingCount MovingMax MovingMin MovingStdev MovingStdevP MovingSum OLAPAvg OLAPCount OLAPMax OLAPMin OLAPRank OLAPSum RunningAvg RunningCount RunningMax RunningMin RunningStdev RunningStdevP RunningSum
Rank and NTile functions	Rank
String functions	Concat ConcatBlank InitCap LeftStr Length Lower LTrim Position RightStr RTrim SubStr Trim
Arithmetic operators	- x + / U-
Comparison operators	< <= <> = > >= Begins With Between Contains Ends With In Like Not Begins With Not Between Not Contains Not Ends With Not In Not Like
Comparison operators for rank	<= <> = >= Between NotBetween
Logical operators	AND IF Not Or
Data mining functions	None
Financial functions	None
Mathematical functions	Abs Acos Acosh Asin Asinh Atan Atanh Atan2 Ceiling Cos Exp Floor Int Int2 Ln Log Log10 Mod Power Quotient Round Round2 Sin Sqrt Tan Trunc
Statistical functions	None

Microsoft SQL Server 2012 Parallel Data Warehouse

Function type	Functions that can be evaluated on the database
Basic functions	Add Average Avg Count GeoMean Max Min Multiply Stdev StdevP Sum Var VarP
Date and time functions	AddDays AddMonths CurrentDate CurrentDateTime CurrentTime Date DayOfMonth DayOfWeek DayOfYear DaysBetween Hour MilliSecond Minute Month MonthEndDate MonthsBetween MonthStartDate Quarter Second Week Year YearEndDate YearStartDate
Internal functions	Banding BandingC Coalesce
Null and Zero functions	IsNotNull IsNull NullToZero ZeroToNull
OLAP functions	Lag Lead OLAPRank
Rank and NTile functions	Rank
String functions	Concat ConcatBlank InitCap LeftStr Length Lower LTrim Position RightStr RTrim SubStr Trim Upper
Arithmetic operators	- x + / U-
Comparison operators	< <= <> = > >= Begins With Between Contains Ends With In Like Not Begins With Not Between Not Contains Not Ends With Not In Not Like
Comparison operators for rank	<= <> = >= Between NotBetween
Logical operators	AND IF Not Or
Data mining functions	None
Financial functions	None
Mathematical functions	Abs Acosh Asin Asinh Atan Atanh Ceiling Cos Exp Floor Int Int2 Ln Log Log10 Mod Power Quotient Round Round2 Sin Sqrt Tan Trunc
Statistical functions	None

Microsoft SQL Database

Function type	Functions that can be evaluated on the database
Basic functions	Add Average Avg Count GeoMean Max Min Multiply Stdev StdevP Sum Var VarP
Date and time functions	AddDays AddMonths CurrentDate CurrentDateTime CurrentTime Date DayOfMonth DayOfWeek DayOfYear DaysBetween Hour MilliSecond Minute Month MonthEndDate MonthsBetween MonthStartDate Quarter Second Week Year YearEndDate YearStartDate
Internal functions	Banding BandingC Coalesce
Null and Zero functions	IsNotNull IsNull NullToZero ZeroToNull
OLAP functions	OLAPRank
Rank and NTile functions	Rank
String functions	Concat ConcatBlank InitCap LeftStr Length Lower LTrim Position RightStr RTrim SubStr Trim Upper
Arithmetic operators	- x + / U-
Comparison operators	< <= <> = > >= Begins With Between Contains Ends With In Like Not Begins With Not Between Not Contains Not Ends With Not In Not Like
Comparison operators for rank	<= <> = >= Between NotBetween
Logical operators	AND IF Not Or
Data mining functions	None
Financial functions	None
Mathematical functions	Abs Acos Acosh Asin Asinh Atan Atan2 Atanh Ceiling Cos Degrees Exp Floor Int Int2 Ln Log Log10 Mod Power Quotient Radians Randbetween Round Round2 Sin Sqrt Tan Trunc
Statistical functions	None