The CROSS APPLY line below returns this error

Msg 102, Level 15, State 1, Line 43

Incorrect syntax near '.'.

This is true for the original code from the article and the formatted code in this discussion. What am I missing?

Thanks,

Bill

SELECT '-- Shows top 5 high cpu used statemants'

SELECT TOP 5 total_worker_time/execution_count AS [Avg CPU Time],

SUBSTRING(st.text, (qs.statement_start_offset/2)+1,

((CASE qs.statement_end_offset

WHEN -1 THEN DATALENGTH(st.text)

ELSE qs.statement_end_offset

END - qs.statement_start_offset)/2) + 1) AS statement_text

FROM sys.dm_exec_query_stats AS qs

CROSS APPLY sys.dm_exec_sql_text(qs.sql_handle) AS st

ORDER BY total_worker_time/execution_count DESC;