Thank you all for the help.

What should i do if i want two columns with below output?

Client fields value ...

My output should look like this:

Clientfields value ...

sorry. I didnt know where to post earlier . Im using SQL SERVER 2012. Will deleete my post in sql server 2008. Howerver didnt get proper reply in sql...

Yes, Id is just numeric sorry about that.

And yes I want the students who are free in the same section with timings. Ex: all students who are free in...

Please let me know if you need more information .

Thanks in advance

this is what i need..thanks so much..

Thank you.

Its quite close to what i expect

In your query 'left join #something s on s.day = d.NameOfDay

and s.name = 'Mary'' you are trying to retrieve data for...

Yes it worked..thank you