/**********************************************************************
DATE: 20091006
PURPOSE: RETURN THE TimeID IN dim_Time FOR A PASSED IN Time

TESTING: 
 SELECT dbo.WHSE_fnGetTimeKey('2:12:34 PM')

**********************************************************************/
CREATE FUNCTION [dbo].[fn_GetTimeKey](@Time DATETIME)

RETURNS INT 

AS 

BEGIN

 DECLARE @TimeID INT

 SELECT @TimeID = Tijd_ID
 FROM dim_Tijd
 WHERE CAST(CONVERT(VARCHAR,@Time,108) AS DATETIME) = [Tijd]

 RETURN @TimeID

END