• below86

    below86

    Why don't you just right click on the table name in SSMS in the object explorer and do 'Script table as' then select 'SELECT to'. This will do the same thing plus format the results.

    Am I missing something?

    Perfectly fine and valid. You are not missing anything out.

    Just wanted a SQL script to do the needful - hence the post.

    Mehernosh.