vendredi 18 décembre 2015

Split date range to year-month rows on SQL Server 2005

I need to create an output where I got one row per year-month.

Assume the dataset is:

id |        dateStart        |        dateEnd
1  | 2015-01-01 00:00:00.000 | 2015-03-31 00:00:00.000
2  | 2014-07-01 00:00:00.000 | 2014-08-31 00:00:00.000
...

I need the following output:

id | year-month
1  |  2015-01
1  |  2015-02
1  |  2015-03
2  |  2014-07
2  |  2014-08

The output can be any datatype since I can just change that later. That is for 2015-01 the following is ok, "2015-01-01 00:00:00.000", "2015-01-01", "201501", "2015 | jan" ect.

Note I'm using SQL Server 2005.

Aucun commentaire:

Enregistrer un commentaire