-
as seen on SQL Blog
- Search for 'SQL Blog'
A question on the SSIS forum earlier today asked: I need to dynamically unpivot some set of columns in my source file. Every month there is one new column and its set of Values. I want to unpivot it without editing my SSIS packages that is deployed Let’s be clear about what we mean by Unpivot…
>>> More
-
as seen on Stack Overflow
- Search for 'Stack Overflow'
Is there a unpivot equivalent function in PostgreSQL?
>>> More
-
as seen on Stack Overflow
- Search for 'Stack Overflow'
Hello
I got child / parent tables as below.
MasterTable:
MasterID, Description
ChildTable
ChildID, MasterID, Description.
Using PIVOT / UNPIVOT how can i get result as below in single row.
if (MasterID : 1 got x child records)
MasterID, ChildID1, Description1, ChildID2, Description2....…
>>> More
-
as seen on Stack Overflow
- Search for 'Stack Overflow'
Hello
I got child / parent tables as below.
MasterTable:
MasterID, Description
ChildTable
ChildID, MasterID, Description.
Using PIVOT / UNPIVOT how can i get result as below in single row.
if (MasterID : 1 got x child records)
MasterID, ChildID1, Description1, ChildID2, Description2.......…
>>> More
-
as seen on Oracle Blogs
- Search for 'Oracle Blogs'
??????????? ???????????????????????????????????????? ????????????????????????”??????”??????????????????????????????????????????????????????????????????????????????????????(1)?????????????????(????????)?(2)?????????????????????(???????)????????????2?????????????????????????????????????????????????…
>>> More
