January 4, 2009 at 9:18 pm
Hi,
I have a table which has date column and few other columns. I have to take the difference between the current row and the previous row and store the calculated value in a new table. How to accomplish this in SSIS? Please give me ideas to do this.
Thanks.
January 4, 2009 at 10:12 pm
Hi all,
Please reply me. Atleast , tell me how to write query to get the difference between columns of two different rows.
January 4, 2009 at 10:17 pm
Please describe what you mean by 'difference'.
Eg, if
row a contains: 'Fred', 12, 1980
row b contains: 'Bill', 150, 27
what would the difference be?
Also, what order are your rows in?
The absence of evidence is not evidence of absence.
Martin Rees
You can lead a horse to water, but a pencil must be lead.
Stan Laurel
January 4, 2009 at 10:44 pm
Hi,
I have a table which has date column, and name of equipments in other columns. Difference means, consider if the data is,
9/12/2008 4:10:00 PM 40694.684
9/12/2008 4:20:00 PM 40728.62
I need to substract the second row with the first row and then get that value . I need to substract for all the columns.
My table has nearly 100 columns and rows.
Please help me.
Thanks.
January 4, 2009 at 11:38 pm
Do you want to process the rows in ascending date order?
If your source has rows 1, 2, 3 and 4, what will be in your calculated table?
Will it be
1-2
3-4
or
1-2
2-3
3-4
?
The absence of evidence is not evidence of absence.
Martin Rees
You can lead a horse to water, but a pencil must be lead.
Stan Laurel
January 4, 2009 at 11:41 pm
It will be like 1-2, 2-3, 3-4,....
Where 1 is the recent date value.
It will be in descending order
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply