I'm using a vendor supplied Relay Database (Aspen), which is running on MS SQL server). I'm attempting to write a pivot query that needs to pivot on 2 columns. I created a temp table since the data is across multiple tables.
SPECIAL POSTING NOTES - Sr Engineer System Protection and Control –. Experience using ASPEN or other fault study program, ASPEN relay database. ASPEN Relay Database V11 Client/Server is a program by ASPEN Inc. Frequently, people decide to uninstall this program. Sometimes this can be easier said than done because removing this by hand takes some knowledge related to PCs.
It may be easier with a bunch of case statements and a group by RID. By the way this is the 'original' method of pivoting before PIVOT was implemented.
Comments are closed.
|
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |