Ask - Reg: Doubt this Task Query

Getting Started with Adobe After Effects - Part 6: Motion Blur

Ask questions, discuss or help others by answering

Reg: Doubt this Task Query

May 15 2012 1:32AM by Guru Samy

Hi Madhivanan,

I have one doubt the one task in SQL Query, so can please suggest me.

Table name is :TblMarkList

Sample Data:

MID RollNo SubjectID MaxMarks ExamDate Marks

1 12345 Sub01 100 05/04/2012 50

2 23456 Sub02 100 06/04/2012 60

3 34567 Sub01 100 05/04/2012 55

4 12345 Sub02 100 06/04/2012 65

My Expected Result is:

Sl.No. RollNo Sub01 Sub02

MaxMarks 100 100

ExamDate 05/04/2012 06/04/2012

1 12345 50 65

2 23456 0 60

3 34567 55 0

Thanks

Submitted under: · · · ·

Guru Samy

9 · 16% · 4992

See if you can apply this logic http://beyondrelational.com/modules/2/blogs/70/posts/10840/dynamic-pivot-in-sql-server-2005.aspx

commented on May 16 2012 2:59AM

Madhivanan

3 · 39% · 12440

Sign Up or Login to post a comment.