I have a data corresponding to a list of DBs and diff rows with dates that they were in use.
DB Dates USAGE ABC 03-06-2018 IN USE ABC 07-06-2018 IN USE XYZ 04-06-2018 IN USE XYZ 08-06-2018 IN USE
What i want is to have the full calendar month corresponding to every db and not just the dates on which they were in use
DB Dates USAGE ABC 01-06-2018 NOT IN USE ABC 02-06-2018 NOT IN USE ABC 03-06-2018 IN USE . . ABC 07-06-2018 IN USE . . ABC 30-06-2018 NOT IN USE XYZ 01-06-2018 NOT IN USE . . XYZ 30-06-2018 NOT IN USE