SQLServer2008R2 --- Selezionare ultimi 4 record in ordine Crescente

SELECT TOP (100) PERCENT 
TaId, TaData, TaNote, TaNum
FROM         
(
SELECT TOP (4) 
TaId, TaData, TaNote, TaNum
FROM          
dbo.Tabe
ORDER BY TaData DESC
) AS TTT
ORDER BY TaData

USE tempdb;
GO

CREATE TABLE #tempDate
(
    TaId int IDENTITY(1, 1) NOT NULL PRIMARY KEY CLUSTERED
  , TaData date CONSTRAINT UK_TaData UNIQUE
  , TaNote varchar(200)
  , TaNum int
);
GO

INSERT INTO #tempDate (TaData, TaNote, TaNum)
VALUES
      ('20140101', '', 1),
    ('20140102', '', 2),
    ('20140103', '', 3),
    ('20140104', '', 4),
    ('20140105', '', 5),
    ('20140106', '', 6),
    ('20140107', '', 7),
    ('20140108', '', 8);
GO

DECLARE @NumeroDiRecord int = 4;

WITH wDate AS
(
  SELECT
      TaId
    , TaData
    , TaNote
    , TaNum
    , rnum = ROW_NUMBER() OVER(ORDER BY TaData DESC)
  FROM 
    #tempDate TD
)

SELECT 
    TaId
  , TaData
  , TaNote
  , TaNum
FROM
  wDate
WHERE 
  rnum <= @NumeroDiRecord
ORDER BY
  TaData;

DROP TABLE #tempDate;
GO

USE tempdb;
GO

CREATE TABLE #tempDate
(
    TaId int IDENTITY(1, 1) NOT NULL PRIMARY KEY CLUSTERED
  , TaNote varchar(200)
  , TaNum int
);
GO

INSERT INTO #tempDate (TaNote, TaNum)
VALUES
    ('abc', 10),
    ('dfg', 20);
GO

WITH wDate1 AS
(SELECT TaId, TaNote, TaNum FROM #tempDate TD1)

-- Penso che l'errore sia sul WITH che sta qui sotto  <<---------------------
 WITH wDate2 AS                                                         
(SELECT TaId, TaNote, TaNum FROM #tempDate TD2)

SELECT TaId, TaNote, TaNum FROM wDate1
UNION ALL
SELECT TaId, TaNote, TaNum FROM wDate2

DROP TABLE #tempDate;
GO