OVER (PARTITION BY UserLogon ORDER BY createdon DESC)

Paul White NZ (4/8/2010)

---

I'm going to try to find a little time tonight to knock the handshake thing up in a CLR routine - it's a lot easier to write...

Garadin (4/9/2010)

---

I am, but I know Jacob already has...

Chris Morris-439714 (4/9/2010)

---

Ninja's_RGR'us (4/9/2010)

---

Chris Morris-439714 (4/9/2010)

---

Hi Ninja

It would be better to change the string list from comma-delimited to fixed position, three character positions per item - that way, the upper...

Chris Morris-439714 (4/9/2010)

---

Hi Ninja

It would be better to change the string list from comma-delimited to fixed position, three character positions per item - that way, the upper limit would be...

rpatil22 (4/9/2010)

---

Are the followings indexes are correct for rows 110k?

Table contain following Columns

employeeId - uniqueindentifier ( primary key )

machine - nvarchar(100)

firstname - nvarchar(100)

lastname - nvarchar(100)

startdate - datetime

finishdate - datetime

location...

Chris Morris-439714 (4/9/2010)

---

Garadin (4/8/2010)

---

Chris Morris-439714 (4/8/2010)

---

Ninja (Remi?)

Sympathies mate. How much leeway do you have with the db? Can you for instance sneak in a trigger here and there, and maybe...

Garadin (4/8/2010)

---

Ninja's_RGR'us (4/8/2010)

---

Garadin (4/8/2010)

---

Chris Morris-439714 (4/8/2010)

---

Ninja (Remi?)

Sympathies mate. How much leeway do you have with the db? Can you for instance sneak in a trigger here and there, and maybe...

Garadin (4/8/2010)

---

Chris Morris-439714 (4/8/2010)

---

Ninja (Remi?)

Sympathies mate. How much leeway do you have with the db? Can you for instance sneak in a trigger here and there, and maybe a link...

Garadin (4/8/2010)

---

Chris Morris-439714 (4/8/2010)

---

Ninja (Remi?)

Sympathies mate. How much leeway do you have with the db? Can you for instance sneak in a trigger here and there, and maybe a link...

Ninja's_RGR'us (4/8/2010)

---

Chris Morris-439714 (4/8/2010)

---

Ninja (Remi?)

Sympathies mate. How much leeway do you have with the db? Can you for instance sneak in a trigger here and there, and maybe a link...

Chris Morris-439714 (4/8/2010)

---

Ninja (Remi?)

Sympathies mate. How much leeway do you have with the db? Can you for instance sneak in a trigger here and there, and maybe a link table?

It's...

Chris Morris-439714 (4/8/2010)

---

Ninja's_RGR'us (4/8/2010)

---

ShippingHeader and InvoiceHeader has FK to OrderID

1 order can have...

Is this too simple??

Where Col LIKE '[0-9]%'

That's my favorite for clarity...

Thanks Paul... getting it done is not really the problem. Getting it done on the fly and / or without wasting a week to do it fast is really...