1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
 

CREATE FUNCTION date_show(@from_date DATETIME,@to_date   DATETIME)
RETURNS @s TABLE(seq_date DATETIME NOT NULL PRIMARY KEY) AS
BEGIN
   DECLARE @numrows AS INT, @rc AS INT
   SET @numrows = 1 + DATEDIFF(day, @from_date, @to_date)
   SET @rc = 1
   INSERT INTO @s VALUES(@from_date)
   WHILE @rc < @numrows
   BEGIN
      INSERT INTO @s
      SELECT seq_date

      FROM (SELECT DATEADD(day, @rc, seq_date) AS seq_date 
            FROM @s) AS S2
      WHERE seq_date <= @to_date
      SET @rc = @rc * 2
    END
    
    RETURN
END

--Μετά  το καλείς κάπως έτσι αφου δώσεις το start date 
select * from dbo.date_show('20100101','20101117') d
where datepart(dw,d.seq_date ) = datepart(dw,'20101117')
-- θα σου φέρει όλες τις 4ατες απο το διαστημα αυτό

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
 

Declare @start_date datetime,@to_date datetime
 set @start_date = '20100101'
 set @to_date = '20101117'
select 
  case when datepart(dw,d.date_seq) = 1 then 'Κυριακη'
      when datepart(dw,d.date_seq) = 2 then 'Δευτερα'
      when datepart(dw,d.date_seq) = 3 then 'Τριτη'
      when datepart(dw,d.date_seq) = 4 then 'Τεταρτη'
      when datepart(dw,d.date_seq) = 5 then 'Πεμπτη'
      when datepart(dw,d.date_seq) = 6 then 'Παρασκευη'
      when datepart(dw,d.date_seq) = 7 then 'Σαββατο'
 else
      'Προβληματικη Ημερομηνια'
 end as date_descr,
 d.date_seq
 from dbo.date_sequence(@start_date,@to_date) d
where datepart(dw,d.date_seq) = datepart(dw,@to_date)