In a Client Server environment, i run two command that call stored procedure in sql server.

one stored procedure generate data
and the other one calculate the data that generated from first sp

but how is the client know that the data in first command is finished, so the client can call the second command?


thanx