Lynn Pettis (4/20/2009)

---

I have not had any trouble with the "quirky update" method and I have tested it on a test table of up to 10 million records with...

Lynn Pettis (4/20/2009)

---

Is there more to the real world data that would support the sequence of data entered? is there a date field or other form of identification that...

bruce.trimpop (4/16/2009)

---

Matt Whitfield (4/14/2009)

---

bruce.trimpop (4/14/2009)

---

Bruce

Here is the SQL i used on 2000 to re-create the data and tables - some mods were required, so hope you can check.

Is it...

jaimepremy (4/18/2009)

---

Hi there,

I'm having a hard time rounding avg results upwards (underlying dataype is int).

For example if the sum of 3 rows = 8, then avg should be 3 since...

drodriguez (4/17/2009)

---

Anyone know of a function I can use to convert the UTC date/time field to Pacific Time? I know I can use dateadd to subtract the 8 hours, but...

As a post script, I ended up using Bevan's method.

It works well on tables with up to a few million records. Takes a minute or two.

When I had to run...

Virenda, why...

Lynn Pettis (4/8/2009)

---

I see three consecutive blanks for UserID 2. If you are taking the consecutive blanks AS ENTERED, then where are the three consecutive blanks in your original...

That won't work, Lynn. It doesn't take into account consecutive blanks.

For example if I use the following data, I still expect 1 as the answer but your query returns 1...

Now THAT's one really smart idea!

With the addition of an ORDER BY and a trailing comma it works perfectly.

Here's the final code:

;WITH OrderedCheckIn AS

(

SELECT UserID

, (SELECT ',' + ISNULL(Comment,'')

FROM #CheckIn...

Here's what I have now. It seems like it's working correctly.

However, when I try it on a real data table with 5 million rows it returns inconsistent results.

-- create a...

I think this may have something to do with the amount of data being manipulated.

The table we are talking about contains 4 million to 10 million rows.

The update method seems...

Very cool Barry!

Wish I could make use of it.

Would you post it here for the rest of us?

Jeff Moden (3/16/2009)

---

Goldie Graber (3/16/2009)

---

Jeff Moden (3/16/2009)

---

One of your requirements was to ....

4. Replace all entity codes (“&xxx;”) with X

If you "smear" that...