dbTalk Databases Forums  

Re: SHOW RESULT IN COLUMN

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


Discuss Re: SHOW RESULT IN COLUMN in the comp.databases.ms-sqlserver forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
John Bell
 
Posts: n/a

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






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)



Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.