Data IntegrationJanuary 1, 2023by Gokuldas Chandgadkar0
Using Pivot and UnPivot in Transact-SQL (Part-1):
Background: One of the common scenarios we need to handle in the Data Integration process is to Pivot or UnPivot the input data received from external systems such as ERP or Finance systems. Microsoft SQL-Server provides two very good Transact-SQL commands Pivot and UnPivot to handle such transformations. In this part-1 series of this article...
