Sory @province is not 2 chars it's 1 char. That's the business rule i was asked to do so. 1 char from province 7 chars from Country with seq no....

Thanks for your response. My procedure here need to operate on a table with possibility of many rows having the same ProvinceCountry combination with numeric sequence starting from 01 as...

Lynn Pettis :

Thank you so much for the valuable help.It really helped me.Now I understood what went wrong.

Thanks to all who came forward to help me.

I'm a beginner in sql.Help me refine my SP.I know it has some issues in it.If there's a better soulution plz help me out here.

I"m back here.When I execute my SP I get it inserted but it throws me msg saying

"Subquery returned more than 1 value. This is not permitted when the subquery...

Thank you.Your solution worked.Thank you so much.