set @sql='bcp "SELECT * FROM integra_test.dbo.new_member_list where GrName = '''+@AreaGroupRef+'''" queryout "'+@filename+'" -c -q -t , -T'>Hi
>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 >