Hi,

My Question is :

How to get the value of last row and the last column in a table when we don't know about the limit of rows and columns.

For eg., there is x(n) rows and y(n) columns, then i have to get the value of x(n)th and y(n)th value.

Expecting for the reply.

Ramkumar

A.D.Ramkumar

__________________
Ramkumar A D

hi,

i can help you a little in this matter.
you can write a function which will return the column name
after you find the column name write dynamic SQL for selecting the value for that column and use order by clause and select top 1 row
you will get the specified value.

To find the last column here is script.

Suppose you are in Northwind Database and wanna find the last column of Orders Table then you can write as

select name from syscolumns
where colorder = (select max(colorder) from syscolumns where id = object_id('orders'))
and id = object_id('orders')

This will return the column name and you can use this column name to write the dynamic SQL.

Thanks

Atul Kumar Sharma