title: Split a single row into multiple rows based on date range in sql server
body: <p>my SQL server table structure is some what like below </p>
  
  <pre><code>FROM_Currency   To_Currency   ExchangeRate   StartDate    EndDate
  EUR               GBP            33.5        2018-03-31    2018-04-30
  USD               EUR            22.9        2019-01-31    2019-02-28
  </code></pre>
  
  <p>like this have historical exchange rate data for multiple currencies and exchange rate for over 3 years,
  as shown in above table we have start date and enddate for each currency rate in a range of 1 month ,what i need is to basically split it into each day ,so basically need exchange rate daily ,for ex: for 1st record i need 30 rows which should say from_currency as EUR and To_currency as GBP and exchange rate as 33.5 and new date column should be increment date starting from 2018-03-31 to 2018-04-30 .</p>