SELECT AND UPDATE

Question

SELECT AND UPDATE

Viewing 5 posts - 31 through 34 (of 34 total)

You must be logged in to reply to this topic. Login to reply

manojkanoi SSCrazy Points: 2292 More actions · Answer 1

If I try removing the Max I get the following error:

Column 'Orders.OrderDate' is invalid in the HAVING clause because it is not contained in either an aggregate function or the GROUP BY clause.

If I add Orders.OrderDate in the select query I get the same error twice one for slect list and other for having list and if I use Max in the select list I get the above error.

noeld SSC Guru Points: 96590 More actions · Answer 2

manojkanoi, I just posted the answer in a different thread that you started:

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=8&messageid=164127

* Noel

manojkanoi SSCrazy Points: 2292 More actions · Answer 3

Hi Noeld,

when i try using the your query it gives me this error

Server: Msg 156, Level 15, State 1, Line 8

Incorrect syntax near the keyword 'GROUP'.

noeld SSC Guru Points: 96590 More actions · Answer 4

It was just a missing parenthesis, sorry. Look again

* Noel

manojkanoi SSCrazy Points: 2292 More actions · Answer 5

manojkanoi

SSCrazy

Points: 2292

February 25, 2005 at 1:18 pm

#544255

Thanks that fixed the problem.