MVEs are more concerned with the satisfaction of those they help than with the considerable points they can earn. They are the types of people you feel privileged to call colleagues. Join us in honoring this amazing group of Experts.
#!/usr/bin/tcsh # Checking the prameters if ( $# != 2 ) then echo "Invalid Parameter" exit -1 endif set studentId="$1" set fileName="$2" isql -S$SQL_SRVR -D$DB_NAME -U$SYB_LOAD_ID -P$SYB_LOAD_PWD -b -w3000 -n -h0 -o $fileName <<! set nocount on go select rtr.studentId,count (*) from StudentTrackingRequest rtr, Attendence mtp, RollDistribution rd where rtr.clientID = "$1" and rd.clientID = rtr.clientID and mtp.rtvStatusCode = 'VAL' and rd.creationDateTime > 'Sep 7 2011 9:02:29:000AM' and rd.atendenceDate >= '08/31/11' and rd.atendenceDate <= '09/08/11' group by rtr.clientID go ! exit 0