Thanks , i used matrix and it worked.

Meghna

thanks it worked ,Thanks a lot

Meghna

For this table , if i wnt 4th smallest value then answer should be 5 .

create table test(No int)

insert into test values(1)

insert into test values(3)

insert into test values(6)

insert...

'SELECT TOP 1st * FROM tablename ' is not working i mean like 'SELECT TOP nth * FROM test'

is givieng error in sql2000.

Can u suggest something?

thanks

thanks for reply , but i m using SQl2000 , where ROW_Number doesnt work.

Can you provide me something which i can use in 2000?

Waiting for your reply

thanks

Meghna

hi

that is not the way as 2 nd row elements belong to one column in a table and as per u , if i manually do , 2nd row...

In sql , how it can be done?

thanks

Ok , thanks for sspending your time on it!

Meghna

Jeff,

for item : A B

1 2 3 5 6

... are you saying that the...

same names jef , as column name is the row number , if u see the example structure in the first post of mine.

Sorry for the delay , but...

At present i have 3 items maximum , and i want all of them in separate columns for the unique item

For e.g

for item : A B

...

hi

It can be many items also. Actually i wanted to do it in my RDL to make it more comapct and attractive for client but couldnt find a way...

Thats Great!

Meghna

Yep my dear !

Hip hip hurray !

Meghna

Same pinch dear ,

in tool box , there is one tool called 'Chart', go there n initiate.

Good luck!

Meghna