Thanks Journeyman for the nice example. One thing is still different from my scenario. That is in the cursor example you have shown the select statement of cursor does not...

Hi SSC Journeyman

Could you please show an example here. I have not delat with cursor much. Your help is highly appreciated. Due to adequate knowledge of sql server I am...

Seth,

The first procedure is run once to get the output. The first procedure will always run once to get single and mostly multiple row output. My stored procedure is somewhat...

Hi Seth,

There will be ten people who will be using the system. I am told that there will be six people in the system at the same time. I am...

OK Lynn,

I have changed the stored procedure in accordance with a requirement change. With this the procedure changes to the following:

create procedure dbo.process_customer_modified

@custid varchar(50),

...

Thanks for help. I have already solved the issue. Regards