JerryKlmns
IS-IT--Management
I 'm trying to execute this sql statement
SELECT 'CIASF' As TableName,
ASF_DATE As DateIn,
Count(*) As Counted
FROM dbo.CIASF
GROUP BY 'CIASF',
ASF_DATE
ORDER BY 2;
using an SQL Pass-Through query from MS-Access. Although for an MSAccess table that would be succesful, I get:
Each GROUP BY expression must contain at least one column reference (#329)
for SQL Server 2005
CIASF is not a field just a column I need to be shown with that value