#calendar example

[calendargratis]

Printable Monthly Blank Calendar Template | Calendar Format with Notes

Organaize your month by using free Printable Monthly Blank Calendar template. These online weekly basis schedule designs are available in excel, Word, Pdf.

[prashantjayaram]

T-SQL - How to get the Financial Quarter details of a date field

T-SQL – How to get the Financial Quarter details of a date field

declare @table table ( [Paid Date] date ) insert into @table values('20150102'),('20150512'),('20150830'),('20151231'),('20141230') ;WITH Quarters AS ( SELECT Q = 'Q1', MonthBegin = 1, MonthEnd = 3 UNION SELECT Q = 'Q2', MonthBegin = 4, MonthEnd = 6 UNION SELECT Q = 'Q3', MonthBegin = 7, MonthEnd = 9 UNION SELECT Q = 'Q4', MonthBegin = 10, MonthEnd = 12 ) SELECT [paid date],[Quarter] =…

View On WordPress

[prashantjayaram]

T-SQL to Display Weekends Between two Dates

T-SQL to Display Weekends Between two Dates

Different ways to find the weekend between two given dates.

DECLARE @beginDate Date='20150101', @endDate Date='20150131' DECLARE @Calendar Table (CalendarDate Date Primary key, IsWeekend Bit) WHILE @beginDate <= @endDate BEGIN INSERT INTO @Calendar SELECT @beginDate As CalendarDate ,(Case When DATEPART(Weekday, @beginDate) In (7, 1) Then 1 Else 0 End) As IsWeekend Set @beginDate = DateAdd(Day, 1,…

View On WordPress