OiO.lk Blog SQL Please see the photo file because i am too difficult for this conversion. I want to convert data from row to column like this in SQL. Thanks all
SQL

Please see the photo file because i am too difficult for this conversion. I want to convert data from row to column like this in SQL. Thanks all


FILE
ORIGINAL

I WANT IT’S

I want to convert the data behind the row into a column as shown in SQL. The problem becomes complicated when there are too many conditions so I cannot use Unpivot to satisfy the conditions. Please check the image I have described.



You need to sign in to view this answers

Exit mobile version