Forums Home

Thread Tools Display Modes
Old 09-Nov-2011, 12:25 pm   #1
FaultWire's Avatar
Join Date: Mar 2008
Posts: 14,411
Invalid Microsoft SQL Server Management Studio - SQL Execution ...

Dialog text:
SQL Execution Error.

Executed SQL statement: SELECT dbo.Users.userName, DATEADD(dd, 0, DATEDIFF(dd, 0, dbo.Actions.actionCreatedDate)) AS Expr1, dbo.Queries.queryExpression FROM dbo.Users INNER JOIN dbo.Sessions ON dbo.Users.userId = dbo.Sessions.userId INNER JOIN dbo.Actions ON dbo.file
Error Source: .Net SqlClient Data Provider
Error Message: Column 'dbo.Queries.queryExpression' is invalid in the select list because it is not contained in either an aggregate function or the GROUP BY clause.

Issued by: Microsoft SQL Server
Vendor: Microsoft Corporation

Jump to the FaultWire page for Solutions and Fixes for this topic...

FaultWire is offline   Reply With Quote

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

All times are GMT -7. This page opened at 9:59 am.

  Powered by vBulletin® Version 3.8.3
Copyright ©2000 - 2018, Jelsoft Enterprises Ltd.