Hi @HanShi

Thank you very much for providing your valuable solution. Unfortunately i tried running your code over my original data set and it taking lot of time to...

Thanks for replying, much appreciated
We are enabling temporal on my subscription table, not on my publisher table as it is an application database we cannot perform DDL over there.

Thanks to  http://tryr.codeschool.com/   learned it from there.

Thanks everyone for quick response.
I am analyzing all the solutions provided by you guys for different users and cases. Will get back to you in case of any issues.

Thanks for the question.

Nice and Easy.

Thanks

Thanks Tom, have forwarded my query to stackoverflow.

Nice question, Thanks.

But little confused with the explanation of "Another Interesting Fact":

when you remove in session 1 the GO between the UPDATE and the WAITFOR (so both commands run in...

good humor ... and Salute to Grant for his contribution to sql community...!!

excellent question...

But sparse column is not a data type its a property on a column, it was very hard to think that way, got the answer wrong but it was...

Nice and easy question.

Nice to start week...!!!

sipas (8/26/2016)

sknox (8/25/2016)

MOST of the time you'll get two rows as explained in the answer.

HOWEVER, each GETDATE() within each SELECT is evaluated separately. When the...

+1 , C# works really well.... no need to upgrade just for JSON..!!