Use multiple aggregate columns in pivot query in SQL Server

Last Reply 2 months ago By pandeyism

Posted 2 months ago

Hi,

I have a table which gives following output using query

"select VisaModeID,VisaValidity,StayValidity,ProcessTime from Service where VisaTypeID=1"

Output:

Now I need Pivot Related Query which gives below output from above table.

should be like:

 

You are viewing reply posted by: pandeyism 2 months ago.
Posted 2 months ago Modified on 2 months ago

Hi chetan,

Refer below link and provided by me query both take reference and change query itself.

Use multiple aggregate columns in pivot query in SQL Server