Browse by Tags

• Business Intelligence
• Data Warehouse
• Katmai
• SQL Script
• SQL Server 2008
• SQL Server Stored Procedure

• How to drop all tables, all views, and all stored procedures from a SQL 2005 DB...

  This is a follow-up to the blog entry from Jasper Jugan . This is a modification to the script to allow for schema specific deletes of the SP's, Views and I added Functions.   create procedure usp_DropSPFunctionsViews as   -- variable to object Read More... Posted Tuesday, April 29, 2008 4:00 PM by Patrick Gallucci | 2 Comments Filed under: sql server 2005, SQL Function, SQL Script, SQL Server Stored Procedure

• SQL Server Function to merge a date with a time

  I use this when I need to join two fields. One has a date, the other has a time.   IF EXISTS ( SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N '[util].[uf_MergeDate2Time]' ) AND type in (N 'FN' , N 'IF' , N 'TF' , N 'FS' , N 'FT' )) DROP Read More... Posted Sunday, November 18, 2007 9:03 PM by Patrick Gallucci | 1 Comments Filed under: sql server 2005, Business Intelligence, SQL Function, SQL Server 2008, Katmai, Data Warehouse

• 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

• SQL Server Function to Return DateName

  This function will return the date name for a given date time. 1: USE [DW_SharedDimensions]; 2: GO 3: IF EXISTS ( SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N '[util].[uf_GetDateName]' ) AND type in (N 'FN' , N 'IF' , N 'TF' , N 'FS' , N 'FT' Read More... Posted Wednesday, August 01, 2007 9:21 AM by Patrick Gallucci | 1 Comments Filed under: sql server 2005, SQL Function

• SQL Server Function to Return Date from Numeric Value

  This function will return a datetime for a numeric value. This is using the 1900 date system, the same as used by Excel. See http://office.microsoft.com/en-us/excel/HP100791811033.aspx for more examples. 1: IF EXISTS ( SELECT * FROM sys.objects WHERE Read More... Posted Tuesday, July 31, 2007 9:31 AM by Patrick Gallucci | 1 Comments Filed under: sql server 2005, SQL Function

• SQL Server Function to Return Numeric Value for DateTime

  Technorati Tags: SQL Server , SQL , Function , Intellectually Constipated This function will return a numeric value for a given date. This is using the 1900 date system, the same as used by Excel. See http://office.microsoft.com/en-us/excel/HP100791811033.aspx Read More... Posted Tuesday, July 31, 2007 7:49 AM by Patrick Gallucci | 1 Comments Filed under: sql server 2005, SQL Function