Does this provide the results you are looking for?

SELECT a.UserID, a.SubjectDescript,

ClosedSevenDaysTot = (SELECT COUNT(b.userID) FROM vwComplaintDetails b WHERE b.userID = a.UserID AND DATEDIFF(DAY, b.ClosedDateTime, b.OpenedDateTime) = 4 THEN 11 ELSE...

Have you tried the -F flag to indicate the number of rows to copy into your table?

Duncan

If you wanted all records for, say, Oct 2003 to Jan 2004, I would use:

select * from tablename (index = date1)

where date >= 'Oct 1 2003'

and date < 'Feb 1...

Thank you both for your assistance. I have now got the process working with the -n switch.

I think part of the problem was that I was also trying to call...

Are you getting a consistent response for each territory? By this I mean when you select territory A you always get 4 new records added but territory B never adds...