I m getting ther error on the line

CROSS APPLY sys.dm_exec_sql_text(qs.plan_handle) qt

while creating the Proc

The error is

Msg 102, Level 15, State 1, Procedure dba_QueryTimeDelta1, Line 49

Incorrect syntax near '.'.

Please...

Thanks..

My SQL and IIS is on different machine..

I am not able to identify where the error is coming.

There is nothing in the event log also related to this while the...

Thanks for sharing.it is very common one ,but peple even confuses.

it might clear the confusion of those

Akash

Good One

DearI face the same problem.But i get the solution .The problem with me is the Datatye mismatching.i was comapring the Int datatype with decimal(24,0). i corrected this then my problem...