You answered this yourself...

as far as I know from all our conversation...

sqlfriends (7/22/2013)

---

I have a database that imported some students' info from a text file.

When importing into the raw table, the studentID is set as varchar(9).

Then we select from the raw...

I agree with Chrissy. If you need varchar(max) as a foreign key you have some very serious design issues. If you want some actual help you will need to post...

I agree with Steve that if this information is potentially sensitive then the system was designed poorly. This type of information should NOT be populated through a number of tables....

richard.noordam (7/22/2013)

---

it's because you aren't actually looping through the data. put an identity column in and then reference it with your count and it will likely work fine.

you might...

Your problem is the select statements inside your loop.

set @Recepient_Email = (select top(1) EMAIL From TESTDATA where @count=@count)

set @Body1 = (select top(1) TESTDATA.BODY + '' + TESTDATA.UNIQUE from TESTDATA where...

Yes you can still do a wildcard search.

inner join #search s on

...

So what you really want is a way to randomize the values in your test system? This is an entirely different situation than encrypting data in a column. Of course...

Here is the OP's "original post".

--------------------------------------------------------------------

Help! 😉 I have to run through a table of data a couple times (I think) to get the results I need. The subject...

Learner44 (7/22/2013)

---

Hi Sean ...

can you please suggest me any way to achive the following objective.?

what should I do , in order to restrict other 5 users , having same access...

Why do...

Learner44 (7/22/2013)

---

yes you are right..it's all about my language barrier..as english is not my first language..I always find my self in backfoot , while explaning the situation , what I...

If the features are not an issue than go with Standard.

Without the details that you can't get to post you are right, this is pretty hard to figure out what is going on. I know that some people do have...

davdam8 (7/22/2013)

---

U right

->

INSERT INTO #mytable

(ID, Value)

SELECT '4','First' UNION ALL

SELECT '37','Second'UNION ALL

SELECT '44','Second' UNION ALL

SELECT '54','Third' UNION ALL

SELECT...