i am trying following but i got error
set @convert = 'select * from (select * from Loandt where lnno=123 ) Repayment
pivot(sum(Amount) for Lndt
in ('+@columns+')) as pivottable'
1 Reply
Know the answer? Post it — somebody with the same question will find it here.
Sign in to answer this question
It is the same account you read, post and publish with — and you will come straight back to this page.
Vithal WadjePosted Nov 19, 2012, 5:21 AM