<div>
Why do want to change a normalized solution to a denormalized one?<br />
What you have currently is what is expected in a relational database. Can you provide the reason for why you want to do this?
</div>


Why do want to change a normalized solution to a denormalized one?
What you have currently is what is expected in a relational database. Can you provide the reason for why you want to do this?

<div>
@vitor<br />
<br />

<blockquote>
Why do want to change a normalized solution to a denormalized one?
</blockquote>
<br />
do you think op is working for MS Data Warehouse :)<br />
<br />
probably this is just homework question...
</div>


@vitor



> Why do want to change a normalized solution to a denormalized one?


do you think op is working for MS Data Warehouse :)

probably this is just homework question...

<div>
<div class="content wysiwyg-content">
hi Experts, <br />
<br />
I want to add a column of [Loan ID] with its data value in table A. Can you help me on it? Thanks. <br />
<a href="https://filedb.experts-exchange.com/incoming/2017/05_w19/1161257/Capture.PNG" target="_blank" title="Capture.PNG (8 KB)"><img alt="Capture.PNG" class="file-block lazyload" style="max-width: 567px;" data-src="https://filedb.experts-exchange.com/incoming/2017/05_w19/1161257/Capture.PNG" /></a>
</div>
</div>


Capture.PNG

hi Experts, 

I want to add a column of [Loan ID] with its data value in table A. Can you help me on it? Thanks. 


sql how to insert a column with the data  in an existing table

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.