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?

• Next in forum: Re: Advanced Sql-Shape Query - Help
• Prev in forum: Why would adding dbo. cause my function to run forever?
• Thread view: SQL QUERY HELP

[Reply to this message]