I am really struggling this SQL query for a week now. My query did not output the right results. I tried pivot, tsql but no luck.
I have a SQL table with multiple rows and columns. All I want is convert all rows based on filename and RowID into one row with multiple columns. Whatever the RowID is the Column Name per filename. Please see attached file for more info.
Thank you again.