<div>
<div class="content wysiwyg-content">
Hello all,<br />
<br />
I have a view that has records such as this:<br />
<br />
SELECT &nbsp;ExchangeRateDate, CurrencyCode, ExchangeRate FROM ExchangeRate<br />
ExchangeRateDate &nbsp; &nbsp;CurrencyCode &nbsp; &nbsp; ExchangeRate<br />
2/19/2015 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;GBP &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;1.1255<br />
2/19/2015 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;ANG &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;0.6522<br />
2/20/2015 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;GBP &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;1.3525<br />
2/20/2015 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;ANG &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;0.7525<br />
2/23/2015 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;GBP &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;1.8525<br />
2/23/2015 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;ANG &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;0.4525<br />
<br />
Problem is the source table does not store weekend exchange rates. &nbsp; What I want to do is carry forward any Friday record to the Saturday and Sunday so creating records for this where in the above example I would have 4 more records. &nbsp; How can I accomplish this in my view?
</div>
</div>


Hello all,

I have a view that has records such as this:

SELECT  ExchangeRateDate, CurrencyCode, ExchangeRate FROM ExchangeRate
ExchangeRateDate    CurrencyCode     ExchangeRate
2/19/2015                    GBP                      1.1255
2/19/2015                    ANG                      0.6522
2/20/2015                    GBP                      1.3525
2/20/2015                    ANG                      0.7525
2/23/2015                    GBP                      1.8525
2/23/2015                    ANG                      0.4525

Problem is the source table does not store weekend exchange rates.   What I want to do is carry forward any Friday record to the Saturday and Sunday so creating records for this where in the above example I would have 4 more records.   How can I accomplish this in my view?

SQL View syntax question

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.