Hi ,

Thanks for the quick reply. But this script is also not meeting my requirement. If you see ID 1 , The output must be like this

SELECT 1AS ID ,'2016-02-02...

John,

I was just explaining the scenario..I don't want the exact result set posted in the screen shot. Since as you told, you understand the scenario, I just gave some sample...

Data can be anything. It can be either same or different. so I gave different data.

Hi John, here is the sample data scripts

DECLARE @ReportingGroupChanges TABLE

(

AccountId nvarchar(50) NOT NULL

,ReportingGroupID nvarchar(50) NOT NULL

,Operation...

Are you able to see the Before and After columns shown red in the screenshot? That is how the expected output should display.

User can add ReportingGroup to an account ....

Hi John,

the scenario is that I want to track the changes over a period of time. showing like before and after the modification. Modification can be either update or delete.

I...

Grant, It could be any number. I am expecting in thousands..not more than that...And I am going to use CreatedOn column in WHERE clause.

I know John, Performance will be affected. But I have no other option.

ORDER BY CreatedOn column...in descending..

Hi John,

I will have rows in thousands like 10k...I have to sort based on createdon desc

Grant, Just forget about the open query..I gave you sample data and the expected outcome. I am trying to write a script without using while loop.

No Grant, I have not posted the complete part. I am trying to achieve this through while loop which is okay. I am able to get the result. But unfortunately...

Thank you so much , Twin. It works absolutely fine. There are minor decimal point difference in the Exposure field. But that's okay...Script executes lighting fast. 🙂

Thanks, Twin. I will try as like as you told. I will get back to you with my result.

Hi Twin,

Actually it is a SP and below is the complete script that executes in different server. There is a config table which is called by another SP which holds...