SQL Server Helper - Date Functions - Get First Day of the Month

SQL Server Helper - Date Functions - Get First Day of the Month: "CREATE FUNCTION [dbo].[ufn_GetFirstDayOfMonth] ( @pInputDate DATETIME )
RETURNS DATETIME
BEGIN

RETURN CAST(CAST(YEAR(@pInputDate) AS VARCHAR(4)) + '/' +
CAST(MONTH(@pInputDate) AS VARCHAR(2)) + '/01' AS DATETIME)

END
GO"

Popular posts from this blog

How To Configure SQL Server Reporting Services 2005 to Run in SharePoint Integrated Mode - PF

How To Configure SQL Server Reporting Services 2005 to Run in SharePoint Integrated Mode - PF Problem We have heard about running SQL Server Reporting Services in SharePoint Integrated Mode but are not really sure how to go about configuring this. Can you provide the details on what capabilities this provides as well as how to do it? Solution Probably the biggest benefit of running Reporting Services in SharePoint Integrated Mode is that you can deploy and manage reports directly in SharePoint rather than the Report Manager web application. This is probably easier for our business users. As a matter of fact you no longer use the Report Manager after you switch to SharePoint Integrated Mode. The highlights of the capabilities provided by SharePoint Integrated Mode are the following: A Report Viewer Web Part that provides report viewing capability, export to other rendering formats, page navigation, search, print and zoom. Web application pages so that you can create subscriptions and sc...
Read more