Use multiple aggregate columns in pivot query in SQL Server

Last Reply 7 months ago By pandeyism

Posted 7 months ago


I have a table which gives following output using query

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


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

should be like:


You are viewing reply posted by: pandeyism 7 months ago.