That's what I call salary negotiations. 😀

Thanks for the test data. Just a little bit too late 😀

You can use a CTE and ROW_NUMBER over NameId PARTITION:

DECLARE @t TABLE (Name VARCHAR(20), Geo VARCHAR(20), NameId INT)

INSERT INTO @T

...

Bruce W Cassidy (5/21/2009)

---

[font="Verdana"]There are some numbers that FLOAT cannot represent. 0.3,...

BOL: DATEDIFF

This could depend on the events you track. Maybe Gail's article brings light into darkness:

http://sqlinthewild.co.za/index.php/2009/04/29/functions-io-statistics-and-the-execution-plan/

Goldie Graber (5/22/2009)

---

For some reason when I use GetDate() I always get zero.

When I use the view I get some value, usually under 100 ms.

I'm thinking that's because SQL Server...

???

There is anybody watching soccer in...

Hi Piet

I know what you...

RBarryYoung (5/21/2009)

---

Greg Edwards (5/21/2009)

---

Ill never forget...

Jeff Moden (5/21/2009)

---

Or, use a leading comma and STUFF it just...

Glad that we could help!

Try this:

DECLARE @T TABLE (Name VARCHAR(100), StartDate DATETIME, Data1 BIT, Data2 BIT, Data3 BIT, Data4 BIT, Data5 BIT)

INSERT INTO @T

...

Bruce (5/21/2009)

---

Here is some sample data that might help.

mike, 05/21/09, 1, 0, 0, 1, 0

bruce, 05/21/08, 0, 1, 1, 0, 0

john, 09/09/09, 0, 0, 0, 0, 1

I guess there is...

Hi Piet

I just figured out. The problem of my (and your) CLR was the RegEx usage. It's much slower than your simple string.Replace. I tried your function and it was...