xsevensinzx (4/7/2014)

---

Koen Verbeeck (4/7/2014)

---

xsevensinzx (4/7/2014)

---

Depends. If you don't have much...

xsevensinzx (4/7/2014)

---

BTW, how big can cubes be? How are they stored? Could I build a cube with 30 dimensions and 100 million records without breaking the system? Or are you...

xsevensinzx (4/7/2014)

---

Depends. If you don't have much experience with SSAS...

Right.

What happens is that you have your two single quotes opening as text delimiter.

SSIS will continue reading data and adding it to the column until it encounters the two closing...

Resender (4/7/2014)

---

so the line I'm getting the error on is getting is something like this

''Rac ..... ''Rac company description ..... 251

Now what happens the next line instead of being the...

Adi Cohn-120898 (4/7/2014)

---

Talking about getting it wrong. I completely misunderstood your needs. You really need to explain what you want. It would be helpful if you'll also have...

s.ravisankar (4/7/2014)

---

c1<---->c2

1<---->2

2<---->3

3<---->4

11<---->12

12<---->13

13<---->14

We have data like this

I)

In transaction 1 : 1 updated to 2

In transaction 2 : 2 updated to 3

In transaction 3 : 3 updated to 4...

A double quote is not the same as two single quotes.

A double quote is one character, so I don't think it was there to escape a single quote.

The error probably...

Do you have actual knowledge of the product, or are you just memorizing answers?

ps: did you try Google?

This should do the trick.

WITH CTE_rownumbers AS

(

SELECT Agreement_Area_Id, RID = ROW_NUMBER() OVER(ORDER BY Agreement_Area_Id DESC)

FROM [dbo].[Agreement_Area]

)

UPDATE aa

SET Agreement_Area_Number = cte.RID

FROM [dbo].[Agreement_Area] aa

JOIN CTE_rownumbers...

The UPDATE statement itself is pretty simple using the ROW_NUMBER function.

Maybe you can create some dynamic SQL: loop over the different tables, insert the table name in the update statement...

s.ravisankar (4/7/2014)

---

1 is updated to 2

then 2 is updated to 3

then 3 is updated to 4

here I want to update 4 for all (1,2,3) because 4 is the...

Interesting question, thanks.

You do have the table DDL, don't you?

This is something you can easily add in the source query with a CASE statement.