Have you tried the documents related to installing the SP on MicroSoft's site? What have you tried?

jcrawf02 (11/19/2010)

---

WayneS (11/18/2010)

---

That's nothing... I've...

That's nothing... I've seen posts...

You're welcome. Does it meet your needs? And, do you understand what it's doing?

You will need to install SP2 on each node. When installing, you can select which instances to apply it to - you would normally select all. (I just went through...

If you don't understand what's going on, just ask. This "FOR XML" "trick" is...

Thanks, glad it works for you (but hey... I did test it... would you really expect it to not work as desired?)

Dick Herberts-320552 (11/18/2010)

---

Hi Wayne and other techies,

Today i tested Wayne's routine on a table with 20.000.000 records. In total 6 columns are calculated and updated by Wayne's routine and it...

Heh... we learned from the master! :w00t:

This should handle it for you...

SET DATEFORMAT DMY; -- to handle the format of your dates

-- See how you start off by actually creating a table

-- and then inserting the...

Blocks = # of hours for the gap?

CirquedeSQLeil (11/17/2010)

---

I love finding out that a project has a dependency on a task assigned to you - when everything else is done and ready to be deployed. Communication,...

MM -

Looks interesting. It will take more investigation.

I have some initial questions:

1. So, what...

He doesn't think it will finish that fast... won't he be in for a surprise in the...

LutzM (11/17/2010)

---

@Dick: VERY IMPORTANT!!!

Based on your previous note "4. No clustered index yet " Do NOT run the code until you added a clustered index that supports the order the...