September 2007 - Posts

• HALO 3

  Nothing else to be said. GOOCH Read More... Posted Tuesday, September 25, 2007 4:43 PM by Patrick Gallucci | 2 Comments

• SQL Server Function to get the Hour of the Year

  This function returns an integer of the hour of the year passed as a variable. IF EXISTS ( SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N '[util].[uf_GetHourOfYear]' ) AND type IN (N 'FN' , N 'IF' , N 'TF' , N 'FS' , N 'FT' )) DROP FUNCTION [util].[uf_GetHourOfYear] Read More... Posted Tuesday, September 25, 2007 4:32 PM by Patrick Gallucci | 1 Comments Filed under: sql server 2005, SQL Function, SQL Server 2008, Katmai, Data Warehouse

• SQL Server Function to get the Hour of the Month

  This function returns an integer of the hour of the month passed as a variable. IF EXISTS ( SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N '[util].[uf_GetHourOfMonth]' ) AND type IN (N 'FN' , N 'IF' , N 'TF' , N 'FS' , N 'FT' )) DROP FUNCTION Read More... Posted Tuesday, September 25, 2007 4:30 PM by Patrick Gallucci | 1 Comments Filed under: sql server 2005, SQL Function, SQL Server 2008, Data Warehouse

• SQL Server Function to return half year number of days.

  This function returns an integer of the number of days in the half year.   IF EXISTS ( SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N '[util].[uf_GetHalfYearDays]' ) AND type IN (N 'FN' , N 'IF' , N 'TF' , N 'FS' , N 'FT' )) DROP FUNCTION Read More... Posted Monday, September 24, 2007 10:29 AM by Patrick Gallucci | 1 Comments Filed under: sql server 2005, SQL Function, SQL Server 2008

• SQLCMD and the power of the little r

  I would have to say that one of my favorite new utilities that shipped with SQL Server 2005 has been the SQLCMD utility . I am going to demonstrate the use of include files. The following is the complete call syntax for SQLCMD. sqlcmd [{ { -U login_id Read More... Posted Monday, September 03, 2007 10:25 AM by Patrick Gallucci | 2 Comments Filed under: sql server 2005, SQL Script, SQLCMD