Doesn't look like a valid xml to me... Where are the closing tags for the various "field name" tags? And what would be your expected result?

Btw: whoever came up with...

St. Lynn, OTD (Owner of the Tent in the Desert), HHG (Hula-Hippo-Guard)

I frequently use three sources of knowledge (not limited to the stuff you mentioned):

BooksOnline (the SQL Server help system usually installed toegether with SQL Server), this site and a test...

Seems like a spam mail for an Expedia site using random text passage from "somewhere" as the...

May I join you? I'd...

Of course...

Well, then the following should work:

(Side note: it still doesn't show P_ID 13 as ACTIVE though... 😉 )

;WITH cte AS

(

SELECT *, ROW_NUMBER() OVER(PARTITION BY P_id ORDER BY pri_key DESC)...

Why do you consider OLD_PHONE = 6790 for P_ID =10 as being "old"?

Shouldn't 6790 and 64687 be switched?

Looks like you're talking about the RunningTotal problem.

The best resource I found so far is the following article by Jeff Moden:

http://www.sqlservercentral.com/articles/T-SQL/68467/

Please read it carefully especially in terms of the required...

lmu92 (3/9/2010)

---

Lynn Pettis (3/9/2010)

---

I think you want a RIGHT OUTER JOIN the way the query is...

Lynn Pettis (3/9/2010)

---

I think you want a RIGHT OUTER JOIN the way the query is currently...

So, please follow Lynns advice and change the join fom INNER to LEFT OUTER.

Next step:

Include one more table in your select:

SELECT DEP.*

FROM dbo.vwGJ1_APD GJ1_APD

INNER JOIN dbo.DefendantEventPros DEP ON GJ1_APD.DANumber = DEP.VBKey

WHERE (DEP.functionDate >= CONVERT(varchar(8), GETDATE(), 112)) AND (DEP.UserDelete = 0) AND...

RBarryYoung (3/8/2010)

---

Since you're on SQL 2008, pass the IDs in as a TVP (table-valued parameter) and receive the results back as a datatable. SQL CAT's test have generally shown...

I'm still not sure what the correct order of the subnumbers will be, but anyway, I'd use ROW_NUMBER:

DECLARE @tbl TABLE

(

bookingkey int null,bookingno int, itemno int, itemtype varchar(20)

)

insert into @tbl(bookingno,itemno,itemtype)

SELECT 1,...