Seems to me that this article may also help, http://www.sqlservercentral.com/articles/Data+Warehouse/69679/.

So what you are saying is that in this particular table, there is no candidate key that could serve as a primary key?

Tom Brown (4/15/2010)

---

It doesn't work for me - it has worked in the past - but not in the past few weeks

IE just goes away for ages and comes...

Okay denizens of The Thread, here's a good one!

anbillava (4/15/2010)

---

I have a situaton where in i need to define unique combination of some of the columns I tried defined it using composite primary key. But I have more...

Still looking for an answer to why you are looking...

I may be wrong, but having just looked at the log files and such from installing SQL Server 2008, I don't think there is anything to tell you after the...

BrainDonor (4/15/2010)

---

My problem wasn't the CTE, it was the...

First, glad we could help.

Second, I knew others would provide you with links that would help you understand the FOR XML. Thanks to you all as well.

Thank you, Paul.

I need to apologize for not posting back earlier. Yes, it is, and it is a problem for organizations running PeopleSoft on MS...

Depending on your requirements, you may also want to read this article: http://www.sqlservercentral.com/articles/T-SQL/67898/.

ychen 55059 (4/14/2010)

---

Thank you so much. That works beautifully.

I'm not familiar with XML. Could you point me to some additional resources so that I can understand...

WayneS (4/14/2010)

---

CirquedeSQLeil (4/14/2010)

---

WayneS (4/14/2010)

---

Lynn Pettis (4/14/2010)

---

And I did. Just...

Hopefully the following sample code will help you.

declare @StartYear int,

@EndYear int;

set @StartYear = 2009;

set @EndYear = 2010;

select @StartYear, dateadd(yy, @StartYear - 1900,...

First, you aren't going to get the query to use an index on EZ_AddDate if one exists since you are using the YEAR function on the column.

Is the start and...