Paul White (11/17/2009)

---

http://www.letmebingthatforyou.com/

(I was tempted...

Sure should - though someone beat the creator of the site to the domain name (see this linky...

http://www.letmebingthatforyou.com/

(I was tempted to post...

No worries 🙂

Matt Miller (#4) (11/17/2009)

---

I think there's a disconnect....

Not sure what you mean, but SQL Server 2008 has date and time types accurate to 100 nanoseconds.

How do you know which record is first, second, and third?

The records don't appear to be numbered, or have any obvious sequence.

Sure, you listed them in an order, but that...

http://stackoverflow.com/questions/634122/milliseconds-wrong-when-converting-from-xml-to-sql-server-datetime

* goes out to buy a Lotto ticket * 😀

An alternative to the simple stored procedure is to use a disconnected recordset and batch update mode:

From memory!

-- Client based cursor

rs.CursorLocation = adUseClient

-- Get the structure of the target table...

Recovery interval:

SQL Server makes an internal estimate of the number of data modifications it could roll forward (re-do) from the log in the time allowed (in minutes). ...

Sean,

I had to make some guesses, but try this:

SELECT supplier = ITM.poit_supplier,

local_orders = SUM(CASE WHEN ORD.pord_pondcode = 'Local' THEN ITM.poit_valord ELSE...

Rob Fisk (11/17/2009)

---

Just under the first code segment:

The goal is to convert the sections of multiple spaces of unknown length to a single space each as quickly as possible. There...

LMGTFY version 2.0:

http://tinyurl.com/yz8f2jd

You'll find full details Here On TechNet. That is a link to the Configuring High Availability Chapter. Log Shipping and Database Mirroring are sub-chapters from there - use...

Not really, no. Using the string "||*9*9||" as a replacement has a huge hidden...