Re: Stored Procedure SELECT

Article View: dk.edb.database

Article #15191

#15191

From: Jonas Delfs
Date: Sat, 07 Jul 2001 14:17

19 lines
1730 bytes

"Ren� Rolighed Christensen" <rolighed@nospam-freestyler.dk> skrev i en
meddelelse news:3b448cc3$0$12802$edfadb0f@dspool01.news.tele.dk...

> Hvis jeg eksempelvis har en Select statement der f.eks. ligner denne:
>
>   SELECT id, dato_fra, dato_til FROM tbl_test ORDER BY dato_til DESC
>
> S� f�r jeg sorteret mit recordset efter dato_til med den nyeste dato
f�rst.
> Hvis jeg nu har nogle records hvor dato_til er Null - og gerne vil have
dem
> listet f�r resten af datoerne (som stadig er sorteret desc)? Hvorledes kan
> dette lade sig g�re?

Hvilket format gemmer du dato'en i?

--
Mvh. Jonas Delfs, http://delfs.dk
e72bd3e51a7937c87d28b85d677a97b2

Technical Details

Message-ID: <9i75fp$bnl$1@sunsite.dk>

Path:

arc1-ca.pugleaf.net!archiver1.google.com!newsfeed.google.com!sn-xit-02!supernews.com!news.tele.dk!130.226.1.33!news.net.uni-c.dk!sunsite.dk!not-for-mail

References: <3b448cc3$0$12802$edfadb0f@dspool01.news.tele.dk>

Show Full Headers

Complete Article Headers

X-Google-Language: DANISH,ASCII
X-Google-Thread: fcdf9,2004f50aa895df61
X-Google-Attributes: gidfcdf9,public
X-Google-ArrivalTime: 2001-07-07 07:15:17 PST
Path: arc1-ca.pugleaf.net!archiver1.google.com!newsfeed.google.com!sn-xit-02!supernews.com!news.tele.dk!130.226.1.33!news.net.uni-c.dk!sunsite.dk!not-for-mail
From: "Jonas Delfs" <jonas@nospam.delfs.dk>
Newsgroups: dk.edb.database
Subject: Re: Stored Procedure SELECT
Date: Sat, 7 Jul 2001 16:17:27 +0200
Organization: SunSITE.dk - Supporting Opensource Software
Lines: 21
Sender: jonas@131.165.143.165
Message-ID: <9i75fp$bnl$1@sunsite.dk>
References: <3b448cc3$0$12802$edfadb0f@dspool01.news.tele.dk>
NNTP-Posting-Host: 131.165.143.165
X-Trace: sunsite.dk 994515257 12021 131.165.143.165 (7 Jul 2001 14:14:17 GMT)
X-Complaints-To: news@sunsite.dk
NNTP-Posting-Date: Sat, 7 Jul 2001 14:14:17 +0000 (UTC)
X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4133.2400
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.50.4133.2400
X-Authenticated: jonas@delfs.dk

Reply to Parent Message