patrick gallucci's technology brain drain
Common Table Expressions
Microsoft Certified Architect
sql server 2005
SQL Server 2008
SQL Server Stored Procedure
Browse by Tags
Tagged Content List
The few, the proud, the fortunate. Microsoft Certified Architect Program
And I really do mean fortunate. On March 10th I am to embark in five weeks of some of the toughest technical training that I will do during my career. I have been to week long ramp-ups and boot-camps to help facilitate learning during my career. But this is far and above anything that I think I endured...
29 Feb 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 FUNCTION [util].[uf_MergeDate2Time] GO ...
18 Nov 2007
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] GO CREATE...
25 Sep 2007
SQL Server 2008 (Katmai) July CTP - Do you feel the need for speed?
Here it is...the July CTP for SQL Server 2008. I was going to start the download tonight and install in the morning...but I forgot I was on Verizon FIOS...man I love that Fiber! Download your copy now! https://connect.microsoft.com/SQLServer/content/content.aspx?ContentID=5470 Technorati Tags: SQL Server...
31 Jul 2007
Page 1 of 1 (4 items)
© 2014 Microsoft Corporation.
Privacy & Cookies