We cannot share same solution..this site for sharing our knowledge and experience to find best and alternate solution to reach OP's expectations.I always try to understand others i hope u too :-)

1.If your looking random records from the table every time then use "order by NEWID()" with top clause. EX:- SELECT TOP(10) * FROM TABLE ORDER BY NEWID(); 2.Alternate records is identified with Identity column AND ROW_NUMBER() Rank function in advance Rank function has choice to sorting based on columns under "CTE" and derived table.

Writing article means brief documentation(MS word presentation) of one choosing concept right? Please help me.

Really this points are helpful.Thanks for giving suggestions :) .

i will read and let you know if i struck.Thank you so much.. :)

Thanks for response, I'm new to writing articles even i don't know where to write and how to get license on it.I choose dynamic pivot concept so Please help me how to start this article.

Hello Developers, i want to write Articles about SQL concepts so excepting unforgettable help from you with sample article documentation. Thanks in-advance.