Posted by vedavyas.rao on 01/13/06 09:05

I have SQL records as follows



REGION PRODUCT Amount Week
IMDS A 100 Week1
IMDS A 250 Week2
IMDS A 150 Week3

IMDS B 525 Week1
IMDS B 400 Week2

IMDS C 500 Week2
IMDS C 40 Week3

IHYD A 50 Week1
IHYD A 52 Week2
IHYD A 100 Week3
IHYD D 20 Week2

I want to display these items in ASP as


REGION PRODUCT Week1 Week2 Week3

IMDS A 100 250 150
IMDS B 525 400 0
IMDS C 0 500 40
IHYD A 50 52 100
IHYD D 0 20 0


Is there any "SQL query" which helps me to bring the above output
without using
any front end calculation?

[Back to original message]