Thanks Craig.

The problem is, in the first step, its doing Cartesian product between resulting records of

3 joins with 'pple_t_Student_Profile' table which is killing tempDB. When I added another join...

This might be helpful too !

http://www.sqlservercentral.com/Forums/Topic1029409-1550-1.aspx

Thank y'all Mates for your help.At this moment, I guess I should go with the solution I posted earlier even though, it is not simple.

As you can see there, the...

Tried that too, Still no change !!

Well, Even though I am not good at using CT Expressions, According to my knowledge, the following should work. But, if I try this, Its showing error "FROM keyword not...

I got the solution.

@LutzM: Thanks for ur hlp. Its not the homework BTW, the problem is far more complex.

I jz drilled it down to look like simple one.

The following...

Thank y'all. I got the solution.

@ Rajiv: I've learnt a new concept from ur post, thanks

@ Rohra: Your approach is simple and precise. Thnx again mate :).

Thanks for your reply..

I have tried the following, The only question is how can i manipulate it to display the GPA too

SELECT SID,MAX(DATE_OF_UPDATE) from S_TABLE

group by SID

select distinct final.ID,final.TERM,substring(final.results,2,len(final.results))

from

(

select t.ID,t.TERM,(select ',' + class from Demo m where m.term = t.term and m.id=t.id

for xml path (''))

results from Demo t

) final

--------------------------

Finally,...

ERROR!!

Thank you Bhuvanesh.