You might be using this code against an earlier version of SQL Server so your results will be mixed. It looks like you need to declare the variable and then assign a value to it:

DECLARE @ts_now BIGINT

SET @ts_now = ( SELECT cpu_ticks / ( cpu_ticks

/ ms_ticks )

FROM [sys].[dm_os_sys_info]

);

That will fix the syntax problem but whether your version of SQL Server has the same DMVs with the same data will not be fixable if you find further errors, this code is only tested on versions from 2008 and up.