SELECT Customer,ShipPostalCode,left(ShipPostalCode, ((PATINDEX('%[0-9]%', ShipPostalCode+'1')-1))

FROM ArCustomer

I would just append a number such...

The query plan is timing out, and I'm not surprised!

Take this one simple looking expression in the WPO CTE:

CASE WHEN WO.[DATE] = COALESCE(TW.WEEK_ENDING -6, WP.PATTNDATE -6) THEN COALESCE(WO.[HOURS], WP.[HOURS]) ELSE...

what do you want to do when you come across an...

GilaMonster (11/14/2014)

---

SSMS doesn't have a T-SQL compiler. When you ask for a...

If you want a major duration boost, you can always slip Adam Machanic's "make_parallel" function into the mix and then you get some serious results...

Adam's function : http://sqlblog.com/blogs/adam_machanic/archive/2013/07/11/next-level-parallel-plan-porcing.aspx

In use for...

Nice question.

I started reading and thought how odd it was to see tsql without semi colons these days....I soon realised why 🙂

ian 43089 (10/17/2014)

---

Thanks for the reply.

The problem is that I'm using TSQL to get some query data (that contains single quotes) and I need to return that as valid XML...

Did you check that the string does not have a space at the start, which would lead to a value of 2014-10-1 begin converted...

Thanks Melanie,

No, I still can't reply on that thread.

Is this in any way related to how long it is taking to edit/add posts as well or is that a...

Correctly encode the single quote as &apos ?

Not so sure that it would be correct anywhere except in an attribute that had been enclosed in single quotes itself?

If it is...

Melanie.Townsend (10/15/2014)

---

Just to reiterate what Steve said in his post over on The Thread yesterday, we've implemented ASKIMET for posts. This took effect yesterday and shouldn't slow things down, but...

No problem, thanks for...

This is where only allowing updates through stored procedures helps...

it's a simple bit of code added into the stored procedure to write a copy of the event data to a...

I was just testing to see if you were paying attention 😎

Hopefully all solved now - certainly looks right for all the problems you've shown so far.

That should work but put SSMS into text output mode (press ctrl-t before running), not grid mode or you won't see the line breaks.

It could be that your web application...