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

This was the old solution.

But I...

spaghettidba (4/18/2014)

---

This could be one way to do it.

UPDATE T2

SET SomeColumn = RandomValues.SomeValue

FROM Table2 AS T2

CROSS APPLY (

SELECT TOP(1) SomeValue

FROM Table1

...

Brandie Tarvin (4/16/2014)

---

FYI: I added semi-colons to the above statements so you don't have to stick a ; before the WITH CTE statement. Not that it helps. Your lines don't...

Thanks Lowell for the example.

I am trying to order the data which I have. Which is the relations between the 'child' and 'parent'.

So I took your example and 'removed' the...

SQL Guy 1 (3/24/2014)

---

I have a table which has a unique integer column. It's not contiguous, it has some gaps.

I need to find a count of records within...

Similar question from here.

Regulary I want to import Excel files. (Or CSV files).

Extention is known.

Format is not predetermined.

Is there a solution for this ?

A general solution which imports data without...

JohnFTamburo (3/24/2014)

---

Hi.

1. What problems are you running into prior to using the SP?

2. Exactly what solution are you trying to accomplish that the DTSX is not accomplishing for you?

The question...

Thanks for the script, in the script I noticed a number of nested...

Eugene Elutin (2/6/2014)

---

If you want to see how many times any sql executed with calling this functions, Gail's suggestion with profile might help.

But it has nothing to do with...