Thanks a lot J. That means a lot!

Here's a couple solutions based on what your output should look like for the values "MDL-9054-1" and "TX GMS-7000"

DECLARE @strings TABLE(string varchar(100));

INSERT @strings VALUES('MDL-9054-1'),('TX GMS-7000');

SELECT

ColA = SUBSTRING(string,1,CHARINDEX('-',string)-1),

...

Another approach would be to split the text into word-level bi-grams using NGrams8K[/url]. See the article for the function and a description of what a word-level bi-gram is.

Using...

Haha! +1

SELECT

p.ProjectNo,

ProjectType = CASE WHEN p.ProjectType = 'new' AND x.ProjectType IS NOT NULL THEN 'new' ELSE '' END,

p.Location,

ChildDef = ISNULL(ChildDef,'')

FROM dbo.projects p

LEFT...

Or this:

SELECT *

FROM dbo.projects

WHERE Location IN

(

SELECT Location

FROM dbo.projects

WHERE ProjectType = 'new'

)

Ok, my final...

Sergiy (6/30/2016)

---

Wow!

That's a big bunch of code!

Compare to this (using the table I've posted above):

DECLARE @StartDate SMALLDATETIME, @EndDate DATE, @WeekStartsFrom VARCHAR(50)

SET @StartDate = '20160501'

SET @ENDDATE = '20160531'

SET @WeekStartsFrom =...

DiabloSlayer (6/30/2016)

---

Hi Alan,

Thank you for the update and help !!

So I ran the update script for the period of 05/01/2016 to 05/31/2016 and I'm not sure why I'm getting two...

TheSQLGuru (6/30/2016)

---

Alan.B (6/30/2016)

---

Kevin said a lot of what I was going to say especially about fixing that sort with the tempdb spill - that's going to kill you. An index...

Kevin said a lot of what I was going to say especially about fixing that sort with the tempdb spill - that's going to kill you. An index on [WOEC].[WOE].[ORDER_ITEM].ORDER_ITEM_UID,...

DiabloSlayer (6/26/2016)

---

Hi Alan Burstein,

I ended up using your solution so thank you VERY MUCH 🙂

I just have two questions for you, first, how can I change the start date to...

Luis Cazares (6/29/2016)

---

oradbguru (6/29/2016)

---

Hello, I was debugging some legacy code and came across an insert statement with only this in the where clause.

WHERE ' ' = ' '

Any ideas what...

Forgive me if I'm wrong (it's been many years since I was a DBA) but I believe they would also need at least public access to the msdb database.

Solomon Rutzky (6/26/2016)

---

Hey Alan. Interesting request. I do have a suggestion for the code, but first I would like to mention that it is probably best to state at the...