Thank this author by sharing:
By vikram kharbanda,
1.)Rght Click on the database that contains the your original table.
2.) Open new Query Window
3.)Paste this into query
5.)Replace the YourDATBSE with your own databse
6.)Replace the MYTableNAME with your own tabl name
As a member of SQLServerCentral, you get free access to loads of fresh content: thousands
of articles and SQL scripts, a library of free eBooks, a weekly database news roundup,
a great Q & A platform… And it’s our huge, buzzing community of SQL Server Professionals
that makes it such a success.