already working properly. You can't collapse rows when they have
different values, and you will need to do your update using each of those
different contentid values.
_____________________
Eric
_____________________
"You can tell the ideals of a nation by its advertisements."
-- Norman Douglas
"Bosky, Dave" <[EMAIL PROTECTED]>
08/20/2004 04:49 PM
Please respond to sql
To: SQL <[EMAIL PROTECTED]>
cc:
Subject: RE: return only one row for each id field that meets the criteria .
I need the content id to perform an update. Is there no way to make it
function with the column?
~Dave
----- Original Message -----
QUERY:
----------------------------------------------
SELECT id, contentid, dateDisplayEnd
FROM dbo.tbl_menu_content
WHERE (dateDisplayEnd > GETDATE())
AND (contentQueueID = 2)
ORDER BY id, dateDisplayEnd
----------------------------------------------
RESULTS:
id contentid dateDisplayEnd
----------------------------------------------
20 100 8/21/2004 12:00:01 AM
20 102 8/21/2004 12:00:01 AM
20 103 8/21/2004 12:00:01 AM
20 104 8/21/2004 12:00:01 AM
20 108 8/21/2004 12:00:01 AM
20 119 8/31/2004 12:00:01 AM
37 106 8/24/2004 12:00:01 AM
----------------------------------------------
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
