Well can we achieve the same result with different approach as i am stuck with this dynamic thing and .NET DATA set requirement is column in Select statement ..somehow its...

Lutz,

Can we do the same with different technique? I mean one simple select with all the 32 desired columns?

Lutz,

I got stuck in a really nasty situation with the dynamic query in my previous thread. If I run the procedure it sure populates the column and display them but...

🙂 Lutz I want 'Holiday' to appear in the column value along with the header 'Sunday' actually in place of '0' 🙂

Lutz,

Thank you for appreciating the way I've posted my data. Actually I've observed that ppl do not bother to provide scripts which is ethically wrong. Its the place where your...

Thank you all of you who helped me here..both the queries worked great 🙂 Appreciate support.

well actually its a daily checklist users has to fill in every day so as much as they will fill partially or incomplete i will have to show in the...

Jeff first of all let me salute you for the great procedure..It was way too hectic so I didn't get the chance to experiment something new but you showed the...

Sachin,

Thanks alot for the solution....its working like a charm. I think NULL values problem I can overcome by inserting 0's while inserting data in table and total in the begining...

Jeff thank you for your reply. Well all the tasks will appear with 0 if the data is NULL for any day. Yeah I want to display the TOTAL of...

Sachin great work 🙂 just need four things and it will be perfect cause i am trying to change but it has error...not good with sql though.

1. I've lost my...

Just one month at a time. User will pass the parameter for month like Jan or Feb or Mar and according to the month the procedure will get executed and...

Sachin thank you for your efforts and I appologize that I didn't provide you the data the way you mentioned me Next time I will do it accordingly.

Well through your...

Sachin,

Just provided u the sample data. If you notice it has data of task 1 and 2 for the month of October and November.

In October the sum of task_count for...

do one thing plz...I have the following data in TASK_DETAIL...IN TASK_MASTER..u can create just two records with the following n test..results are strange..it should come as two lines with 31...