MAX

Question

Post reply

MAX

VM-723206

SSCrazy

Points: 2964
More actions
May 5, 2009 at 12:51 am

#202839

Comments posted to this topic are about the item MAX

Viewing 15 posts - 1 through 15 (of 15 total)

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

Philipp Post Default port Points: 1401 More actions · Answer 1

From a logical point of view the message

"Warning: Null value is eliminated by an aggregate or other SET operation"

is quite good as NULL might mean unknown, not applicable or optional for input. Thus, we can not savely say if the displayed MAX is the correct MAX, if all rows containing NULL were properly filled.

There were long discussions about this in comp.databases.theory

brgds

Philipp Post

brgds

Philipp Post

Raamamohan SSC Eights! Points: 839 More actions · Answer 2

Out Put is : 0

Warning message wasn't showing in any of the versions (2000 and 2005)

webrunner SSC-Dedicated Points: 31720 More actions · Answer 3

Ram Mohan Reddy (5/5/2009)
Out Put is : 0
Warning message wasn't showing in any of the versions (2000 and 2005)

Did you try looking in the Messages tab or setting the results to output to text?

I saw the messages in those places, even though when I ran it in grid view (SQL 2000) I didn't see it.

If you still don't see the message, then I'm stumped, and maybe someone else can weigh in.

- webrunner

-------------------
A SQL query walks into a bar and sees two tables. He walks up to them and asks, "Can I join you?"
Ref.: http://tkyte.blogspot.com/2009/02/sql-joke.html

Raamamohan SSC Eights! Points: 839 More actions · Answer 4

Raamamohan

SSC Eights!

Points: 839

May 5, 2009 at 8:33 am

#988864

Agreed, I didn't saw the message

ppcx Ten Centuries Points: 1359 More actions · Answer 5

I got "0" and the warning in 2005 SP2. The "0" was on the Results tab and the warning was on the Messages tab.

ghollis SSChasing Mays Points: 633 More actions · Answer 6

Hit CTRL + T that then run it again. That will put you in text mode so the result and messages are on one screen. CTRL + D will put them back in the Datagrid format.

Raamamohan SSC Eights! Points: 839 More actions · Answer 7

Raamamohan

SSC Eights!

Points: 839

May 5, 2009 at 9:18 am

#988931

Good

dunnjoe SSCrazy Points: 2180 More actions · Answer 8

ghollis (5/5/2009)
Hit CTRL + T that then run it again. That will put you in text mode so the result and messages are on one screen. CTRL + D will put them back in the Datagrid format.

Thanks for the tip! Much nicer than having two tabs!!

Nugby SSCommitted Points: 1612 More actions · Answer 9

Thanks Gollis, that shortcut may prove useful in future!

brewmanz SSCommitted Points: 1575 More actions · Answer 10

I expected that I'd get the 0 result, but wasn't sure about the message. Anyway, I got

"

(1 row(s) affected)

Warning: Null value is eliminated by an aggregate or other SET operation.

(1 row(s) affected)

"

showing in my Message tab

yhxing SSC Enthusiast Points: 101 More actions · Answer 11

Here are what I got in sql 2005 SP3 showing as Text:

(1 row(s) affected)

-----------

0

Warning: Null value is eliminated by an aggregate or other SET operation.

(1 row(s) affected)

RichB SSCrazy Eights Points: 9651 More actions · Answer 12

surely it depends on your system settings... I rather think I would get a failure: can't insert null into non nullable column... 😛

Christopher Stobbs SSC-Insane Points: 21098 More actions · Answer 13

also depends if you have SET ANSI_WARNINGS ON or not

----------------------------------------------
Try to learn something about everything and everything about something. - Thomas Henry Huxley

:w00t:
Posting Best Practices[/url]
Numbers / Tally Tables[/url]

SQL-4-Life

DBA Cabuloso SSCommitted Points: 1733 More actions · Answer 14

This one was easier than to chew water!

________________
DBA Cabuloso
Lucas Benevides