OPEN group_list FETCH NEXT FROM group_list into @AreaGroupRef WHILE (@@FETCH_STATUS <> -1) BEGIN set @filename = 'c:\AG_Export\'+@AreaGroupRef+'.csv' set @sql='bcp "SELECT * FROM integra_test.dbo.new_member_list where GrName = ''+@AreaGroupRef+''" queryout "'+@filename+'" -c -q -t , -T' EXEC master..xp_cmdshell @sql FETCH NEXT FROM group_list into @AreaGroupRef END