Table 1: End of Month Dates

 

Keycol

dt

end_of_month

1

2006-01-18 00:00:00.000

2006-01-31 00:00:00.000

2

2006-02-12 00:00:00.000

2006-02-28 00:00:00.000

3

2006-04-18 00:00:00.000

2006-04-30 00:00:00.000

4

2006-08-02 00:00:00.000

2006-08-31 00:00:00.000

5

2006-09-12 00:00:00.000

2006-09-30 00:00:00.000

6

NULL

NULL

7

NULL

NULL

8

NULL

NULL

9

NULL

NULL

10

NULL

NULL