Comments by Member 8083455

Member 8083455 28-Jan-15 7:55am View

thanks for support.. but it solve if i have integer, but i have string.
now i have updated my question to clear it.

Member 8083455 11-Oct-12 1:07am View

hi aarti.
as you suggest i have changed database structure.
but now how can i dynamically pivot this table in previous structure.
now my table contain date, code,head_name, amount.
and i want o/p in following format:
date , code, head1, head2, head3,.........

Member 8083455 5-Oct-12 6:22am View

THANKS.

Member 8083455 4-Oct-12 6:00am View

CAN WE GET RIGHT STRUCTURE BY USING DYNAMIC PIVOT.
IF YES PLEASE TELL ME QUERY.

Member 8083455 1-Oct-12 8:30am View

THANKS AARTI
BUT IF WE INCREASE NO OF HEAD AS HEAD4, HEAD5, .... THEN WE CANT GET IT.
I WANT TO GET IT DYNAMICALLY.
AND PLEASE COULD YOU HINT ME TO MODIFY DATABASE STRUCTURE...

Member 8083455 25-Sep-12 3:04am View

Thanks for response.

but another problem is that textbox on form1 is on a groupbox.
in such case how to find it....?

Comments by Member 8083455 (Top 6 by date)