Hi guys,
Im after some SQL knowledge if possible please and the use of pivots - can anyone assist me? Basically Ive got a table which stores data as below
And I cant for the life of me work out how to PIVOT the TraceableItemID so it reads
And so on...
Thanks
Im after some SQL knowledge if possible please and the use of pivots - can anyone assist me? Basically Ive got a table which stores data as below
Code:
You don't have permission to view the code content. Log in or register now.
And I cant for the life of me work out how to PIVOT the TraceableItemID so it reads
Code:
You don't have permission to view the code content. Log in or register now.
And so on...
Thanks