select @SearchString = REPLACE(@SearchString, LastName, '')

FROM ThisTable

select @SearchString

Mansfield (4/28/2013)

---

I would set up the SSIS package to insert into a staging table first. Then use a SQL task to check for references in the staging table that...

There is a simpler way.

No updates required:

--===== Create a test table.

-- This is NOT part of the solution.

IF...

Computed column would be a good option for you.

That...

antony-688446 (4/30/2013)

---

I understand that 🙂 I didn't explain my example thoroughly enough - I was trying to provide an example to Tom's explanation of tri-state logic. In my example, it...

There were times when you could teach students by...

ronmoses (4/30/2013)

---

Bob Cullen-434885 (4/30/2013)

---

So here's a question. If variables are initialized at parsing time - I take this to mean that the DECLARE is interpreted prior to the INSERT...

antony-688446 (4/30/2013)

---

For those struggling with the difference between 'False' and 'Unknown', and how the IF statement works, consider what happens if we change the example code a little bit (I...

Comma separated names...

I wish that would be a...

create table dbo.Location (

id int identity,

Name varchar(100),

constraint PK_Location PRIMARY KEY (id),

constraint UK_Location unique (Name )

)

create table dbo.TravelAttribute(

id int identity,

Name nvarchar(1100),

constraint PK_TravelAttribute PRIMARY KEY (id),

constraint UK_TravelAttribute unique (Name )

)

create table onward_journey

(

onward_journey...

Thanks Jeff for keeping it up.

🙂

Your list of suggested action is perfect, but I'd say it's a bit overkill for beginners.

To start - it's important to remember doing regular LOG...

Thanks everyone for positive feedback.

As you can guess the question came from practical experience when developers were puzzled with "odd" behaviour of SQL Server.

Had to build this sample script to...

That would be for Kevin...