Jeff Moden (10/7/2016)

---

Oh my... with a title like that, I'm not sure how I missed the original publication of this article, Luis. Thanks for taking the time to...

Poliwag

Here's a query with three conditions that should fulfill your requirements.

SELECT *

FROM #tmp

WHERE loginName LIKE '%_._%' --Has a period surrounded by other characters

AND loginName NOT LIKE '%.%.%' --Has...

brymen (10/7/2016)

---

EXCELLENT Article!

All I can say is more, more... I want to read more articles like this one!

You can bet I will be sharing this one...

Phil Parkin (10/6/2016)

---

Ed Wagner (10/6/2016)

---

Yeah, that's a good one....

The subject is interesting, but you're trying to cover a wide set of topics. Try to get a series of articles instead of just one. At least, that's my opinion.

Be careful, you might want to use UNION ALL to prevent that duplicate rows are eliminated (in case that the aggregations return the same value for the funding scheme).

You also...

deekadelic (10/5/2016)

---

Since I'm not the administrator of the database, I don't know what additional tools have been installed. How can I determine whether or not I have Redgate SQL Prompt...

George, enjoy your retirement and try to keep yourself busy and sane.

Brandie (and possibly others), take care. Let's hope that Matthew doesn't leave a big mess.

Drew, congratulations on the article....

If you haven't closed the window, use Ctrl+Z until you undo all changes. Then run the code to restore the procedure to its original code.

If not, follow Phil's advices. Good...

Reproduction

Right now, your code can be simplified to the following.

UPDATE dbo.SaltoCardholders

SET <column_x> = '<some_value>'

WHERE GPF5 = 'VWB';

I'm sure that doesn't solve your problem, but we need more information to...

Following the rules you posted, here's an alternative.

DECLARE @SourceTable TABLE (

ID INT IDENTITY(1,1)

, adres VARCHAR(255)

);

INSERT INTO @SourceTable (adres)

VALUES (' molenweg 9a '), (' molenweg...

ANSI

That's exactly it.