BCP using T-sql

exec master..xp_cmdshell 'bcp SupportWarehouse.dbo.AgentDataPointAudit out c:\AgentDataPointAudit.txt -c -t, -T -S AMBIVM'

declare @s nvarchar(2000)

set @s='bcp "select top 10 * from SupportWarehouse.dbo.AgentDataPointAudit" queryout c:\AgentDataPointAudit.txt -c -t, -T -S '+ @@servername

exec master..xp_cmdshell @s