Re: SQL Help

ADSM-L

[Top] [All Lists]

Re: SQL Help

2001-02-05 00:24:41

Subject:	Re: SQL Help
From:	Suad Musovich <suad AT CCU1.AUCKLAND.AC DOT NZ>
Date:	Mon, 5 Feb 2001 18:13:28 +1300

> UPDATE SCRIPT Q_NODE_OCCUPANCY4 '  (select distinct count(volume_name) from 
> volumeusage where occupancy.node_name = volumeusage.node_name) as 
> NUMBER_OF_TAPES -'

Haven't figured it out yet, but your sub-query is incorrect.

You want;
    select count(distinct volume_name) from ....

Cheers, Suad
--
=========================================================================

[More with this subject...]

<Prev in Thread]	Current Thread	[Next in Thread>
SQL Help, Andrew Webster Re: SQL Help, Suad Musovich <=

Previous by Date:	SQL Help, Andrew Webster
Next by Date:	Re: Fresh implementation of TSM, Alyn Bush
Previous by Thread:	SQL Help, Andrew Webster
Next by Thread:	Re: Fresh implementation of TSM, Alyn Bush
Indexes:	[Date] [Thread] [Top] [All Lists]