Last post Mar 27, 2018 12:11 PM by IsaiSelvan
Mar 27, 2018 11:55 AM|IsaiSelvan|LINK
please find the below table format. I need the output for the below format. I'm trying to retrieve output format but only one column able to bind.
I'm using in Sql server 2008 R2. I'm working in this issue last 2 days but i can't to bind it.I need the without using pivot and unpivot function.
AAA AA+ AA AA- Name
6.05 7.15 9.5 8.5 A
3.02 4.58 6.25 7.25 B
2.25 1.02 0 6 C
Name A B C
AAA 6.05 3.02 2.25
AA+ 4.05 3.04 1.02
AA 3.02 4.05 0
AA- 2.03 3.01 6
Mar 27, 2018 12:02 PM|PatriceSc|LINK
Why without (not even dynamic which might be your issue ?) ? How will you consume this output ?
If your intent is to show this on a web site you could use a DataTable that you'll build in memory while reading source rows...
Mar 27, 2018 12:11 PM|IsaiSelvan|LINK
I need the that output format in my requirement. I'm tried in lot ways, but can't to retrieve a output. If i'm using datatable to bind in my grid that is possible. But i'm altering my table whenever i change the dll in my machine. I need to create procedure
then binding format. Kindly help me. last two days am working on this issue.