I need to figure something out to do after work.  I haven't been able to get back out on the pitch to referee soccer since getting back from Afghanistan.  I...

Just realize that Dynamic SQL is a tool.  There are times it is needed and appropriate and other times when it isn't.  Learning how to write good Dynamic SQL is...

That is the behavior of MERGE.  If you want a more granular update you should use separate INSERT and UPDATE statements.

Here is the updated view:

create view [V_DATE_RANGE] as
select
 convert(varchar(100), 'Year To Date') as [Period]
 , dateadd(year, datediff(year, 0, getdate()), 0) BeginDate
 , convert(datetime,...

My fiscal year calculation is wrong.  Give me a couple of minutes to fix it.

Using my suggested changes, here is your view.  Please check it out and verify it works.

create view [V_DATE_RANGE] as
select
 convert(varchar(100), 'Year To Date') as...

My biggest suggestions are these:
1) Eliminate the use of character conversions.  There are examples out there that show how to do a variety of the date manipulations being done...

Never even tried it until today.  And one hand on the keyboard and one on the mouse isn't an issue.

Doing things in a columnar fashion is one of...

I made a few changes, such as using int for id instead of varchar(20), datetime for instead of varchar(20) for the dates.
does the following provide what you are trying...