Mauro Cazabonnet
asked on
SQL Pivot table
I'm trying to convert the following table
id data
1 2
2 ServerABC
3 ClientA
4 ServerXYZ
5 ServerFGH
6 Duplicate
to look like this
DupeCnt Server InitialCatalog DirectoryServer IIS
2 ServerABC ClientA ServerXYZ ServerFGH
I need to exclude 6 duplicate
Any help much appreciated
id data
1 2
2 ServerABC
3 ClientA
4 ServerXYZ
5 ServerFGH
6 Duplicate
to look like this
DupeCnt Server InitialCatalog DirectoryServer IIS
2 ServerABC ClientA ServerXYZ ServerFGH
I need to exclude 6 duplicate
Any help much appreciated
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER