Re: Cross Tab Query
From: Hugo Kornelis (hugo_at_pe_NO_rFact.in_SPAM_fo)
Date: 02/07/05
- Next message: Hugo Kornelis: "Re: Difference between = and IN"
- Previous message: Andy: "Re: Difference between = and IN"
- In reply to: Daud: "RE: Cross Tab Query"
- Messages sorted by: [ date ] [ thread ]
Date: Mon, 07 Feb 2005 12:35:01 +0100
On Sun, 6 Feb 2005 22:29:02 -0800, Daud wrote:
>Than u very much dear u were the only who replied my and understand the
>issue. But unfortunately u have give the example for static entry I need
>dynamic one in the form that whatever records are entered in the table in the
>form they autometically comes in this way.
Hi Daud,
There is no easy way to do this in SQL Server. Since this is basically a
formatting issue, the obvious recommendation is to do this at the client,
which is the "proper" place for formatting in a tiered architecture.
If you really must do this at the server, you'll either have to use
dynamic SQL to generate a query like the one Nigel suggests, with the
"correct" values taken from your table, or you can use a third party
product, like RAC4SQL (www.rac4sql.com). Or you could wait for the release
of SQL Server 2005 - I've read that this version will provide crosstab
functionality.
Best, Hugo
-- (Remove _NO_ and _SPAM_ to get my e-mail address)
- Next message: Hugo Kornelis: "Re: Difference between = and IN"
- Previous message: Andy: "Re: Difference between = and IN"
- In reply to: Daud: "RE: Cross Tab Query"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
|
