Thanks Tim. This was a nice reminder on accepting and owning up to a mistake. It is not a pleasant situation to need to discuss a mistake with...

WayneS (2/24/2010)

---

FYI, Gianluca's unpivot works the fastest on my system (813ms), though Lynn's is right behind (833ms) - initial runs. But, when run repeatedly (and randomly), they actually flip-flop back...

Grumbling may happen. People will adjust - even if it takes a little longer to adjust than wanted. Deadlines may get pushed, but security and quality should carry...

BaldingLoopMan (2/24/2010)

---

Testing cycle complete. CirquedeSQLeil’s savvy solution although a little unorthodox worked perfectly. Nice work. I now have a process that uses linked server to query n number of sql...

Look at that, Barry needs 23 points for 9000 - big milestone.

jcarney 24614 (2/24/2010)

---

The data type for the table varies depending on the column. There are several "nvarchar" columns but the ones I am focused on are set to...

There was an update to the code - I didn't post it to the contest just in this thread.

That is interesting that it took that much longer for it to...

jcarney 24614 (2/24/2010)

---

Ideally, the data would be converted each time it is passed through SQL Server. I looked at using update queries in Access, but I would have...

jcarney 24614 (2/24/2010)

---

Thank you for the quick response. I did come across that, but I'm not sure where to apply it. I've been trying to edit...

Elliott W (2/24/2010)

---

I don't fully agree with Cirq..

I think a fundamental problem with many dev and test environments is limited data, prod data may not belong, but prod...

This may be of use

http://sqlblogcasts.com/blogs/ssqanet/archive/2008/04/22/error-there-is-insufficient-system-memory-to-run-this-query-and-downgrading-backup-buffers-from-960k-to-64k.aspx

Is the SSIS package running from a different workgroup or different domain?

Prod data does not belong in development. There is no problem having the data scrubbed and used in dev - except for effort in scrubbing it.

I recommend developing a...

I think you should start a new thread with this question.

No, I think you win.

By the way was that Dolly?