Forum Discussion
Listing Values, Columns Axis
Hi, I have a large number of columns in SQL Server (150) that have values. Let's say the values are green, blue, red. My goal is to display all of the columns with a value of green from top to bott...
For your proposed solution, do you have any direction to perform/create the function?
provide some sample data and the expected result
Hi, here's the same information. For my real data, I have hundreds title, description and "status" columns.
Audit_ID Audit_Date Company_ID ABC123_Title ABC123_Description ABC123_Status XYZ123_Title XYZ123_Description XYZ123_Status 1 1/1/20
1 ABC123_Title #1 ABC123_Description #1 Implemented XYZ123_Title #1 XYZ123_Description #1 Not Implemented 2 2/1/20 2 ABC123_Title #2 ABC123_Description #2 Implemented XYZ123_Title #2 XYZ123_Description #2 Not Implemented 3 3/1/20 3 ABC123_Title #3 ABC123_Description #3 Implemented XYZ123_Title #3 XYZ123_Description #3 Not Implemented 4 4/1/20 4 ABC123_Title #4 ABC123_Description #4 Implemented XYZ123_Title #4 XYZ123_Description #4 Not Implemented 5 5/1/20 5 ABC123_Title #5 ABC123_Description #5 Implemented XYZ123_Title #5 XYZ123_Description #5 Not Implemented Ideally I would like to have a report showing the following:
Company 1
Date Performed (1/1/20)
Implemented ABC123_Title Not Implemented XYZ123_Title Sorry, tables smashed together and I didn't see a spot to upload an excel file.
Hi ez1138 ,
I don't particularly understand what you want.
Do you want to convert Table 1 to get Table 2?
Table1
Table2
Best regards,
Lionel ChenIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
