Re: extreme help with query of 2 tables into 1 long table
- From: Hugo Kornelis <hugo@xxxxxxxxxxxxxxxxxxxxxx>
- Date: Fri, 10 Jun 2005 23:53:54 +0200
On Thu, 9 Jun 2005 09:42:06 -0700, LU wrote:
>Hugo,
>When you say "front end/presentatio layer" can I import and do in access or
>excel?
Hi LU,
I must admit that I have little expertise with respect toi front end
applications. But as far as I know, Access has some builtin
functionality to create a cross-tab table (look up "TRANSFORM" and
"PIVOT" in the online help, or use the crosstab query wizard). And Excel
can do crosstab reports as well.
>Or is this something I can do in asp.net?
Probably, but you'd better ask in a group for asp.net! <g>
>or a third party component?
Some third party applications that might help you generate the crosstab
at the server (though I still recommend against it!) may be found near
the end of this page: http://www.aspfaq.com/show.asp?id=2462
Best, Hugo
--
(Remove _NO_ and _SPAM_ to get my e-mail address)
.
- References:
- extreme help with query of 2 tables into 1 long table
- From: BIGLU
- Re: extreme help with query of 2 tables into 1 long table
- From: Hugo Kornelis
- Re: extreme help with query of 2 tables into 1 long table
- From: LU
- extreme help with query of 2 tables into 1 long table
- Prev by Date: Re: extreme help with query of 2 tables into 1 long table
- Next by Date: Stored Procedure - Obtaining Output
- Previous by thread: Re: extreme help with query of 2 tables into 1 long table
- Next by thread: Create Query task
- Index(es):
Relevant Pages
|
|
