Thanks for the information. I searched online but could NOT find any authentic source for the behavior of  [Ready-only node/ Connections] on Patching/ when it goes OFFLINE. Is the direction...

Hello Thom,
I totally agree to your comments, I am working with customer having still SQL 2000/ 7 as well, Working hard to migrate them. Meanwhile need to support, Thanks...

Thank you e4d4, very much appreciated of your help & support.

Thanks Jason, T-SQL has gone very far away from me 🙂 Thanks so much for your inputs, Great to know. Very much appreciated of your time sharing the information.

Thanks Saravanatn, Great ideas. Wow. Very much appreciated of your time, Thanks for your help.

Thank you Joe, Awesome, Amazing, Very much appreciated of your expertise. Thanks for your help. You are excellent, Joe.

Hello,

called Microsoft tech support for help, they realized such information is NOT provided directly in the [CREATE ENDPOINT] T-SQL statement documentation, and provided me with a confirmation document saying that...

Thanks for the reply,

Already created the ENDPOINT, and the ENDPOINT script has AES in it, the SQL Server SQL Server 2014.

so for the given AES, need to know the bit...

Hello Hugo,

I wrote a Stored Procedures to read the previous and next values and managed to get the expected result using some programming method. Thanks for your time looking into...

Thanks Hugo for your suggestions, I will try, very much appreciated of your help & support, Many thanks.

Thanks Hugo for your reply, The table design is just a situation in EXCEL document and need to be converted to the expected result. The design is NOT actual database...

Hello Wayne,

Thank you so much for your time & efforts. Very much appreciated. I could never get to this level of complexity.

Very much impressed with your technical ability and patience...

Could someone help me with this query request? Thanks so much for your help.

Hello Livingston, thanks for your reply, the table should look like as below data,

-----------------------------------------------------------------------------------------------------

(1, 'Col1', 1, 'ILove' ...

Hello Wayne,

How to UNPIVOT the same with string Length of 5? I need get back to its original form (UNPIVOT) but with size of 5 characters. Could you help me...