I want to avoid dynamic sql but my Table name varies for different run, is there any better way to avoid the dynamic sql in this situation?
I am trying my best, searching, asking and implementing different approaches etc, if anybody can give me some suggestion, link or even code snippet that would very helpful.
I have a table (Table123) that has Columns ColA, ColB, ColC, ColD, ColE, ColF, ColG, I have many rows entered in the same table but want to check for two rows RowA, RowB, if for example I have three columns that are different in these two rows, I want to select those Column Names, like if ColA, ColC and ColE are changed then my query should return me as below
TableName, ChangedColumnName, OldValue, NewValue
Table123 , ColA, 123 Greetings 123 New Greetings
Table123 , ColC, 123 World 123 Hello World
Table123 , ColE, 123 Test World 123 New World
Is there anyway I can do it, but without using dynamic sql any help would be greatly helpful, thanks in advance.
Thanks in advance
"There is already enough hatred in the world lets spread love, compassion and affection."
-- modified 17-Apr-17 16:04pm.