Dear ColdCofee,

Thank you so much for your help, I think your answer is the solution that I've looking for..

about the following article from Jeff on posting etiquettes that...

Dear Arjun,

It's Ok. Thank you so much for your help.

Dear Arjun,

Well, I still don't understand. If I should got that result like that from DB then I don't understand why I got to pivot that query?

Is there any way...

here there result that I get from db:

when numberofday = 28

DoctorName Team 1 2 3 4 5 6 7 ... 28 Visited

dr. As A x x ... 2...

Dear Arjun,

I have learn how to make pivot query and now I have make it the pivot query to run dynamic column now. Thank you so much. But I...

Dear Arjun Sivadasan,

Thank you so much. I going to try the pivot on my query.

Dear Parthi,

Thank you for you help but I still found that the 29/30/31 column are not change dynamically. Thank you for your help but I think there must be a...

Thank you for support, Arjun Sivadasan.

Yes I thinking about using Pivot do you have any link suggestions? I 'm still learning about Pivot. If you don't mind may you could...