SELECT * FROM Product COMPUTE MAX(Qty)
Error is :
Msg 156, Level 15, State 1, Line 1
Incorrect syntax near the keyword 'COMPUTE'.
Loading
Know the answer? Post it — somebody with the same question will find it here.
Sign in to answer this question
It is the same account you read, post and publish with — and you will come straight back to this page.
Nanhe SiddiquePosted May 7, 2015, 6:46 AM
compute feature will be removed in the next version of Microsoft SQL Server. Do not use this feature in new development work, and modify applications that currently use this feature as soon as possible
Upendra Pratap ShahiPosted May 7, 2015, 4:59 AM
Rajeesh MenothPosted May 7, 2015, 4:56 AM
I think your syntax is wrong..
Ref : https://technet.microsoft.com/en-us/library/ms181708(v=sql.105).aspx
Upendra Pratap ShahiPosted May 7, 2015, 4:45 AM
compute max quntity
Manish Kumar ChoudharyPosted May 7, 2015, 3:56 AM