Thanks for you response, offcourse this was a 'simplyfied'...

Hello all,

Thanks for your contributions and sorry for not responding.

This weekend I had a fall and have a head injuri. In a few days time everything should be back...

Thank you this is exactly what I was looking for.

Ben

LutzM (4/25/2014)

---

By definition, there is no "first...

mister.magoo (4/21/2014)

---

The problem I see with a truly random fill is that you need to select one value from 4000 for each of 700,000 source rows, so I can see...

First thanks for your contribution.

In your solution, the Target table...

Code is used for several reasons.

Mostly to...

mister.magoo (4/19/2014)

---

Yes, I can see that taking a long time as it is performing the outer apply ( selecting 1 from 4000 ) for each of the 700000 target...

mister.magoo (4/19/2014)

---

Like I said, I couldn't guarantee it, although on the test data you supplied, it worked for me where the other methods failed.

You definitely used an outer apply, and...

mister.magoo (4/19/2014)

---

Try this...simply referencing a column from the target table in the APPLY, using OUTER instead of CROSS and updating the referenced column as well forces the randomisation to work...

Tried the solution.

And I am trying to understand the solution.

First the solution does not work if the target table is larger than the...

Both tables where of the same...

print '-- Start of use_value.full_name_txt : '+convert(varchar(30),getdate(),126)

--

-- Get the max from the use_value table.

--

declare @Max_number int

select @max_number = count(*) from use_value

print 'number use_value, full_name_txt :'+convert(varchar(10), @max_number)

;

WITH

T...

ben.brugman (4/18/2014)

---

spaghettidba (4/18/2014)

---

WITH T1 AS (

SELECT *, randowCol = NEWID()

FROM Target

),

T2 AS (

SELECT *, RN = ROW_NUMBER() OVER (ORDER BY randowCol)

FROM T1

)

UPDATE T2

SET full_name_txt = (SELECT column1 FROM Use_value V...

spaghettidba (4/18/2014)

---

WITH T1 AS (

SELECT *, randowCol = NEWID()

FROM Target

),

T2 AS (

SELECT *, RN = ROW_NUMBER() OVER (ORDER BY randowCol)

FROM T1

)

UPDATE T2

SET full_name_txt = (SELECT column1 FROM Use_value V WHERE...

Actually adding a RND column to the table, using it and removing it hardly...