This class provides a fast and universal method for accessing SQL Server database. Create Instance At first you create an instance of SqlDatabase class. Dim sqldb As New SqlDatabase("Data Source=(local); Initial Catalog= ; UId = ; Pwd = ;") For more information about connection strings, visit ConnectionStrings.com. ExecuteNonQuery Method Executes a Transact-SQL statement against...
Read more »
WITH set AS ‘Filter (..Members,.CurrentMember.Properties(“GENDER”)= “M”)’ set AS ‘Filter (..Members,.CurrentMember.Properties(“GENDER”)= “F”)’ member Customer.AggMale as ‘Aggregate() member Customer.AggFemale as ‘Aggregate() SELECT {.} ON AXIS(0), {Customer.AggMale,Customer.AggFemale} ON AXIS(1) FROM
Read more »
Recently, we’ve jumped into the world of multi-dimensional OLAP. We’re currently using SQL Server Analysis Services which has been great to create the data cubes and Microsoft Sharepoint with Business Scorecard Manager to render the cubes. The database and cube work wonderfully. We have had issues with Scorecard Manager 2005 though (namingly, it doesn’t render well to...
Read more »
The CODE This article is based on SQL Server 2008 CTP 3. Some of the information may change by the time the product is finally released. Before we create a Function or Stored Procedure that accepts a TABLE variable, we need to define a User Defined TABLE Type. SQL Server 2008 introduced a new...
Read more »