SQLTeam.com | Weblogs | Forums

Need help in Pivot Related Query

I have a table which gives folowing output using query
"select VisaModeID,VisaValidity,StayValidity,ProcessTime from Service where VisaTypeID=1"

11

https://docs.microsoft.com/en-us/sql/t-sql/queries/from-using-pivot-and-unpivot?view=sql-server-2017

Please post create table and insert statements.