USE Northwind
GO

SET NOCOUNT ON
CREATE TABLE myTable99(
	  CustLastName	varchar(50)
	, Prefix	varchar(3)
	, StreetNumber	varchar(15)
	, StreetName	varchar(50)
	, City 		varchar(50)
	, State 	varchar(2)
	, PostalCode 	varchar(10))
GO

INSERT INTO myTable99(CustLastName, Prefix, StreetNumber, StreetName, City, State, PostalCode)
SELECT 'Kay',   'Mr.', '213', 'Lincoln Street', 'Newark', 'NJ', '07102-2992' UNION ALL
SELECT 'Smith', 'Mr.', '123', 'Main Street',    'Boston', 'MA', '12345'
GO

CREATE VIEW myView99
AS
SELECT    Prefix + ' ' + CustLastName 	  + CHAR(13) + CHAR(10)
	+ StreetNumber + ' ' + StreetName + CHAR(13) + CHAR(10)
	+ City + ', ' + State + '  ' + PostalCode AS AdressedTo
  FROM myTable99
GO

DECLARE @cmd varchar(8000)
SELECT @cmd = 'bcp Northwind.dbo.myView99 OUT d:\myView99.csv -T -c -S<servername>'
EXEC master..xp_cmdshell @cmd
GO

SET NOCOUNT OFF
DROP VIEW myView99
DROP TABLE myTable99
GO