Thomas (4/27/2009)

---

Note that the comma-delimited list is sorted alphabetically. I'm aware that there is a hack using Replace, Stuff and For Xml to achieve this but it is pretty...

bruce.trimpop (4/24/2009)

---

Here's the point I was trying to make. Some people work in an environment where there are time constraints and other issues completely out of their control,...

RBarryYoung (4/21/2009)

---

Sorry Goldie, not trying to be evasive but my brain isn't at 100% right now and this technique...

Lynn Pettis (4/21/2009)

---

That is the problem. For the "quirky update" to work you need a clustered...

Yes, Non-Unique, Non-Clustered.

Lynn Pettis (4/21/2009)

---

I'm not sure why it isn't working for you. I run the above code as is and it works correctly with the test data.

Can you post the...

James.N (4/21/2009)

---

HI,

Waht am I trying to accomplish , with the code I posted ?

First I am updating the Rows that are common in both TestD(Destination)...

Lynn: I can't get your solution to work correctly. GroupCounter is always 1 on my live data. I can't understand it.

Barry: As I suspected, it looks like your solution out-performs...

James.N (4/21/2009)

---

I already have a upsert code in Test with Inner join, then deleting the common records and then insert,

and this code is working fine with out any issues.

UPDATE D...

James.N (4/21/2009)

---

Nope, the above loig in not working either . It giving an error Msg 4104, Level 16, State 1, Line 1

"UPDATE TestD

SET TestD.cola=testS.col1,

TestD.colb=testS.col2

...

kylemwhite (4/20/2009)

---

If you are only concerned with dates after 2006, the Microsoft functions will probably be accurate. If, however, you have historical data, then do not trust the Microsoft functions....

RBarryYoung (4/20/2009)

---

I believe that this will do the job:

SELECT Distinct UserID

From (

SELECT *

, ROW_NUMBER() Over(partition by UserId, Comment, CmtTypeGrp order by CheckInID) as GrpCnt

From (

SELECT CheckInID

, UserID

, comment

,...

My bad. Here's the same table...

Lynn Pettis (4/20/2009)

---

Sounds like you need to redefine your problem somewhat. How about providing something closer to the actual problem we are working on. Can you give me...

Jeffrey Williams (4/20/2009)

---

I see how you have defined this as 3 consecutive rows - but, how is the system supposed to do that? What columns define the order...