I have data in a SQL Table with the following structure:
Engine_No Date Process Bolt_No1 B1Value1 B1Value2 B1Value3 Bolt_No2 B2Value1 B2Value2 B2Value3 Bolt_No3 B3Value1 B3Value2 B3Value3 Bolt_No4 B4Value1 B4Value2 B4Value3
I want to display the following results of a query:
SR NO Engine_No Date Process B1Bolt_No1 B1Value1 B1Value2 B1Value3
SR NO Engine_No Date Process B2Bolt_No2 B2Value1 B2Value2 B2Value3
SR NO Engine_No Date Process B3Bolt_No3 B3Value1 B3Value2 B3Value3
SR NO Engine_No Date Process B4Bolt_No4 B4Value1 B4Value2 B4Value3
Can someone suggest a Query that achieves this?
See Question&Answers more detail:os