I will try to post more data and expected results in my next post.

Thank you all for your great help.

@luis,

Thanks for the links.

@Lynn,

Your solution works fine on small amount of data but it doesn't work on large quantities of data. I tried it on joining more than 5 tables on...

Hi Lynn,

Can you please explain your query? I have hard time understanding the whole query specially this part:

CROSS APPLY (VALUES('first', first),('last', last),('highest', highest),('lowest', lowest)) xx(description, value)

Thank you.

Thank you so much Lynn. I will test this tomorrow and will let you know.

I appreciate your help.

Ok got it. I hope I get some help over here then. I have already posted the sample data.

Thanks.

Here is the sample tables and data:

CREATE TABLE ListOfValues

(

pid int,

ListValues decimal(3,2)

);

CREATE TABLE Person

(

pid int,

name varchar(50),

Age nvarchar(20)

);

INSERT INTO ListOfValues (pid, ListValues)

VALUES (1, 1),

...

Thanks for your help though. This is not a homework assignment. I can't post confidential data so I just posted some sample data to get an idea. I think I...

@Lynn Pettis, and @Alvin Ramard,

If you both are experts in T-SQL Programming it doesn't mean that you should mock or make fun of other people who are just...

Hello Luis,

Your solution works fine. Now I need pull more columns from another table by joining it with the table which contains the list of values. For example I need...

The values are for just one person or customer. For example if you select all the values for a given customer, it should list all value for the customer so...

The values are in just one column. Any ideas?

Thanks

Sorry my mistake that I have not posted a clear scenario. Actually I am looking for way to get the first, highest and last value in the list of values...

Sorry posted twice.

@ Alan Burstein,

Sorry for my late reply. I tried your example but no luck.

I am looking for the first value, the maximum value and the last value in the...