Hello this is my first post and my TSQL is average at best so any help will be much appreciated
I want to create a view on a SQL 2005 Table that contains the data I need but the data is currently in the wrong layout.
What I mean is there are 2 fields (SerialBox, SerialNo) which currently have the format below :-
What I want is
SerialBox SerialNo1 SerialNo2 SerialNo3 SerialNo4 SerialNo5 SerialNo6 SerialNo7
Box1 Serial1 Serial2 Serial3 Serial4 Serial5 Serial6 Serial7
Box2 Serial1 Serial2 Serial3 Serial4 Serial5 Serial6 Serial7
Box3 Serial1 Serial2 Serial3 Serial4 Serial5 Serial6 Serial7
Can this be done in a View ?