bcp a resultset of query in fixed width txt file

• gaara_nitk

  SSC Enthusiast

  Points: 106

  More actions

  June 3, 2009 at 3:28 am

  #95655

  Hi,

  I need to do a bcp out for a query. But I am not able to get a fixed width txt file as the output.

  what are the various parameters to be set in the bcp?

• sholliday

  SSCrazy

  Points: 2100

  More actions

  December 16, 2009 at 9:21 am

  #1093119

  Here is a "trick"

  casting as a char(XX) where XX is your fixed-width

  bcp "SELECT cast(LastName as char(50)) , cast(FirstName as char(50)) , cast(MiddleName as char(50)) , cast(Suffix as char(50)) FROM AdventureWorks2008.Person.Person ORDER BY LastName, Firstname" queryout PeopleAreCool.txt -c -T -SMySqlServer\MyInstanceName

  Note, that is a 2008 AdventureWorks db from code plex. Your AW db might need a slight sql-select update. But the skeleton is there.

  ..