It would be a lot easier if you could post the actual ddl (create table scripts and indexes, keys etc).

It does look like you need to add some primary keys...

Grant Fritchey (5/22/2013)

---

Hey Steve, which apps. I'm just curious. I moved to a WP last fall and with one exception, I've found it better than my Droid. The exception is...

Steve Jones - SSC Editor (5/21/2013)

---

Grant has a Surface RT. However Sean said "For the Touch I do not have the newer version of the OS. I have the older...

Evil Kraig F (5/21/2013)

---

On a side note, my gaming rig still runs Vista (yes, it's that old). It's about to be upgraded in the next month or two which...

geoff5 (5/21/2013)

---

Sean,

I'm not an expert at execution plans, so I can't speak definitively on which approach is more efficient, but intuitively it would seem to me that referencing the raw...

Can you post some examples of using it? I may be having a dense moment but I am not getting it. If I saw it in use it would help...

Ahh I see how you want it sorted. You could modify Eugene's solution slightly like this.

with MySort as

(

select CaseID,

ROW_NUMBER() over(order by Max(CreatedDate) desc) as SortOrder

from @mySampleTable

group by CaseID

)

SELECT *...

His query does not have an order by. If...

troe_atl (5/21/2013)

---

Hello everyone. I have be trying to figure out how to convert patient records into HL7 format for about a week now with no success. Is this possible within...

What is this supposed to do?

I can't speak to the desktop version however I have a Windows Phone with windows 8 on it. I also have a MS Touch. I find that there are few...

tknecht 32495 (5/21/2013)

---

I understand that the insert would absolutely work as written. My concern was that it wouldn't go into the correct KitID. Sorry if my comments...

http://www.sqlservercentral.com/articles/62867/%5B/url%5D

It is tough to know exactly what you have going on because I sadly can't see your screen. 😉

I would love to use that script but I'm worried it's not...

Matthew Cushing (5/21/2013)

---

I guess my only question is to how we get the information of the user who is disabling the person, but since they're logged into the system, it...