My guess is that they were thinking about marketing, advertising and long lists of new functionality. After...

Construction

So they actually did work on it and yet the space "numbers" are still varchar(18). Sigh.

That's pretty cool. I'm not much of a baseball fan myself, but the fact that the Cubs won a World Series...

Like any off-the-shelf software, there will be parts of it you don't use. You're also going to be limited to the configurable options available. The alternative is to...

If (and this is an assumption on my part) you plan on running your history procedure for every row in AllOrders, it's likely to perform poorly as the number of...

Cowboys...

There could be multiple buildings on campus, so the classrooms should probably...

Eirikur Eiriksson (11/5/2016)

---

There are three ways of doing this, using the describe_first_result_set system functions or procedures, use FMTONLY (deprecated) or OPENROWSET, the last one requiring the "Ad Hoc Distributed Queries"...

TheSQLGuru (11/4/2016)

---

I wonder if there isn't a simpler/more efficient solution if you can introduce a third delimiter thusly (either when the string is built or with a regex, etc):

SET @UserGroup...

ChrisM@Work (11/4/2016)

---

Indexed views - typically these are used as a performance-enhancing trick. Are you experiencing performance issues with...

Telescope

Yes, I've encountered that exact error using SSMS 2008 and SSMS 2012. It's normally when I try to copy large data sets from SSMS to paste elsewhere. It...

Here's another approach that just replies on DelimitedSplit8K. My gut tells me that Luis's is more efficient, but I haven't tested the different approaches against one another.

SELECT s2.Item, s3.Item

...

Eirikur Eiriksson (11/4/2016)

---

Ed Wagner (11/4/2016)

---

From a post this old, my guess is that OP is...