Oprette view med Union

Jeg har lavet et view som fungere som det skal når jeg eksekverer det, men når jeg prøver at lave sql'en om til et view, så går det galt.  Håber i kan hjælpe.

Msg 4506, Level 16, State 1, Procedure v_ValutakurserDW, Line 13
Column names in each view or function must be unique. Column name 'rate' in view or function 'v_ValutakurserDW' is specified more than once.

CREATE VIEW [Energihandel].[v_ValutakurserDW] AS

SELECT
      dt.[DatoTid]
      ,'Amerikanske dollar' AS [desc] 
      ,rate
      ,'USD' AS rate
FROM [BI_DW].[dw].[Dato] dt
LEFT JOIN dbo.DW_Valutakurser dt1
    on dt.DatoTid = dt1.Dato
        where code IS NULL
       
    UNION

SELECT
      dt.[DatoTid]
      ,[desc] 
      ,rate
      ,dt1.code
FROM [BI_DW].[dw].[Dato] dt
left join dbo.DW_Valutakurser dt1
    on dt.DatoTid = dt1.Dato
        where code = 'USD'   
   
    UNION
   
SELECT
      dt.[DatoTid]
      ,'Britiske pund' AS [desc] 
      ,rate
      ,'GBP' as rate
FROM [BI_DW].[dw].[Dato] dt
left join dbo.DW_Valutakurser dt1
    on dt.DatoTid = dt1.Dato
        where code is null
       
    UNION

SELECT
      dt.[DatoTid]
      ,[desc] 
      ,rate
      ,dt1.code
FROM [BI_DW].[dw].[Dato] dt
left join dbo.DW_Valutakurser dt1
    on dt.DatoTid = dt1.Dato
        where code = 'GBP'
   
    UNION

SELECT
      dt.[DatoTid]
      ,'Euro' AS [desc] 
      ,rate
      ,'EUR' as rate
FROM [BI_DW].[dw].[Dato] dt
left join dbo.DW_Valutakurser dt1
    on dt.DatoTid = dt1.Dato
        where code is null
       
    UNION

SELECT
      dt.[DatoTid]
      ,[desc] 
      ,rate
      ,dt1.code
FROM [BI_DW].[dw].[Dato] dt
left join dbo.DW_Valutakurser dt1
    on dt.DatoTid = dt1.Dato
        where code = 'EUR'   


   


GO