Posted by Hugo Kornelis on 11/23/05 01:25

On Tue, 22 Nov 2005 20:02:03 GMT, Will Chamberlain wrote:

(snip)
>SELECT Max(COALESCE(Sheet.Ver, 'NONE')) AS MaxOfVer,
>Max(COALESCE(Update.Update, 0)) AS MaxOfUpdate, Sheet.SheetNumber FROM
(snip)

Hi Will,

Following on to Erlands remakrs, I think you should change this part to

SELECT COALESCE(MAX(Sheet.Ver), 'NONE') AS MaxOfVer,
COALESCE(MAX(Update.Update), 0) AS MaxOfUpdate,
Sheet.SheetNumber
FROM ....

That way, the MAX of all values will be used, or NONE / 0 if there were
no values at all in the set.

Best, Hugo
--

(Remove _NO_ and _SPAM_ to get my e-mail address)

• Next in forum: Re: There is a question when i work on Linkedserver~Pls kindly help me:)
• Prev in forum: Re: How to drop one of the tempdb files
• Thread view: Re: SQL Query Help

[Reply to this message]