March 12, 2008 at 3:18 am
did you test the scripts we provided ?
They may be your starting point.
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data/code to get the best help[/url]
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
March 13, 2008 at 11:44 pm
Yes they are cool!
and actually, i am using similar ones, not exactly same but close to them, to do calculate changes once daily at night, when all new data is loaded.
But my problem remains the same. I need two derived columns. The main problem, and i dont know how to get those derived columns without using CLR.
Some one mentioned that i can use alternative to CLR, dont know yet what is that!
Please tell me!
March 14, 2008 at 1:13 am
As you stated:
I cannot keep the user waiting for that long.
For sure the alternative is using triggers and storing differences only !
Any other alternative will take time ! No doubt about that !
Just because you have to figure out differences at run time (remeber 3 to n columns for a table ??)
Thats why i needed the system where columnName, tableName, and the dates between which the change occurred in a table, and then get values for those columns, dates and objects only.
Thats why, i do need a derived column that extracts the values of "those" columns from "those" tables!!!
The last script provided performs the unpivot to the layout you wanted.
Now you only have to add the scrip Jeff's posted, tamper a bit with it
and there is your solution.
You only need a 5column join on the temptable.
Select *
from #T_unpvt Old
inner join #T_unpvt New
on Old.SourceTable = New.SourceTable
and Old.object_id= New.object_id
and Old.date= New.date
and Old.TheColumn = New.TheColumn
and Old.TheValue <> New.TheValue
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data/code to get the best help[/url]
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
Viewing 3 posts - 31 through 32 (of 32 total)
You must be logged in to reply to this topic. Login to reply