Did you copy it straight from the front end or did you use the "Quote" button to see the "real code"?

Reason: SSC displays XML data not exactly as in...

Following please find an untested proposal.

It should be verified using a test system and not used for production directly.

Since you didn't provide any sample data nor expected results we don't...

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),

...