Posted by Ted on 08/21/06 18:35

--CELKO-- wrote:
> >> My code can continue on, but I want to understand why the statement I constructed by following the example in my book was rejected. Did I miss something? Or is there an error in the book? Or is there a bug in SQL Server 2005? <<
>
> This is just how God punishes people for using proprietary code :)
> Since this is MS-only
> syntax, they can do anything they wish from release to release. Ergo,
> you are screwed and live at their whim without recourse to a
> higherauthority.
>
> Drop an email to the publisher, so they can fix it in the book and use
> the Standard. MAX() syntax you provided. Since it is Standard SQL, MS
> has to keep it the same from release to release.

I think I feel a headache coming on!

The publisher is Microsoft Press. It is for SQL Server 2005 and I AM
RUNNING SQL Server 2005! You'd think they'd run sample code from their
own book against their own SQL Server.

Cheers,

Ted

Someone pass me the super strength Motrin! :-(

[Back to original message]