• One simple way would be the following steps:

    1. Run the SELECT query in your SSMS( SELECT * FROM YourTableName )

    2. In the Results tab, you can select all the grid cells together and save the results as a file with csv extension


    Kingston Dhasian

    How to post data/code on a forum to get the best help - Jeff Moden
    http://www.sqlservercentral.com/articles/Best+Practices/61537/