Even i tried with this below one ...i getting below error output

declare @sql varchar(8000)

SELECT @sql = ‘bcp “select * from MM_DEV_T_D2_P..app_case” queryout E:\files\files\1.txt -c -t’+’”|”‘+’ -T -S @@servername’

exec master..xp_cmdshell @sql

—–err...

i too tried with queryout but it throws the same error,can you please help on this...

select empid from tablename where flag='yes' and processingdate='old date'