--Restoring the full backup
RESTORE DATABASE TestDB
FROM DISK = 'E:\Backup\TestDBFull_1.bak'
WITH NORECOVERY, REPLACE

--Restoring log backups
RESTORE LOG TestDB
...

I always re-factor the CTE's when debugging them, for simplicity

;WITH CTE AS

(

SELECTID, Col1, Col2

FROMMyTable

WHERE...

)

SELECTCol1,

Col2

FROMCTE AS C

JOIN MyTable AS T

ON T.ID = C.ID

SELECTCol1

, Col2

FROM(

SELECTID, Col1, Col2 ...