Re: SHOW RESULT IN COLUMN

#1

Hi

The following gives a list of links for crosstab queries:

http://tinyurl.com/i9mt

John
"T.S.Negi" <tilak.negi (AT) mind-infotech (DOT) com> wrote

Quote:

I want to see the data in header, so that can be simply shown in ASP/JSP
page.
The sample data and the required result is given below.

Can anybody suggest something.....

Sample Data:
=======================================
SQLBook 200.0 2003-07-28 17:47:43.573
Pen 100.0 2003-07-28 17:47:47.200
Mouse 100.0 2003-07-28 17:47:47.213
SQLBook 200.0 2003-07-28 17:47:47.213
Pen 200.0 2003-07-28 17:47:47.230
Pen 200.0 2003-08-28 17:47:47.230

Want result like this: (Required result)
=====================================
Date SQLBook Pen Mouse
======================================
2003-07-28 400.00 300.00 100.00
2003-08-28 0.00 200.00 0.00
======================================

Thanx in Adv.

T.S.Negi
tilak.negi (AT) mind-infotech (DOT) com
(MIND)

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Re: SHOW RESULT IN COLUMN

comp.databases.ms-sqlserver comp.databases.ms-sqlserver

Re: SHOW RESULT IN COLUMN - 07-28-2003 , 07:55 AM