I am struggling to convert rows to columns in SQL Server. I know there's pivot function but my situation is different which i try to explain below:
This is my original record set
There can be one value against a booking id field or there can be 100s of values against a booking id. I want to convert first 9 values into rows against each booking id. So if there's one value it creates one column and if there are 9 it create 9 columns.
below is an example of what i need.