In one of the SPs I created, creates a staging table and then a file is extracted using BCP Out. Requirement is changed now and they want me to extract different files (not 1 whole file) based on values in a field... Guys, can you please tell me the best way to do this... any sample script would be very helpful.