To get the result in XML format, use a normal select clause and add FOR XML AUTO to it. It will convert the result to one type of XML format.

Since...

I really do understand that most of the people who survived the terror just by some sort of coincidence (or destiny or whatever you'd like to call it) are not...

"ORDER BY location" should be added to this query.

Otherwise results may be unexpected.

Hi,

Edit: Please disregard. Andrews solution (see previous post) is much easier and performs a lot better.

it's a little more complicated in SS2K (at least in terms of readability), but not...

First of all, thank you for providing DDL together with obviously carefully designed sample data! Good job!

Following please find a proposal that will give you -almost- the expected result (Throughput...

Duplicate post.

Already answered in this thread .

Would you please provide some sample data to test against together with your expected result?

For details on how to post those data please see the link in my signature.

It's some...

duplicate post.

discussion already started here

irrelevant post. Sorry.

Once you start explaining why you need to do it would you please support your explanation with some sample data to make it more understandable and -maybe- to give us...

Assuming your column [dbo].[imitmidx_sql].[activity_dt] is of a char(10) type, it should be more efficient to use

SELECT CONVERT(CHAR(10),GETDATE(),101) instead of the replace and convert functions.

However, you should think about storing...

Duplicate post.

Please continue here . (It's the link to the 2K8 forum, where this question obviously belongs to).

Dave Ballantyne (9/10/2009)

Select WeekNo = datepart(week,datecol),

Mon = sum(case when datepart(dw,datecol)=2 then Sales else 0 end),

...

I'm just going to repeat what I posted before, just a little more focussed:

Straight from BOL again:

varchar [ ( n | max) ]

max indicates that the maximum storage size...

duplicate post.

please continue discussion here .