Thanks mathurar .... 'myidcol' was exactly what I was looking for .... since I didnt find tat on time I decided to look for other means of getting an unique identifier

Thanks again...

Oooo woww ..... I didnot think about that, that sure would create duplicate entries. Anyway good thing is right now the system is designed is such a way that no...

Thanks guys for your help,

Here is my solution to the problem. Instead of creating another column just for storing ids I am using count() function in select statement to get number of...

I am not an experienced SQL Server programmer ... not sure how this can be done

I would appreciate if someone can give me...

Thanks Jonathan

That sure looks a lil complicated since I have not come across sysname and Quotename keywords before. I will try the code would...

Thanks Jonathan for the prompt response. I am new to SQL Server and TSQL, I would really appreciate if you can help me out