vendredi 22 juillet 2016

How to fill in the dates in between a min and a max date from a column

I hope I can explain this well enough. I'm trying to create a table with a date field that uses a date column from another table to grab the min and max dates from that column, and fills in all the dates in between. So if the min and max dates were 1/1/2016 and 6/1/2016 then I would want the table to list every date in between those dates. I am using SQL Server Management Studio 2014. Thanks for your help.

Aucun commentaire:

Enregistrer un commentaire