CODEWITHSUNDEEP
sql-servercastingsumopenquery
user3637265
user3637265

Reputation: 13

SQL Server OPENQUERY error

I'm using OPENQUERY on SQL Server 2008, I have this query:

SELECT * 
FROM OPENQUERY(MyLinkedServer, 'SELECT familyCode, sum(member) FROM customers')

I get this error:

Column familyCode or expression in SELECT list not valid

When I run the code without SUM, it works perfectly:

SELECT * 
FROM OPENQUERY(MyLinkedServer, 'SELECT familyCode, member FROM customers')

What's the correct syntax for including the SUM function?

Thank you!

Upvotes: 1

Views: 1385

Answers (1)

Raphaël Althaus
Raphaël Althaus

Reputation: 60493

you need a group by clause when using an aggregation function like SUM

SELECT familyCode, sum(member) FROM customers group by familyCode

Upvotes: 1

Related Questions