YouTube Converter 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...

YouTube ConverterWITH set [Male] AS ‘Filter ([Customer].[CustomerID].Members,[Customer].CurrentMember.Properties(“GENDER”)= “M”)’ set [Female] AS ‘Filter ([Customer].[CustomerID].Members,[Customer].CurrentMember.Properties(“GENDER”)= “F”)’ member Customer.AggMale as ‘Aggregate([Male]) member...

YouTube ConverterRecently, 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...

YouTube ConverterThe 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 User defined TABLE type. A TABLE type represents the structure of a table...