What is the format of your destination column, the input from Excel is Unicode, if your output is varchar then you will have truncation issues.

For a test a...

Not sure if the best solution

WITH cte AS (
 SELECT ROW_NUMBER() OVER (order by Value desc) Sequence_no,
   userid,
   Value,
   DENSE_RANK() over (order by Value desc) as Rank

Using a Tally table of integers

SET DATEFORMAT DMY;
WITH cte (CertNo,LodgeDate,MatDate,Term,Amount) AS (
   SELECT CertNo,LodgeDate,MatDate,Term,Amount
   FROM (VALUES (1,CAST('11/02/2017' as date),CAST('11/02/2018' as date),365,5000),
       (2,CAST('15/06/2017' as date),CAST('14/09/2017' as date),91,6500),

TOP allows an expression sin SQL 2008

TOP(