Use multiple aggregate columns in pivot query in SQL Server

chetan

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:

pandeyis...

0 7

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

I agree, here is the link: https://www.e-iceblue.com/Introduce/spire-office-for-net-free.html