|
 |
asp_databases thread: getting percentages from table info
Message #1 by dont worry <aspmailbox@y...> on Mon, 10 Dec 2001 19:33:04 -0800 (PST)
|
|
What is the best method of generating query/reports
from data inside a name/value pair table? I need
totals, percentages..etc.
thanks
__________________________________________________
Do You Yahoo!?
Check out Yahoo! Shopping and Yahoo! Auctions for all of
your unique holiday gifts! Buy at http://shopping.yahoo.com
or bid at http://auctions.yahoo.com
Message #2 by "Melinda Savoy" <msavoy@h...> on Tue, 11 Dec 2001 13:34:13
|
|
> What is the best method of generating query/reports
> from data inside a name/value pair table? I need
> totals, percentages..etc.
> thanks
>
> __________________________________________________
> Do You Yahoo!?
> Check out Yahoo! Shopping and Yahoo! Auctions for all of
> your unique holiday gifts! Buy at http://shopping.yahoo.com
> or bid at http://auctions.yahoo.com
What data types are you working with in your value column? Do you have
any code that you've already started with to give us some info? Just
making an assumption, but have you tried the CAST or CONVERT functions?
Message #3 by dont worry <aspmailbox@y...> on Tue, 11 Dec 2001 07:37:13 -0800 (PST)
|
|
It is all text data, I haven't tried the Cast or
Convert. I do group by or while not eof and increment
a counter. Then use the counter for totals.
Thanks
--- Melinda Savoy <msavoy@h...> wrote:
> > What is the best method of generating
> query/reports
> > from data inside a name/value pair table? I need
> > totals, percentages..etc.
> > thanks
> >
> > __________________________________________________
> > Do You Yahoo!?
> > Check out Yahoo! Shopping and Yahoo! Auctions for
> all of
> > your unique holiday gifts! Buy at
> http://shopping.yahoo.com
> > or bid at http://auctions.yahoo.com
>
>
> What data types are you working with in your value
> column? Do you have
> any code that you've already started with to give us
> some info? Just
> making an assumption, but have you tried the CAST or
> CONVERT functions?
$subst('Email.Unsub').
__________________________________________________
Do You Yahoo!?
Check out Yahoo! Shopping and Yahoo! Auctions for all of
your unique holiday gifts! Buy at http://shopping.yahoo.com
or bid at http://auctions.yahoo.com
|
|
|
View Cart
