SQL Question
in [Visual Basic]
|
Prev: Project Explrer
Next: VB Editor in Excel
From: Schmidt on 2 Apr 2010 20:40 "David Kaye" <sfdavidkaye2(a)yahoo.com> schrieb im Newsbeitrag news:hp5abt$ood$4(a)news.eternal-september.org... > "Schmidt" <sss(a)online.de> wrote: > > >Did you also tried my second attempt, at the end of my > >previous post, which avoids the First() and Last() stuff? > > My version of Jet (3.6) doesn't seem to like it. > I get a syntax error. Hmm, tested it on XP with ADO 2.8 and DAO 3.6 versions. Maybe you just didn't copy it correctly from the NewsReader (due to all these "forced LineBreaks", perhaps something was "shifted" where it shouldn't)... > Unfortunately, I don't have much time to pick it apart and > see what's failing. Oh, not much time... that's indeed unfortunate... ;-) Olaf
From: Jamal Samedov on 6 Apr 2010 08:04 Do not warry Olaf, I follow both threads, Your query is working properly as well (with some conversions such as mid to substrings and naming of subquery), however in mine filling much longer 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 The problem is not in number subqueries , problem is in string conversions. God database engine cashes subquery and uses prvious result in intelligent manner However it is fun Regards www.coin-masters.com "Schmidt" <sss(a)online.de> wrote in message news:uoLywmf0KHA.752(a)TK2MSFTNGP04.phx.gbl... > > "Schmidt" <sss(a)online.de> schrieb im Newsbeitrag > news:%23m4Y5xd0KHA.3500(a)TK2MSFTNGP02.phx.gbl... > >> This example is using Last(), but First() would also do, if >> one changes the Order By Clause of the following >> SubSelect-Definition (which is basically the same SQL as >> David has mentioned in its Opener-Posting). >> >> strSubSelect = "Select Count(*) As GCount, Genre, Artist From Songs " & _ >> "Group By Genre, Artist Order By GCount, Genre Desc" >> >> Ok what now remains is the construction of the final >> (SubSelect-wrapping) Statement, which does look pretty >> simple due to the usage of the Last() aggregate-functions: >> >> strSQL = "Select Last(GCount), Last(Genre), Artist From (" & _ >> SubSelect & _ >> ") Group By Artist" > > Ok, before you guys "go nuts" (just tested with an *.mdb here) ... > the approach *is* possible with JET, but only if the above > SubSelect is transferred beforehand (per Select Into ...) > into a temporary (but nonetheless physical) Table. > Only then does JET use the correctly ordered Records > from within the Last() or First() aggregates. > > A dynamic interpretation of the SubSelect, given as > "mere string" (as in the above example) does not work > correctly in conjunction with these aggregates, no matter > how the SubSelect was ordered beforehand - so in this > "dynamic case" Last() and First() do *not* respect the > incoming sort-order of the records within the dynamic > SubSelect; instead the physical representation - > or better: the physical Insertion-Order within > the underlying table (in this case the table [Songs]) > for Feeding these aggregates within the context of > an "artist-grouping" is used. > > And that (working with a temp-table, to make the above > approach behave correctly) is probably not what David > had in mind. > > Sorry for the confusion - seems this restriction to the > Insertion-Order of records in physical tables, brings the > usability of the First() and Last() aggregates in JET-SQL > to near zero. > > But maybe this here can work in Davids special case > with a somewhat better performance (I have to come up > with something as short as the above now, do I? <g>): > > 'now all in one SQL-String (correct sorting is indirectly performed too) > > SQL = "Select 99999-Left(Min(GInfo),5) As GenreCount," & _ > "Mid(Min(GInfo),6) As Genre," & _ > "Artist " & _ > "From (" & _ > "Select 99999-Count(Genre) & Genre As GInfo," & _ > "Artist From Songs Group By Artist,Genre" & _ > ") Group By Artist" > > Ok, looks a bit "weird" - place it in the "fun-category" ... ;-) > > But as said, should work though - @David... would > be interested in the performance-results (should run > pretty well, even with all the String- and Math-Ops > involved). > > Olaf > >
From: Schmidt on 6 Apr 2010 12:29 "Jamal Samedov" <jsamedov(a)iface.nl> schrieb im Newsbeitrag news:erVJLFY1KHA.4560(a)TK2MSFTNGP02.phx.gbl... > Do not warry Olaf, I follow both threads, > Your query is working properly as well (with some > conversions such as mid to substrings and naming of > subquery), however in mine filling much longer Thanks for testing. > 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 > > > The problem is not in number subqueries , problem is in > string conversions. I'm aware of the trade-off due to the String-Ops - but was hoping, that on JET (which does not have such an advanced (Sub-)Query-optimizer as MS-SQLServer), that it would pay off somehow. At least for SQL-Server we now know, that it is slower this way. > God database engine cashes subquery and uses prvious result > in intelligent manner. Yep - it also depends on well placed indexes etc., how the SubQueries perform in such "larger, nested Sets". > However it is fun :-) That's often the case, whilst trying to find "impossible" SQL-expressions (seems a kind of "sport" ;-) - although it would often be easier (and faster) to split a certain task into different queries - and combine the results later on in the Application. That said, seems we are all yet "healthy enough", if you take a look at *this* stuff...: <g> http://code.openark.org/blog/mysql/sql-pie-chart Olaf
From: Mike Williams on 6 Apr 2010 13:24 "Schmidt" <sss(a)online.de> wrote in message news:%23NbPcaa1KHA.5972(a)TK2MSFTNGP06.phx.gbl... > take a look at *this* stuff...: <g> > http://code.openark.org/blog/mysql/sql-pie-chart Here's a nice example of Ascii Art. You need to size your window so it does not wrap. Sorry about using rich text for this message by the way, but I needed to get Courier New.at the receiving end and I think RichText is the only thing that might give me a chance of that happening (unless of course you've chosen to read all message in plain text) :-( In fact it might be a bit of fun to write some VB code to convert images to Ascii Art, perhaps by first converting to grey scale using a limited number of shades of grey (perhaps eight different shades?) and then "print" each pixel as a character from a group of eight specific characters that have been chosen for their "dark to white" ratio? Sounds like it could be fun. I might have a go at that one day . . perhaps over the weekend if I get drunk enough ;-) Mike $$$$$$$$$$$$$$$$$$o$$o$$o"$$"o$"o" " o $ o"oo$"o$$$o$$o$o$$o$"o$$"$"oo"$$ooo"o $ "oo$$"o"""o$o" o" "$$$$$$$$$$$$$$$$$$$$"$$$$$$o$$$$o$$ $$$$$$$$$$$$$$$$$$$"o$$"$$$"$o" o $"o""o"o$o"o$$" $"o$"$"$o$"$"o"$o"o "o$"oo$$"o"o"o"o$o""o"oo"$ " "$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$ $$$$$$$$$$$$$$$$$$$$$$$"$o"$o"o" o"o$""o" oo"ooo$$o$$o$$$o"$$o$$$o"$ $$o$$$o"o$o"o"o"oo""o ooo" "o o ""$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$ $$$$$$$$$$$$$$$$$$$"o$$$$"$o" o""o" o"o"$"o"$o"$o"$"$"$o$$$$$$$"o$"o$$$$$$"$$o" $o$"oo"o$ o o""o " " $$$$$$$$$$$$$$$$o$$$$$$$$$$$$$ $$$$$$$$$$$$$$$$$$$$$$o$""o $" "o "o"o"o$"o"o$$o$$$$$$$$$$$$$$$$$$$$$"$"o$$"o$$$"o"o"o"o $ $ o "o " ""$$$$$$$$$$$$$$$$$$$$"$o$o$o o$$$$$$$$$$$$$$$$$$$o"$ $" " $ "o"o$"o$o$$$$$o$$$"$$$$$"$$$o$$$$$$$"$$o$$$$$"o$$$"o""o"o"o" "o " "o " o "o$$$$$$$$$$$$$$"$o$$$$$$$$$ $$$$$$$$$$$$$$$$$$$o$$"o "o"oo"o"$o"$"o$"$o$$""$"$o$o$$$o"$"$$"o$o$$$"$"o$$"$"oo$"$$"o"o$o"$ oo" o "o o"$""$$$$$$$$$$o$$$$$$$$$$ $$$$$$$$$$$$$$$$$$$$o"" o"o"o$"$"o$$"$$""o"o$"$o$$$$$"$$o$$"$$$$o$"o$$$"$o$$$$"o$$o"$$$$o$"o$o"o"o o ""$ "$$$$$$$$$$$$$$"o"o$$ "$$$$$$$$$$$$$$$$$$o$"o"o"o"o$"o$o$$"o$" o"o$$$$$$$$$$$o$$$$$$$o$$"o$"o$o"o"$""o$$$$o$o"$o$"o$" " o" " $ $$$$$$$$$$$$$$"o"o"o $$$$$$$$$$$$$$$$$"o"o"o"o$o"oo$"o$" $ o$"o"$$o$$$$$$$o"$o"o"$o$$"$"o$"o $"$$o$$"oo"o"$"$""$"oo$"o"$ $ " ""$$$$$$$$$$$$o"o$"$o $$$$$$$$$$$$$$$$"o$"o $"oo"o $"$"o""o"o"o$$"o$$$$$"$o"$$ "o"o"o$"$"o$"o$ o " $$$$$$$$$$"$$$$"$"$"$ $o" "$$$$$ "$"o"o$"o$"o$ $$$$$$$$$$$$$"oo"$o"o"o$" o$"o$ o $ o" $o"$$"o$o$"$o"" o" " "o"oo$ $"o"oo o""o$$$"$o$o$"$"o"o"o " o$$ $"$o$"$o$$"o$o" $$$$$$$$$$$"$o$"$o" o$"o" o""o "o" oo"o$"$o$"$o"$" o" " " " " o o"o""" o$ o"o "o""$ $"o$o"o$$"o"o o " o "$"o$o"$$$o$"$o$"$ $$$$$$$$$$$"o$"$o""o"o$ ""o$" " "o o$o""o$$"o$"o o " " o " " "o"o"$o"o"oo"oo"o$oo"$ "o"o"o" o o$ o "o$o$"$$o$$$$$$o$" $$$$$$$$"o$o$o$"$ "o$$ $ $o" "o"oo"o"o"$o"o"o " " " " "o$"$"oo"oo"o o o"o"o"o$"$"$o $ " "oo$"o"$o$$o$$"$ $$$$$$o"$$o$$"$"o" $oo"o"o$ "o o o"oo"o$$"o"o " o " " o"o"$ $"$$o$"$$oo"o$o"o$"o"o"o"" o "o$o"$"$o$$$$$"$o $$$$$$$"o$o$"$$"o"$o$o"$"o"o" " "o"o" o"o"o o" o ""o$$"o$$$$o$$$$"o$$$$"o"o"o$$"oo " $"o"$o$o$"$$$" $$$$$$$$$$"$$"$ o$$"o$o"$$" "o"o$ $o"o"$o" o o" " o " o " "$$"$o$$$$o$$$$$"o$"o"o"o" $" o "o""$o"$"o$$$"$ $$$$$$"o$$$o$$ $ $$$$o$$o$"o"o"oo"o$" o"o$ o o " o "o"$"$$$"$$$o$o$$o$"$"o$""$ o" o"o""$o$"o$"$$ $$$$$"$$o$o$$"o"$$$o$o$o$"o"o"$ $"o"o" o"o" o o " "o"$o$$$$$$o$$$"$$$$o"o$o$""o " ""o$o$"$o$$"$ $$$$$$o"$o$$"$"$$o$$$o$$$"$"$"o"o$"oo" o"o"o o " o " " " " " o " "o$o$$$"$$$$$$o$oo"$oooo$$o"$o"o "oo"o"o$o"o$" $$$$$o$$"$"$"o$$$"$"$o$o$$"$o$$$"o"oo" o"o" o" " o o " o o "o$$$$$$$$$$$"$$$"$"$ $"$"o$o" "o$"o$"o$$"o$ $$$$o$"$"o$o$$$"$$$$"$o"$o"$o"o$$"$ o" o o" o " " " o " " o " " ""$$$$$$$$$$$o$o$o$o"ooo" o"o" "o"o$"o$"$o$ $$$$$"$"$$"$$"$$$$$o$$$$$"$$o"o"$$"$ o" o " o " o " o" o o o$ oo" " o " " "o$$$$$$$$$$$"$$$"$$o$$"$o$ ""o"$"o$$$o" $$$$"$$"o$$"$$o$$$$$$o$$o$o" $$"o$o$ "o " o "o o" o" o " o" oo"o$ "o "o" o" o " o o""$$$$$$$$$$$o$"$o$$o"$o"o"o "$"o$$"o$$" $$$o$$$$o$"$$$$$$$$$$$o$$ o$"$o"$$o"o$ o" o o " o o" o$"o$$o$"oo" o "o "o " o o "$$"$$$$$$$$$$$$ $ $"$o""$" o o"o$o"$o$$ $$$"$$$$o$$o$o$$$$$o$$o$ $""o"$$o"$o"o"o" o o " o o $"$o$$$o"o$$o$$$oo" oo" o" " o" o " $$"$$$$$$$$$o$$$"o"o""o "oo" o"o"$o$$$ o$$$$o$"o$"$$$$$$$$$$$$o""o"$"$$o$$$"$o"o"oo o " o o"o$"o$o$$$$$$$$$"$$$$$$"$oo""o o " o" o"$"$$"$$$$$$$o$$o"o""o"o o""$o"o$" $$$o$$"$$"$$$"$$$o$$$$$ o$"$$$$o$o$$$$o"oo"o " " "o"o$$"$$$$$$$o$"$$$$$$$$o$"o" o " o "o o"$$$$$$$$$$$$$$$o" o"o" o ""o$"o$$ $$o$"o$o$"$o$$"$$$$$$$$o o$$$$$$$$$$$$$$$$oo" " " $"o$o$$$$"""o$$o$$""$$o"" " " o "o o" "o$$$$$$$$$$$$"$$$oo" "oo ""o$$"o$ $$o"$o"o$"o$$$$$"$$$$$$o"o$$$$$$"$""$$$$$$$o o "o""o$"o$"$ "$$$$$o $o$ " " o o" o"o$"$$$$$$$$$$$$"$$oo" o "o"o""o$ $o"$"o$"o$"o$$"$$$$$$$$o ""$$$ "$$$$$$$"$"$$ " " ""o" $ o o$o"o$"o " " o o "o o"$$$$$$$$$$$$"o$$o" o ""$"$"o$ $$"o$$$"o$$"o$$$$$$$$$$$ " o"$o $"$$o"$"$$ o" ""$"o"" o " o " o"o o "$$$$$$$$$$$$$$o"o " "o$""o$ $$"o$o"$o"o$$$$$$$$$$$$oo ""$""$ $"" o " " " " " "" o " o"o"oo" o "$$"$$$$o$$"$$$"$ o " """$"o" $$"$o$$o$$"$$$$$$$$$$$$o o o"o"" "" o " " " o o o" oo"oo" o"o""$$$$$$$"$$"o$"oo " o" " "$ $ $o$$"o$o"$$$$$$$$$$$$$$o " o " o o "o o" o"$ "o"$$o$$$$$$o$$$$$"o$"o "o " " "o"o o$"$$o"o$$o$$$$$$o$"$$"o o o o " o " "o "o $" $ "o $o""$$$$o$"$$o$$$"o$ $ "o o " $o $$$$"$"o$o$$$$$$$$$$"$$o" o o " o "o o" o"o"oo" o $$$o$$$$o$$$"$$$o"$o $o" "o" " " $ $"o$$o"$o"$o$$$$$$$$$$$$ o o " o " o " o "o "o" o"o" o" "$$$$$$$o$$"o$$o$$"o$"$o "o$ " " "o$$ o$"o$"o""$o$"$$$$$$$o$$$oo o o o" " o o " " " o " o" o""o"o""o "o"$$$$$$"$$"$o$$"$""o"$o" o"o" $$ $$$o"$o""o$"$$o$$$$o$$$$$ " o o" o o o o " " o o " o $ "o $ $" o " $$$$$$$$"o$"$"""o"$"$o" o$" o "$ $$$o$ "$o"o"o$$$o$$$$$"$$$o" " o o "o "oo"o "o "o oo$$$$o" o " o" o " "o o"o" o"o" " o" "o"$$$$o"$" o"o"o$"$o$"o"$ o " " $ $$o$$o"oo"o$o"$"$o$$$$$$$$$ " " o o" o"o$ $$"oo" o$"$"o$"" " o"o" o" o"o" o"o" " o" " o" o$$$$$" o"o" o"oo$"o" o$ o o" $" $$$o"o$ o"oo""o$$$$$$$$$$$$$"o" o" $"o"oo" "o$$"$o"o o " o " $"oo" o o""o"o" o" " "o "o"$$"oo""o" "o$"o"o"o$" o"o " " " $$"$o$"$o "o" o"$$$o$$$$$$$$$o"oo$"o"o"o " o""$o$$ o " o o""o$"o" o" "o " " o "o"$$$"o" "o""oo""o o"o" o"o"o o o $" $"$o$ $$"ooo"$ "o$$$$$$$$$$$$$"o $"o"o" o o o" " o"o" " " o"oo"o$ o o " " o" " $"o$o" "oo"$ $ "o"o" o"o"$o" " o $ "$o$$"o$$"o$ $"oo$$$$$$$$$$$$$$ $ $"o$"o o " o " " " oooo"o$ o" " " "o"o$$"o " $o"o$" o"o$"o$"o$$"$" " o o o"o $$"oo$o"o$$"$o$"o$"$$$$$$$$$$$$ o" " $"$"ooo$o$$o oo$$$o$$$$$$$$$$$"$" o o " o " o" o $$o"o "o$o$"o $"o$$"$"o$$o$$o" " "o " "$ "o$"o$"$"o$$$$"$o$"$$$$$$$$$$$$$o"o"o "o """"$o$$$$o$"o$$o$$"o" o " " o" o o"o$$o$"o$o"o$"oo"o$$$"$$$"o$"o$ " "o o " o"$ $ $"o"o"$"o$$$$$"$$"$$$$$$$$$$$$o$ "o"o " "o""""o"$""""o"o oo"o o " o" " " o "o"o$$"o$o"$"$ $o"o$$o$$$$$"o"$"o"o" oo" o " "o o"o"o"o"o$$"o$$"$$$"$$$$$$$$$$$$$o"oo" " o o"$o"o" ooo$o$o$ o o o o" " "o o"o$$$$$o"o$$$ $o$"o$"$$o$$$"o$"$ o"o"oo" o o"o o"o"o$$$"$$$"$$"$$$$$$$o$$$$$$$oo$"o o "o"$$$$"$"o$" "o " o o" " oo"o$$$$$o$"o$o$$"o$"$$"o$$$o$o """o $ $oo"o" o" $ "o"$o$"$$"$$$$"$$$$$$$$$$$$$$$$oo" " "o"$"$"$" $ o " " o" "o"o"o$$$$$$$"o$$$o"$"o$$$o"o$"o$$o" "o $"o" o o o "$"o"$o$$"o$$o$$$"$$$$"$$$$$$$$$$$$$$$$o" o " o"o$ $ $" " " o o o""o""o$$$$$$$$$$o$"o$$"$o$$"$"o"$"o$$ "o " o"$"oo o "o$$"o$o"$o$"$$$"$$o$$$$$$$$$$$$$$$$$$$$$o " " o " o" "o$$$$$$$$$$$$$o"$o$$"o$$$$"$o"$o"o$" o "o"o" " o$o"$"o$"o$$$$$$$"o$$$$$$$"$$$$$$$$$$$$$$$o " o o " o" o"$o$$$$$$$$$$$$$$$o"o$$"$"$$$$o"o$o"o o "o " o " " " "o$$$"o$$o$$$o$$"$"$$$$$$$$$$$$$$$$$$$$$$$$oo " o o o o o "oo"o"o$o$$$$$$$$$$$$$$$$$o$"o$"$$$"$o$$o "oo" o"o"o " " o " "$o$o$$o$$$"$$"o$$$$$"$$o$$$$$$$$$$$$$$$$$$$$o" o o o o " oo"o"o$o$"$$$"$o$$$$$$$$$$$$$$o" $"o$$$"$o$o" o"o o""$"$oo "o" " " $$$o"o$$$"$$" $"$$$$$$$o$$$$$$$$$$$$$$$$$$$$$$$o"o""oo$"oo$o"$"$$"$$$$"$$"$$$$$"$$"$$$$$$$$$$$$$"$ o $"$$"$o$$"o"o" o$ $ o"o""$ " "$o$$"$$"$o"o$$$$$$$$$o$$$$$$$$$$$$$$$$$$$$$$$$$$o$$o$$$o$"$$$$"$$"o$$$$"$$o$$"$$$$$$$$$$$$$$$"$$$"o o""$"$$"$$o"o$ o"oo" oo" " o $o"$$$o"$o"$$o$$$$$o"$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$"o$$$$$$o$$"$$$o$"$$"$o$"$$$o$$$$$$$$$$$$$o$$$$ $o" $"$$$$"$o""oo " o " ""o" o o$$$"o$"o$$o$$$"$o$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$"o$$$$$"$$$$o$$$$o$$$"$$$$$$$$$$$$$$$o$$"$$$$$$o"$o o""o$$o"o"oo" "o"o"o o"o"o "o$"$"o$ $"$o$$$o$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$"o$"$$$$o$"$o$o$$o$"$$$$$$$$$$$$$$$$$$$"$$$$$$$ o"$ o ""$"o$$"$o"o oo"o"o"o$ $o "$o"o"o$"o$$"o$o$$o$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$o"$o$"$$$$$$o$o$"$$$$"$$$$$$$$$$$$o$$"$$"$$$$$$ $"o" $$o"$$$$"o$o"o"o$$" $ o" "o"$"o"o$"$$"$o$"o$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$"$o"$$$"o$$$"$$$$$$$$$$$$$$$$"$$$$o"$$"$$$o$$$$$o"$o" o o$$$$$"$$"o$"$"o$ $"o" o "o"o"o$"$"o$"o$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$"$"o$$"$$$$$$$$$$$$$$$$$$$$$ $$$$"$o"$"$$$$$"$o"$$$$"o"o$$$"$o$$"$"o" o"o" "oo $"o"" o"o$$"$"o$$o$$o$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$"$"o$$$"$$$o$$$$$$$$$$$$$$$$ "$$$o$"$o""$$$$"$$"$$"$"$"o"$$"o""o"$o$"o" o"$ $ ""o$"$ $oo"$o$$"o$$o$$$$$$$$$$$o$$$$$$$$$$$$$$$$$$$$$$$$$$$$"$$o$"$o$$$$$$$$$$$$$$$$$$$$ $$$"o$$$o$""$"$""o"o$"oo$"$o"oo$$"$o$$$o$"o"o"o "$ o"o"o$o"o$"o$$o$$"$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$o$"o$$"o$$$$$$$$$$$$$$$$$$$o"$$$"$o"oo$ o"o" $$"o"o"o$$"$$$o$$$$o$o"o"o$"" " $ "o"o"o$"o$$"o$o$$$$$$$$$$$$$$$o$$$$$$$$$$$$$$$$"$$$$$$$$$$o$o$"$o"$$$$$$$$$$$$$$$$$$$$$o$"o$$o$o$"o"o"o"$o$$"$o$$$"o$$o$o"o"o"o" ""o "o"o$""$ $"o"o$"o$o"$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$"$$$$$$$$$o""o"$$$$$$$$$$$"$$$"$$$$"o$"$o$"o$o"$o$$"o$$$$"$$"o$$$$$$"o$"o"o"o$ $ " " o"o"$"o$o$"$o"$o"o$""$$$$$$$$$$$"$$$$$$$$$$$$$$$$$$oo$$$$$$$$$$$"o$$$o"$o$o"o$$o"$$"o$o$$o$"$$"o"$$"o$$"$o"o$$"o$$$$$"o$"oo$o"o"o "o"o "o"o"$"oo$"$o"$o$"o$""o$$$$$$$$$"$"$$$$$$$$o$$$$$$$$$$$$$$$$$$$$$$$$$$$$$"o$$$o$$"o$$$o"o$$$$o"$$$"$$"o$$o$$$o"$$$$$$$$"o$"o"o"o$" $ $ $ o"o$o$"o$$o"$o$o$$o"$"o"$"o$$"$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$o$$$$$$"$$"$"o$$o$o"$o"$o$"$$$"$$$"$o"o$o"$$$"$$o$$"o""oo$ $o""oo$ $ o"o"o$"o$$o$$$o"o$o"$$o$$"o$o"$$"o$$$o$$$$o$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$"$"o$$"$$"$$"$$o$$$o$$"o$$$o"$o$$"o$$$"o$$$"o"o"$"o$ $o"o"oo"$ $"o"o"$$o"$o$$$"$o$$o$"oo$o$"$o$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$"o$$$$$$$$"o$$o$$"$$$o$"o$$"o$$$o$"$$$$"$""o$o"o"$ $"o"o$"o" o$"$$"$o$$o$"$$$$$$o$$$"$o$$$o"$o"$"$$"$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$o$$"$$o$$$o$$$$"o$$o$$"$$o$"$o$"$o$o$o$$$"$"o"$ o"o$"o"o"$"oo"o$
From: Schmidt on 6 Apr 2010 21:36
"Mike Williams" <Mike(a)WhiskyAndCoke.com> schrieb im Newsbeitrag news:OMidW4a1KHA.264(a)TK2MSFTNGP04.phx.gbl... "Schmidt" <sss(a)online.de> wrote in message news:%23NbPcaa1KHA.5972(a)TK2MSFTNGP06.phx.gbl... > > > > take a look at *this* stuff...: <g> > > http://code.openark.org/blog/mysql/sql-pie-chart > > Here's a nice example of Ascii Art... Yep, a nice one - but writing something, which converts to Ascii-Art from a "Pixel-Source" in a "normal programming language" was probably "too boring a task" for the guy in question. Since in the link above, the Ascii-Images are created by "plain SQL-Queries" - and that in a dynamic fashion against a real DataBase, to render "percentage-relations as pie-charts" - ending up with a Record- or Resultset as the "Image-RawData- Container", targetting e.g. a plain DataGrid then as the final "visualizing Canvas" for the Output of this "Reporting-engine". LOL Olaf |