SQL Server 2000 Report Pack for Microsoft CRM

The SQL Server 2000 Report Pack for Microsoft CRM is a set of six Microsoft SQL Server 2000 Reporting Services reports that work with the Microsoft CRM 1.2 sample database.

With the Report Pack, you have the choice of using the sample reports either as-is or as templates for designing new reports using the SQL Server Reporting Services Report Designer.

Get Table Count without using COUNT

Returns the number of records within a table without having to perform COUNT.

Extending Microsoft SQL Server 2000 Reporting Services with Custom Cod

In this article, I will show you how to leverage the Reporting Services unique extensible architecture to supercharge your report capabilities. First, I will explain how embedded and custom code options work. Next, I will show you how you can leverage custom code to author an advanced report with sales forecasting features.

GetWeekNo

This will return the weekno of the given date

Count elapsed business days between two dates

This is a UDF that counts the days between two dates ignoring weekends and corporate holidays (as supplied in a lookup table). This ignores the time component but could be adjusted should you need to. If both days are on the same work day then the elapsed days is considered 1. If started Monday and […]

Last_Date_Of_Month

Get the Last date of the month for the given month and year

Return the Count of Weekday in a period

Two Method for Return the Count of Weekday between two date!

SQL Server: Blocking Problems

This article focuses on a common problem associated with conflicting locks: blocking. When blocking occurs, a single connection blocks all other connections from reading or modifying a particular piece of data. Learn here how to resolve these issues.

Two True Calendar (independent of @@datefirst)

playyuer@Microshaoft.com inventhttp://www.Microshaoft.com2004-09-29 updatethere is NOT any relation with global variable: @@DATEFIRSTyou can set datefirst any value from 0 to 7 and result can not be affected!

Introduction to MSSQL Server 2000 Analysis Services: Basic Storage Des

This article looks at the basics of storage design for cubes using Analysis services. A good starting point for those getting into the use of analysis services.