I use this question to get the whole day in a month
Announce @date dateet set @date = '20140201'; Select the day from day to day (as date @, select the day from the date all month (date) = month (date @) * Date from date * Select from date where month (date) = Month (@date) and get all days but in a list
how can I get this result, and for example this week this example For:
Sun1 - Mon1 - TUE1 - WED1 - THU1 - FRI1 - SAT1 - Sun2 - Mon2 - TUE2 - WED2 - THU2 - FRI2 - SAT2 Pd: number corresponding to 1 and 2 weeks
Is this OK ?? ??
Announce date @ date setet @date = '20140301'; as with DAYSINMONTH (Select @date as the date, DATENAME (DD, @date) as all DATEADD selection (day, 1, date) as the union on [DAY], DATENAME (weekday, date @) [DAYNAME] , DATENAME (DD, Date as 1 day [day], DATENAME (WEEKDAY, date + 1) from the day of [DAYNAME] in the month where the date (date ) = Select the month (@date)) [1], [2], [3], [4] [5] [6] [7] [8] [9], [10], [11] [12], [13], [14], [15], [16], [17], [18], [19], [20], [21], [22], [23], [24] ], [25], [26], [27], [28], [29], [30], [31] - Saturday, Sunday, Monday, Tuesday, Wednesday, Thursday, Friday (SELECT [DAY] At the end of the day from [DAYNAME] where the month (date) = month (date @) PIVOT (([1], [2], [3], [4], [5], [6], [7] [8], [9], [10] ([DAYNAME]) MIN ([DAYNAME]]], [11], [12], [13], [14], [15], [16] [27], [28], [17], [18], [19], [20], [21], [22], [23], [24], [25] 29], [30], [31]) as PST
Another answer for your exact requirement
Damage to @ date Dettaim declared @lastWeek int set @date = '20140301'; Set @lastWeek = DATENAME (WW, @date) -1; If you choose DAYSINMONTH as (@date date, then DATENAME (DD, @ date) as of [DAY], DATENAME (date of work, date @) + cast (cast (DATENAME (date, date, date) As integral) - as varchar (2)) [DAYNAME] as @ lastWeek on [DAY]] as the union (DATEADD selection dd, 1, date), DATENAME (DD, date + 1) on [DAY] DATENAME (working day, day + 1) + cast (as ite (DATE, WW, date + 1) - @ [vi (2)) as the last week of [DAYNAME] from the end of the day Month (date) = months (@d Nank) Select Sunday 1, Monday 1, Tuesday 1, Wednesday 1, Thursday 1, Friday 1, Saturday 1, Sunday 2, Monday 2, Monday 2, Wednesday 2, Thursday 2, Friday 2, Saturday 2, Sunday 3, Monday 3, Tuesday 3, Wednesday 3, Thursday 3, Friday 3, Saturday 3, Sunday 4, Monday 4, Tuesday 4, Wednesday 4, Thursday 4, Friday4, Saturday4, Sunday5, Monday5, Tuesday5, Wednesday5, Thursday5, Friday5, Saturday5, Sunday 6, Monday6, Tuesday6, Saturday6, Thursday6, Friday6, Saturday6 (select [day], [DAYNAME] DAYSINMONTH where month (date) = from month (@date)) de pivot (max ([Days]) in [DAYNAME] (Sunday1, Monday1, Tuesday1, Wednesday1, Thursday1, Friday1, Saturday1, Sunday2, Monday2, Tuesday2, Wednesday2, Thursday2, Friday2, Saturday2, Sunday3, Monday3, Tuesday3, Wednesday3, Thursday3, Friday3, Saturday3, Sunday4, Monday 4, Tuesday 4, Wednesday 4, Thursday 4, Friday 4, Saturday 4, Sunday 5, Monday 5, Tuesday 5, Wednesday 5, Thursday 5, Friday 5, Saturday 5, Sunday 6, Monday 6 , Tuesday 6, Wednesday 6, Thursday 6, Friday 6, Saturday 6) As PST
Comments
Post a Comment