Showing posts with the label Pivot QueryShow all

Pivot query in sql server

Steps  Create the required tables Employees and department as given in script create the as string and run it using Exec( ) function Required Output create table Department ( DepartmentID int primary key identity , DepartmentName varchar ( 200 ) ) create table …

Read more