Prev: Project Explrer
Next: VB Editor in Excel
From: David Kaye on 11 Apr 2010 04:23
"Jamal Samedov" <jsamedov(a)iface.nl> wrote:

>I have corrected the query for MS SQL as following:
>Select 99999-Left(Min(GInfo),5) As
>GenreCount,substring(Min(GInfo),6,len(Min(GInfo))-6) As Genre1,Artist
>
>From (
>
>Select (convert(varchar,99999-Count(Genre)) + Genre) as GInfo,
>
>Artist From Songs Group By Artist,Genre) as aa
>
>Group By Artist


My version of Jet SQL does not understand the CONVERT keyword.

First  |  Prev  | 
Pages: 1 2 3 4
Prev: Project Explrer
Next: VB Editor in Excel