Just came back from vacation. My apologies for late response.
If it's not too late yet, here is a part of code I used:


for i in `cat map| awk 'BEGIN { FS = " " }; { print $2}'`
do
isql -S*** -U*** -P*** -w 900 >> /tmp/tmp.out << EOF
use db1
go
select "$i", count(*)
from table1 tb1
join table2 tb2 on tb2.id2 = tb1.id1
join table3 tb3 on tb3.id3 = tb2.orderid
where tb1.number <> 0
and tb3.name = "$i"
go
EOF
cat /tmp/inv-tmp.out|grep "$i">>/tmp/file.out
done

After I chage the bold line to "for i in `cat map| awk '{print $2}'`" , with awk 'BEGIN...' part removed, it started to go through.

Thanks!