hughesj23 (8/21/2014)

---

I feel like this is a dumb question, but here we go.

I have a SQL database on Server1 called DB1. I need that entire database copied over to...

The bug that was afflicting the thread is fixed!!! Thanks very much, Steve. I, for one, have missed the water cooler. 😉 If you're so inclined, I'm...

+1. Yep, a nice and easy one to end the week. Thanks, Steve.

I don't see what you're after either. Good job posting consumable DDL and sample data. Could you please explain the logic behind how you get the output you're...

Yeah, the Forum home page was behaving strangely for a while, showing the legend inside the Last Post column, but it seems to be fixed now.

Some topics themselves are showing...

Eric M Russell (8/21/2014)

---

If sufficient functional requirements are not provided upfront, then all these "fixes" in production are really just change requests and phase I, II, ~ deployments. A solution...

Green

Espresso 😀

Expensive

Nice question, thanks. But I'm with Koen - I've never used a table name that long and I expect to be beaten by someone if I do.

Good point, Luis, but your solution still performs better. I've tried to get the DelimitedSplit8K function to handle MAX data types, and they simply don't like being joined to...

Luis, nice work.

sqldriver, I would give Luis's solution a try instead. It operates on the base strings themselves and doesn't split them out into their component parts. As...

Glitch

Okay, now that's just a really cool puzzle. The following uses the "Swiss Army Knife" that is Jeff's DelimitedSplit8K function.

WITH cteText(string) AS (

SELECT 'oh_look_at_this.thing.his\hers_stuff\mine.craft\yours_protein' UNION ALL

...

Well, given the day, how about a new WOTD? Seems fitting...

Bug