;with cteTransfer as
(
  select TOP(1) *
  from #tempOutputTable t
  where t.LogText = 'sUtilFinaliseDB: Transfering Files To Archive Completed'
  order by logdate desc

I think this is the same:
select v1.amount,
       count(v1.code) Count1,
       Count2
  from tabusrvoucher v1
 outer apply(select count(code)
   ...

Works for me:
CREATE TABLE #temp (col1 datetime2 default current_timestamp NULL)
INSERT INTO #temp(col1) SELECT '2011-12-14 12:09:21.472'
SELECT * FROM #temp
GO
DROP TABLE #temp
Can you supply a...

I think this might answer your question:
DECLARE @percentComplete float = 0.55
select CONVERT(decimal(38,38),@percentComplete )

SELECT * FROM CTE OPTION(RECOMPILE)
You have too many brackets and you don't need to put it in a common table expression.