Comments by Mrkhoza (Top 1 by date)

Hi _Asif_

Our clients need xls or xlsx or xlsb files

DECLARE @cmd VARCHAR(512);
SET @cmd = 'bcp "SELECT * FROM AssetRegister WHERE FinancialAccountingPeriodID = ''4'';" queryout "C:\2014_Jul01_Jul31_AssetRegister201602040830.csv" -c -d VSmart3.Test -t, -S ZAV-TTY-DEV1\SQL2008R2 -T'
Exec xp_cmdshell @cmd