Many thanks to you for giving me this url !

Never heard of this lead/lag before (never searched for such a function 😉 )

The other ones are right...

What is that what you wanna know from the forum?

from that what i've read actually... no, there is no better way just

... oder by TransID ASC

corresponding...

Sounds for me like some one is coming from oracle...

Sorry have to explain...

I often have the problem with wording if i speak to a solution architect who is more comfortable...

This might help you:

https://msdn.microsoft.com/library/bb500156.aspx

The following query includes columns of xml type. The query retrieves product model ID, name, and manufacturing steps at the first location from the Instructions...

First, I'm assuming that you actually use the right CU3 to SP2.

Then please allow me to ask : Have to performed ALL the steps given in KnowledgeBase article?

Setup.exe /Action=Uninstall /FEATURES=SQL,AS,RS,IS,Tools /INSTANCENAME=MSSQLSERVER

You can read more about it here:

https://technet.microsoft.com/en-us/library/ms144259.aspx#Uninstall

If the OP just wants to sort...

Hi,

i understand all your replies and reasons not to use this script on a regular base.

But if you know what you're doing in a case of an "incident" then this...