Hi LutzM,

I have a question about Exclusive Table Lock. What would be SQL servers behavior if my application open connection to insert data into same table while exclusive table lock...

You are the SQL man Lutz, you saved me from a real big hassel

I thank you and appreciate your great help

rgds,

gem

yes, my fault i forget to add quirky

I really appreciate your help

u sure its running on your machine? giving errors here....

the article you mentioned is a long but very informative, i really need to understand this... thanks for mentioning this article

Thanks for your response,

I am using SQL 2005

here are the results i am trying to get

datetime SensorID...

Thanks guys, I just read an excellent article on CTE that solved my problem.

here is the link

http://www.sqlservercentral.com/articles/T-SQL/62159/

Thanks for posting code too. i just finished my code that is ...