This works:

SELECT   substring(convert(char,New_idle_duration,114),1,8) as time

--NS

This works great:

SELECT TOP 2 * WITH TIES FROM AnnualContestRewards

WHERE PopulationGroup = 'METRO'

ORDER BY CIFCode Desc

UNION ALL

SELECT TOP 2 * WITH TIES FROM AnnualContestRewards

WHERE PopulationGroup = 'URBAN'

ORDER BY...

I think issue is from the spreadsheet, open a new spreadsheet, select all cells, format them to 'TEXT' then copy your original data to this new spreadsheet.

IN SQL Server, Creat...

I agree with Karl, OrderID can be any number but OrderLineID should be incremented by one for each OrderID added to the table