Apr 17, 2012

percentile calculation in t-sql

select max(PERCENT_OUTBOUND_CALLS) from (
SELECT top 20 PERCENT PERCENT_OUTBOUND_CALLS FROM scorecard_outlier ORDER BY PERCENT_OUTBOUND_CALLS asc )a
BCP task using command prompt BCP testDB.dbo.TestTable in D:\testsourcefile.txt BCP testDB.dbo.TestTable out D:\testdestfile.txt