Pivot SQL server 2008

[sven2]

Hello,

how can I make a pivot query in SQL server 2008?

This is the select query where an employee can hace more than 1 function. It would be nice to display all the functions of this employee on 1 line.

SELECT Employee.Employeenumber, Employeefunction.FunctionID
FROM Employee INNER JOIN
Employeefunction ON Employee.Employeenumber = Employeefunction.Employeenumber

Thanks in advance,
Sven.

 

[namliam]

Your not looking for a crosstab, what your looking for is analytics

The googling using this link:
http://www.google.nl/search?hl=nl&q...gs_rfai=&gs_upl=11295,1121,36,4,41,218,29,2,1

 

[sven2]

Hello,

what do you mean by analytics? Is it the use of partition and rank?

Now it is os that in the table employeefunction I have 2 fields like employeenumber and employeefunctionID. An employee can have more than 1 function.

I want to display that information in 1 line for each eployee.

Is this possible with the commands partion and rank?

Best regards,
Sven.