Re: failure trying to fetch on unopened cursor

My guess would be to drop distinct when adding count(*) since it becomes redundant. carlos kirt wrote: > select distinct column1, column2, column3, count(*) from table1 where> column5 > 19991010 and column6 in (100, 200, 300, 400,) group by 2,3,1 > > column1 int > column2 varchar > column3 varchar > column5 int > column6 int > > kirtt@mediaone.net -- ------------------------------------------------------------------------------- Carlos Benjamin, Jr. (623) 869 - 2364 Programmer/Analyst/Consultant Currently Assigned to Central Arizona Project mailto:inf999@cap-az.com -------------------------------------------------------------------------------