Sorry about that, will do that next time. I guess I was not clear what I asked for. Thanks for correcting and I appreciate your help in correcting me.

You are right Jason, the TOP clause would not give me the right results.

Hi, I found the solution myself. and here it is. AccountId has the Identity on it.

SELECT AccountID = MAX(AccountID)

...

This is the solution I got.

Create procedure TableMetaData @tablename varchar(100) as

declare @text2 as varchar(100)

declare @text3 as varchar(100)

declare @text4 as varchar(100)

declare @Distinct table (value varchar(50))

declare @Nulls table (value varchar(50))

declare

Thanks a lot Markus, that is a good beginning for me.

Hi Markus, Thanks for the reply.

If you do not mind, can I see what you have written.

Thank you sean, the link was useful for me in asking a question on the forum. I did edit the data before posting, but when I posted it still changed...