Yes I think it is over complicated, hense the question.

But I did not find a less cumbersome solution.

The specific usage was to add a stored procedure...

Yes this is what I was after.

Thanks very much for pointing me in the right direction.

I just implemented this within my code and it does...

First of all thanks for the example. (Kudos).

I adjusted the example see below. (The identity does not get updated)

When an update is done, all fields are updated exept the identity...

First of all thanks,

Now I see I did muck up a bit, the temp table ##WW should have been ordered, see the code below. Probably lost that part of the...

Thanks for both answers.

I'll probably will go for Luis solution.

This will solve my problem of generating views for more than one database using a single stored procedure.

Thx

Ben

Additional information.

The Showcontig information from both situations is very simular.

dbcc showcontig('B')

/*

-- FROM AN ERROR SITUATION :

DBCC SHOWCONTIG scanning 'B' table...

Table: 'BIL_Performed_Activities' (1157579162); index ID: 1, database ID: 11

TABLE level scan...

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...