Viewing 15 posts - 3,316 through 3,330 (of 11,678 total)
xsevensinzx (4/7/2014)
Koen Verbeeck (4/7/2014)
xsevensinzx (4/7/2014)
Koen Verbeeck (4/7/2014)
Is aggregating the data, dumping the results into a physical table a crazy option when there is SSAS available?
Depends. If you don't have much...
April 7, 2014 at 7:50 am
xsevensinzx (4/7/2014)
April 7, 2014 at 7:29 am
xsevensinzx (4/7/2014)
Koen Verbeeck (4/7/2014)
Is aggregating the data, dumping the results into a physical table a crazy option when there is SSAS available?
Depends. If you don't have much experience with SSAS...
April 7, 2014 at 7:28 am
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...
April 7, 2014 at 5:12 am
Resender (4/7/2014)
''Rac ..... ''Rac company description ..... 251
Now what happens the next line instead of being the...
April 7, 2014 at 4:22 am
Adi Cohn-120898 (4/7/2014)
April 7, 2014 at 4:21 am
s.ravisankar (4/7/2014)
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...
April 7, 2014 at 4:01 am
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...
April 7, 2014 at 3:50 am
Do you have actual knowledge of the product, or are you just memorizing answers?
ps: did you try Google?
April 7, 2014 at 3:41 am
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...
April 7, 2014 at 1:58 am
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...
April 7, 2014 at 1:42 am
s.ravisankar (4/7/2014)
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...
April 7, 2014 at 1:33 am
yuvipoy (4/7/2014)
i got this from profiler, so i dont have execution plan.
You do have the table DDL, don't you?
April 7, 2014 at 12:30 am
This is something you can easily add in the source query with a CASE statement.
April 7, 2014 at 12:27 am
Viewing 15 posts - 3,316 through 3,330 (of 11,678 total)