If your application can handle getting two result sets, I'd go that way.

You do have a column that can associate the perms with their users?

Don't be afraid to read through the input data three times. Reading through a table is very fast compared to the cost of doing individual inserts.

Also, you might...

You're dividing by TotalStaffedTime. Apparently you have cases where TotalStaffedTime = 0. What do you...

For this, you wear the HAT OF SHAME.

Jeff, why are you quoting yourself now?

Guys, I agree that minimizing the logical reads is always a good idea. My point was that the article espoused accepting more...

George, I read and understand what you are saying, but I have run the queries multiple times with ANSI_NULLs OFF and ANSI_NULLS on.

* Query 1...

Christian, just in case you're still following this thread. The answer that we all agree on is that the correct index choice depends on the particular usage of...

As a general rule, yes. There may be...

Amen

Martini

Interesting discussion, but I am concerned about the casual dismissal of the number of logical reads. A consequence of more logical reads is that, in a busy system,...

Thank you for setting the problem up so nicely.

The problem is that something about the REPLACEs below is limiting your result below to NVarchar(4000).

When your outer replace goes over that...

Steve Jones - SSC Editor (8/15/2016)

---

ChrisM@Work (8/15/2016)

---

Steve Jones - SSC Editor (8/15/2016)

---

ChrisM@Work (8/15/2016)

---

Someone was a little overzealous with spam removal over the weekend. On Saturday morning there was a new...

Pork

Hey Lynn,

A quick example follows. It needs a lot of polish, but I just wanted to illustrate the concept.

Like other SQL splitters, this shouldn't be used for strings...