I understand if the parameter values are different what you said makes sense. Newbie are the parameter values the same.

I have read somewhere that using local variables to the procedure...

What I dont understand is the difference when the table is created through the enterprise manager and the Query Analyser.

What is the best possible solution for this problem. I...

Thanx very much

It worked

U dont know how grateful I am

I think @@spid will provide u the identifier