That space is definitely the problem because when you run the query below, it also returns no...

You should recheck my last post as I edited it.

You've got a space in the pattern string that could be impacting it.

tbmabry (1/4/2013)

---

Yes there is data for 238 for top 8. I run just pulling the notes and it works. but as soon as I add the '%[0-9A-Za-z.][@] [0-9A-Za-z.]%'

It doesn't put...

Not sick of you. Just not understanding why this isn't working.

You've changed the INNER JOINs to a CROSS JOIN, which I wouldn't necessarily expect to return the same result,...

No problem... I'm used to toiling in obscurity. :hehe:

ScottPletcher (1/3/2013)

---

That "we" is undefined and thus meaningless. But people who have to...

eugene.pipko (1/3/2013)

---

I was asked to clean up data. The column that I am looking at (nvarchar(20)) contains tax id values.

I needed to identify rows where tax id value contains same...

tbmabry (1/3/2013)

---

I have the following Microsoft SQL but it doesn't know what c(email) is and if I take it out I get no results. 🙁

--Get all the notes from the...

Works for all those cases:

;WITH Notes (Note) AS (

SELECT 'This is a note with email within tomme@gmail.com this ending the note.'

UNION ALL SELECT 'stacey@comcast.net at the beginning with no spaces...

What you posted doesn't look like mine, but based on the query you just posted, it should end up looking something like this:

WITH presel AS (

SELECT s.FirstName, s.LastName, c.CustomerNo,...

SQLRNNR (1/3/2013)

---

dwain.c (1/3/2013)

---

SQLRNNR (1/3/2013)

---

dwain.c (1/3/2013)

---

tbmabry (1/3/2013)

---

Ok, thanks. I found one of them that is making it blow up. It is that the note only has earl@dcande.com with nothing else so...

zombieisdead2020 (1/3/2013)

---

I forgot to say thank you.

The generalizability is necessary.

Because your solution return duplicate combos! you need to filter them.

For example see ComboNo IN (1,...

SQLRNNR (1/3/2013)

---

dwain.c (1/3/2013)

---

tbmabry (1/3/2013)

---

Ok, thanks. I found one of them that is making it blow up. It is that the note only has earl@dcande.com with nothing else so no space...

tbmabry (1/3/2013)

---

Ok, thanks. I found one of them that is making it blow up. It is that the note only has earl@dcande.com with nothing else so no space before the...

zombieisdead2020 (1/3/2013)

---

I think your result is not correct. Run you query with following sample data:

INSERT INTO #n_objects

SELECT 1, 'Apple' UNION ALL

SELECT 2, 'Orange' UNION...