Last Sunday

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Article Discussions » Article Discussions by Author » Discuss content posted by Barkha Javed » Last Sunday

Last Sunday

Rate Topic

Display Mode

Topic Options

Author

Message

barkha.javed

Posted Monday, May 11, 2009 7:33 AM

SSC Veteran

Group: General Forum Members
Last Login: Monday, September 03, 2012 10:57 PM
Points: 247, Visits: 236

Comments posted to this topic are about the item Last Sunday

Post #714098

Javed-330570

Posted Wednesday, August 19, 2009 8:42 AM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Monday, September 03, 2012 10:57 PM
Points: 192, Visits: 157

The function below returns the week ending date for the specified week day.

-- =============================================
-- Author: Barkha Javed
-- Create date: 10 Jul 2009
-- Description: Date of week ending, per given weekday
-- =============================================

ALTER FUNCTION [dbo].[fn_LastWeek]
( @Duration int,
@DayOfWeek varchar(10) = Null
)

RETURNS nchar(8)
AS
BEGIN
DECLARE @dt nchar(8)
DECLARE @DiffDays int

SELECT @DiffDays = CASE WHEN @DayOfWeek Like 'Mon%' THEN '2'
WHEN @DayOfWeek Like 'Tue%' THEN '3'
WHEN @DayOfWeek Like 'Wed%' THEN '4'
WHEN @DayOfWeek Like 'Thu%' THEN '5'
WHEN @DayOfWeek Like 'Fri%' THEN '6'
WHEN @DayOfWeek Like 'Sat%' THEN '7'
WHEN @DayOfWeek Like 'Sun%' THEN '1'
ELSE '1' END

SELECT @dt = Convert(nchar(8),DateAdd(d, -(DatePart(w, getdate())-@DiffDays), DateADD(wk, @Duration, getdate())),1)

RETURN @dt

END

Post #773582

« Prev Topic | Next Topic »

Permissions