Browse by Tags

• Data Warehouse
• Katmai
• SQL Function
• sql server 2005
• SQL Server 2008

• 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