January 2, 2008 at 3:24 am
Hi,
I need to create a cross tab from the existing table
I have table consisting of
name surname month value
abc xyz jan 3255
def adf feb 2325
abc sdfg mar 2456
I need a crosstab for a particular name
eg for name abc my crosstab should be
surname jan mar
xyz 3255 0
sdfg 0 2456
If anybody has a solution do provide it
regards,
Nayana
January 2, 2008 at 4:09 am
nayanamoolya (1/2/2008)
Hi,I need to create a cross tab from the existing table
I have table consisting of
name surname month value
abc xyz jan 3255
def adf feb 2325
abc sdfg mar 2456
I need a crosstab for a particular name
eg for name abc my crosstab should be
surname jan mar
xyz 3255 0
sdfg 0 2456
If anybody has a solution do provide it
regards,
Nayana
Read about Cross-tab reports in sql server help file
Failing to plan is Planning to fail
January 2, 2008 at 6:34 am
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply