Convert row to column in sql

Declare @OrderId int = 2

If((select distinct 1 from Tem where Order_Id = @OrderId)=1)
begin
select Orange,Apple,Mango from
(select Order_Id,ItemType,total From Tem Where Order_Id = @OrderId)u
pivot(sum(total) for ItemType in ([Orange],[Apple],[Mango])) as pvt
end

Use Dynamic Query with Pivot... try some thing like this...

Declare @Id Int, @Sql varchar(400),@Cols varchar(40)
Create Table #Temp
		(
		Order_Id Int,
		InventoryId	 Int,
		ItemType Varchar(40),
		total Int
		)

Insert into #Temp
Values(1,5,'Orange',5000),(1,4,'Apple',3000),(2,1,'Mango',3400),(2,5,'Orange',1700)

Set @Id=2  -- if you want records for id 1 set @Id=1

Set @Cols= Stuff((Select Distinct '],['+ItemType From #Temp Where Order_Id=@Id 
           for Xml Path(''),Type).value('.','VARCHAR(Max)'), 1, 2,'')+']'

Set @Sql= 'Select '+@Cols + 'From (Select ItemType,total From #Temp Where Order_Id='
          + Cast(@Id as Varchar) +')st pivot (Sum(total) For ItemType in ('
          + @Cols + '))Pvt'

Exec(@Sql)

Drop Table #Temp 

The following works with catalogs (when there is only one row for each fruit

select 
        max(case when ItemType = 'Orange' then Total end) as Orange
        , max(case when ItemType = 'Apple' then Total end) as Apple
        , max(case when ItemTpe = 'Mango' then Total end) as Mango
//...and so on

FROM Inventory

Should there be many rows for each fruit, use SUM instead of MAX.

There is no straight way (that I know of) to avoid hard-coding every event, unless you use something like C# or VB or C++ to build your query string.