Be careful when using those updates, they can be really bad. At least, that's what it's explained in here: http://www.sqlservercentral.com/articles/Performance+Tuning/62278/

To prevent the problem, always include your target table in the...

Different option:

SELECT '/' + LEFT( newpathx, CHARINDEX( '/', newpathx, CHARINDEX('/', newpathx) + 1))

FROM #t

CROSS APPLY( SELECT STUFF( pathx, 1, CHARINDEX('/', pathx), '') newpathx) x

WHERE pathx LIKE '%/%/%/%';

mw112009 (9/26/2016)

---

Eirikur Eiriksson:

Sorry, but the first 2 entries in your solution should not be there. The output that I wanted will have exactly 3 "\" characters included.

I will go with...

Why do you want to short circuit the conditions? It won't improve performance and might actually harm it.

mw112009 (9/26/2016)

---

I need a SQL statement that will out put the following values:

( The objective is to grab any values between the first and third "\" character

Sample Output

"/MidwestHealthPlan/Claims/"

"/MidwestHealthPlan/Authorization/"

CREATE TABLE #t(...

Can you share the code that you're using? (you can change the filter if needed)

Also, how are you validating the size? Why are you using disk space to measure them...

Do you realize that dbo is not part of the table name? It's the schema name.

In the case that you really have a point in your table name, the option...

Here's a modified version of the function I posted in here: http://www.sqlservercentral.com/scripts/Working+Hours/111097/

I removed breaks and lunch, and adapted the times.

The DATEADD(DD, DATEDIFF(DD, 0, @StartDate), 0) can be replaced by TRUNC()...

This is an old post, but it never had a reply because...

I'm not sure if it changed in 2016.

The parameters have a property to allow multiple values. If you have a dataset for the available values of your parameter (strongly recommended),...

Someone needs a course on how to write basic DML. Or maybe I'm just grumpy this week.

Remove the parenthesis in the column list from the SELECT

vblllove (9/23/2016)

---

The problem is that I dont have a way if changing the source code. this is an old ERP system (PSI) that its was based on SQL server 7....

Repeating this.

Also, stop...

Too many...