Dineshbabu (1/10/2013)
Can anyone help me in simulating the question in management studio without any application.
Using Management Studio, create the stored procedure as specified in the question, but add a command WAITFOR DELAY '0:00:10'; to simulate the 10 second running time.
Now open two connections, and type EXEC GetData_Date; in both. Hit execute in one tab, switch to the other tab, then hit execute there.