COME ON WEEKEND !!!
Just a small sql script for Brett ...
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[udf_Time_to_Weekend]') and xtype in (N'FN', N'IF', N'TF'))
drop function [dbo].[udf_Time_to_Weekend]
GO
Create function udf_Time_to_Weekend (@d1 datetime) returns datetime
as
begin
declare @d2 datetime
select @d2 = case when (datepart(hh,dateadd(dd,(7-datepart(dw,@d1)),@d1)) >= 17 and 7-datepart(dw,@d1) = 0)
then dateadd(hh,17,convert(varchar(10),dateadd(dd,7,@d1
),101))
else dateadd(hh,17,convert(varchar(10),dateadd
(dd,(7-datepart(dw,@d1)),@d1),101))
end
return @D2
END
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[HoursTillMargaritaville]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[HoursTillMargaritaville]
GO
create procedure HoursTillMargaritaville as
set datefirst 6
select DATEDIFF(MI,GETDATE(),dbo.udf_Time_to_Weekend(getdate()))/60 "Hours Till Margaritaville"
GO
exec HoursTillMargaritaville