Hey ! Thanks, But as you can see it provides the result set in columns instead of it being on a single column with comma separated values.
Also, the earlier...

Thank you !!!!! Works like a charm

Hi Luis

Select WeekRange as WeekRange,

[Open] as 'Open', [Resolved] as 'Resolved', [Pending] as 'Pending', [Other] as 'Other'

From

(

Select weekRange, Year, Status from ##TempInteractionData

) As SourceTable

Pivot

(

Count(Status) for Status in ([Open], [Resolved], [Pending], [Other])

)...

Yes. It will be four dates..

I do not want the data from the fifth line and only these four dates into a table.

Is it possible with openrowset. Can you...

2011-09-09 00:00:00GMT

2011-09-10 00:00:00GMT

2011-09-10 00:30:00GMT

2011-09-10 00:30:01GMT

NTC-A;NTC-B;HDC-A;HDC-B;

AAP;260;260;260;260;

And so on....

The dates are complete lines. Not embedded within any lines......

This is a recurring task (Daily task infact).

Sorry could not post before as was held up at work.

Got the issue resolved. Took the data into a temporary table and then did the conversion from text to string...

Luckily,...

Hi.

Thanks for the reply. I tried but it keeps saying that DT_NTEXT cannot be used for those string manipulation functions.....

Any idea on how to get over it..

Thanks again