I try to flatten a table.

in Access I would do this: iif(sequence=1,[Technology],Null) AS Tech1, iif(sequence=2,[Technology],Null) AS Tech2 FROM tblTechnologies GROUP BY Application

How do I flatten a file in SQL Server?

Thanks