Error: SQL Error: Query Failed!\n Detail: SQL: SELECT ModelName as [groupname], count(ModelName) as [count], ModelName as [GroupNameEnglish], modelFamily as [groupparent], ( SELECT DISTINCT  count(modelFamily) as [count] FROM VIEW_ELSAPI_Equipment [e2]    left join equip_attributes ea on [e2].eqid = ea.eqid left join company c on [e2].Control = c.Control left join equip_note en on [e2].eqid = en.eqid WHERE  (  c.MasterControl = 'BALLWEGIMPWI ' AND  [e2].Control in ('920-887-2728','920-324-3537') )  AND ( (select count(EqId) from EQUIP_SALE_SPECIALS ss where ss.EqId = e.EqId) > 0  )   AND [e2].modelFamily=[e].modelFamily GROUP BY modelFamily ) as [groupparent_count]  FROM VIEW_ELSAPI_Equipment [e]    left join equip_attributes ea on [e].eqid = ea.eqid left join company c on [e].Control = c.Control left join equip_note en on [e].eqid = en.eqid WHERE  (  c.MasterControl = 'BALLWEGIMPWI ' AND  [e].Control in ('920-887-2728','920-324-3537') )  AND ( (select count(EqId) from EQUIP_SALE_SPECIALS ss where ss.EqId = e.EqId) > 0  )  GROUP BY ModelName  , modelFamily ORDER BY [groupname];
SQLSTATE: 42000
code: 8120
message: [Microsoft][SQL Server Native Client 10.0][SQL Server]Column 'VIEW_ELSAPI_Equipment.EqID' is invalid in the select list because it is not contained in either an aggregate function or the GROUP BY clause.
Array

Browse All Hotlist Equipment » John Deere dealer in Waupun and Beaver Dam, Wisconsin

Browse All Hotlist Equipment

No equipment found

Would you like more information?

Free Parts Delivery to
Drop Boxes!