can any one reconstruct my query with INNER JOIN...

I WANT TO ELIMINATE IN CLASS.... IS THAT POSSIBLE

update TBL_DEGREE_COURE_MASTER

set flag = 'FREE', flagtime = 'Application Crashed'

where SYSTEMID IN

(select b.systemid

from sys.dm_exec_connections a

right...

the problem arises where i use IN clause. 2005 compiler says u cant use IN clause here. use Exists. but Exists clause doestnot solve my problem.....

but 2008 compiler doest'n raise...

Thanks Sean Lange

If this solution is not worthy to implement then what can i do?

plz suggest me good idea to implement on my application.

Actually i want Pessimistic Locking with Strongly...

Actually i need to use Pessimistic Locking with strongly typed dataset...

so i have designed my own record locking mechanism that works when a user click edit button. Means when a...