sturner (3/1/2012)

---

aurato (3/1/2012)

---

I had a hunch this might be it. Is it safe to change...

I had a hunch this might be it. Is it safe to change the data...

Eugene Elutin (3/1/2012)

---

Have you ever heard of JOIN's in SQL?

SELECT s.*

FROM SOP30300 s

JOIN #StatusHistory h ON h.SOPNUMBE...

Thank you very much. Exactly what I needed to know.

Alright. Thanks for your help. Have no idea how they did it either. Time to log it myself; lesson learned.

Thanks, but how...

Also if anyone's interested, I did this to create a column that has one of three values:

SELECT TOP 1 INUPD

FROM

(SELECT NEWID() AS Random, 'INSERT' AS INUPD

UNION ALL

...

Wow, helluva response! :w00t: Thanks everyone for your input.

In the last response, what do you mean by "masking" data?

GSquared (1/12/2012)

---

There are a number of ways to do it. Far as I know, Jeff is actually working on an article about them.

One of the easiest, if the tables...

This is the procedure I'm trying to use. I attempted this to join to a field that already had a '%' for the LIKE in it. It didn't...

Aaron Aardvark (1/9/2012)

---

aurato (1/9/2012)

---

I probably don't need Unicode. But I have a boss who insists upon it. One day it might be useful, who knows. The other...

Very sorry then. First time I ever...

GilaMonster (1/9/2012)

---

There's still a question? Thought from your comment you were happy.

Want anything useful? Post actual execution plans and queries and table designs. (p.s. you have huge tables, don't expect...

Bumping

Well to add some further context, it's part of a stored procedure that does this:

Input is @SearchString nvarchar(255)

Separate @SearchString into table variable

E.g. 'This Is a Search String' becomes

Keyword

---------

This

Is

A

Search

String

Then I inner...