I have two SQL tables (SQL 2005) that I need to join but am in need of some
assistance. Essentially I need to join a column name with row field values.
The first table contains the following columns
- Loan ID
The second table contains the following columns
However, the rows in the second table for the Ord column contain
the following values:
I need to join the row field value of the second table with
the column name of the first table. I want to display the values of the respsective columns of table one (Ord_SignedApp, Ord_Title, Ord_Reg, Ord_Name) and place them in a new column. These values are represented as dates
Any assistance you can provide would be much appreciated.
Thank you for your help,
View Complete Post