Article View: dk.edb.database
Article #15346[MS SQL 7] GROUP BY - p� bit-kolonne
From: Jesper Stocholm
Date: Wed, 23 May 2001 13:33
Date: Wed, 23 May 2001 13:33
16 lines
1338 bytes
1338 bytes
Er der nogen mulighed for at lave en GROUP BY p� en bit-kolonne - enten ved en omvej eller ved at konvertere det til fx. smallint ? Jeg har pr�vet med SELECT firstname, lastname, CAST(ignorant as smallint) AS ignorant FROM table GROUP BY firstname, lastname, male men den brokker sig stadig over at der pr�ves at gruppere p� en bit- kolonne. ? -- Jesper Stocholm Systems Analyst Copenhagen, Denmark
Technical Details
Message-ID:
<Xns90AA9E3C31AFDspamstocholmdk@153.80.109.11>Path:
arc1-ca.pugleaf.net!archiver1.google.com!newsfeed.google.com!sn-xit-03!supernews.com!nntp.cs.ubc.ca!news-spur1.maxwell.syr.edu!news.maxwell.syr.edu!newsfeed.cwix.com!pullfeed!rpc1283.DaytonOH.NCR.COMShow Full Headers
Complete Article Headers
X-Google-Language: DANISH,ASCII X-Google-Thread: fcdf9,ffbf9e0f89c9c28f,start X-Google-Attributes: gidfcdf9,public X-Google-ArrivalTime: 2001-05-23 06:34:05 PST Newsgroups: dk.edb.database Subject: [MS SQL 7] GROUP BY - p� bit-kolonne From: spam@stocholm.dk (Jesper Stocholm) Organization: NCR SE-Copenhagen Message-ID: <Xns90AA9E3C31AFDspamstocholmdk@153.80.109.11> User-Agent: Xnews/4.01.30 X-Original-NNTP-Posting-Host: b302.copenhagen.ncr.com Date: 23 May 2001 09:33:22 -0400 X-Original-Trace: 23 May 2001 09:33:22 -0400, b302.copenhagen.ncr.com Lines: 16 NNTP-Posting-Host: ncrnews.daytonoh.ncr.com X-Trace: rpc1283.DaytonOH.NCR.COM 990624805 ncrnews.daytonoh.ncr.com (23 May 2001 09:33:25 -0400) Path: arc1-ca.pugleaf.net!archiver1.google.com!newsfeed.google.com!sn-xit-03!supernews.com!nntp.cs.ubc.ca!news-spur1.maxwell.syr.edu!news.maxwell.syr.edu!newsfeed.cwix.com!pullfeed!rpc1283.DaytonOH.NCR.COM