Re: [MS SQL 7] GROUP BY - p� bit-kolonne - Article 15350 - go-pugleaf

Article View: dk.edb.database

Article #15350

Re: [MS SQL 7] GROUP BY - p� bit-kolonne

#15350

From: Jesper Stocholm
Date: Thu, 24 May 2001 18:56

27 lines
1937 bytes

JH <jimmy@dk2net.dk> wrote in <8cingt0o3a6t18n414nmbrsfd5772tnaea@4ax.com>:

>> Er der nogen mulighed for at lave en GROUP BY p� en bit-kolonne
>
>Lidt copy&paste.....
>
>Note: You cannot use GROUP BY or HAVING on ntext, text, image, or bit
>columns unless they are in a function that returns a value having
>another data type, such as SUBSTRING or CAST.
>

ja ... og det var ogs� det jeg pr�vede at komme ud over i min SQL-statement 
med anvendelsen af 

SELECT firstname, lastname, CAST(ignorant as smallint) AS ignorant
FROM table
GROUP BY firstname, lastname, ignorant

, hvor feltet ignorant er en bit-kolonne ... men fors�ges 
konverteret/CAST'et til en smallint .

Er min anvendelse/kombination forkert ?

-- 
Shortest DVD-crack:
<http://www.cs.cmu.edu/~dst/DeCSS/Gallery/hannum-efdtt-source.txt >
  - Jesper Stocholm - http://stocholm.dk

Technical Details

Message-ID: <Xns90ABD4C13D01Fspamstocholmdk@192.38.208.81>

Path:

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

References: <Xns90AA9E3C31AFDspamstocholmdk@153.80.109.11> <8cingt0o3a6t18n414nmbrsfd5772tnaea@4ax.com>

Show Full Headers

Complete Article Headers

X-Google-Language: DANISH,ASCII
X-Google-Thread: fcdf9,ffbf9e0f89c9c28f
X-Google-Attributes: gidfcdf9,public
X-Google-ArrivalTime: 2001-05-24 11:57:33 PST
Path: arc1-ca.pugleaf.net!archiver1.google.com!newsfeed.google.com!sn-xit-02!supernews.com!news.tele.dk!130.225.51.30!sunsite.dk!cyclone.sunsite.dk!news.net.uni-c.dk!newsfeed.k-net.dk!not-for-mail
From: usenet@stocholm.dk (Jesper Stocholm)
Newsgroups: dk.edb.database
Subject: Re: [MS SQL 7] GROUP BY - p� bit-kolonne
Date: Thu, 24 May 2001 18:56:46 +0000 (UTC)
Organization: stocholm.dk
Lines: 27
Message-ID: <Xns90ABD4C13D01Fspamstocholmdk@192.38.208.81>
References: <Xns90AA9E3C31AFDspamstocholmdk@153.80.109.11> <8cingt0o3a6t18n414nmbrsfd5772tnaea@4ax.com>
NNTP-Posting-Host: dummy164.pop.k-net.dk
Mime-Version: 1.0
Content-Type: text/plain; charset="iso-8859-1"
Content-Transfer-Encoding: 8bit
X-Trace: eising.k-net.dk 990730606 9336 192.38.220.233 (24 May 2001 18:56:46 GMT)
X-Complaints-To: drift@k-net.dk
NNTP-Posting-Date: Thu, 24 May 2001 18:56:46 +0000 (UTC)
User-Agent: Xnews/4.01.30

Reply to Parent Message