I am totally Overwhelmed by the responses i have got and things i have learn from you guys.

To answer few of the Questions:
1. Yes, I can understand that if...

Yes, the design of the pages are such that Nolock will have hardly have impact on the users. Anyhow currently i am not looking at the optimization of the queries...

I have created the Email profile using Wizard only, i am able to send mails also, Just that sometimes it fails saying that sysmail_start_sp needs to execute. why is that...

no one knows the answer to this..!!?

Hey suddenly i am getting very wierd HTML using your solution.....

SET @HTML='<table id="table2" width="100%">'+

'<tr class="MyHeader" bgcolor="#e2e2e2">'+

'<th align="Left">Type</th>'+

'<th align="Left">Gate</th>'+

'<th align="Left">Task Name</th>'+

'<th align="Left">Task Type</th>'+

'<th align="Left">Project Name</th>'+

'<th align="Left">Project Manager</th>'+

'<th align="Left">Created Date</th>'+

'</tr>'+

CAST(( ...

Worked for me thanks!

Hey It just Worked for me!!

Thanks a ton.....

small query how can i mark this as answer..!!! 😉

Thanks for the Response...

There is only 1 table with the columns such as

PROJ_UIDUNIQUEIDENTIFIER

ASSN_UIDUNIQUEIDENTIFIER

RES_UIDUNIQUEIDENTIFIER

TASK_UIDUNIQUEIDENTIFIER

PROJ_NAMENVARCHAR

TASK_NAME NVARCHAR

ASSN_ACT_WORK DECIMAL

ASSN_BASELINE_START_DATEDATETIME

ASSN_BASELINE_FINISH_DATEDATETIME

ASSN_START_DATE ...

I have this Query Which works just fine..... except the sum is not working...

Declare@STR NVARCHAR(1000),@STR1 NVARCHAR(1000),@FINAL_STR NVARCHAR(4000)

SET @STR='[2011-09-26] as txt1,[2011-09-27] as txt2,[2011-09-28] as txt3,[2011-09-29] as txt4,[2011-09-30]...

PLease anyone..!!?