Thanks.

Analyzing the code, or the results of it?

Craig Farrell (10/6/2010)

WayneS (10/6/2010)

Craig, did you consider...

Paul, Jeff, et all...

I want to ensure that I understand the safety check as posted by Paul at http://www.sqlservercentral.com/Forums/FindPost980118.aspx, and modified by Tom at http://www.sqlservercentral.com/Forums/FindPost981258.aspx.

The resultant (combined) code would be:WITH...

Amit,

Here is my freshly updated code to show what is going on with this deadlock. (For any keeping track, this is now my most recent deadlock shredding code.)

-- see http://msdn.microsoft.com/en-us/library/ms188246.aspx

--...

As usual, Jeff has an excellent solution.

I did notice one, well, issue with it. It is assuming that the control numbers will have a prefix, followed by 9 zero-padded digits....

Well, you did say you were debunking three myths. I bet...

The deadlock graph will be in an XML format... do you have that available?

WITH CTE AS

(

Select distinct

Name = Column2 ,

[Year] = Column20 ,

...

You showed us your desired output... now how about some sample data to see what we need to do to generate the output?

Please see the first two links in my...

Okay Craig and Craig-4 - I've been off all day, just getting back to look at this. It seems like things are going good. Is there anything else that is...

Sounds good to me. Maybe a forum of "Other Databases", that could include Oracle, Access, MySql, etc.

That's essentially it. Uninstall. Install different edition.

You're very close:

select SUM(CASE WHEN calendar_year=2009 THEN amount1 ELSE 0 END) as amount_1,

SUM(CASE WHEN calendar_year=2010 THEN amount2 ELSE 0 END) as amount_2,

...

Take a look at the articles linked to in my signature under Cross-Tabs and Pivots, Part 1 and Part 2.

madler-797963 (10/7/2010)