<div>
<div class="content wysiwyg-content">
I have a table DimCounty(CountyID,CountyDescr).This has 3000 distinct rows 
CountyID &nbsp; &nbsp;CountyDescr 
1 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Abbeville 
2 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Acadia 
3 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Adair 
 
 
 
Another Table CountyStatusFACT(CountyID,CountyDescr,StatusID,Projcount). 
This is as follows: 
CountyID &nbsp; &nbsp;CountyDescr &nbsp; StatusID &nbsp; &nbsp;Projcount 
1 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Abbeville &nbsp; &nbsp; &nbsp; 100 &nbsp; &nbsp; &nbsp; &nbsp; 2 
1 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Abbeville &nbsp; &nbsp; &nbsp; 200 &nbsp; &nbsp; &nbsp; &nbsp; 10 
2 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Acadia &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;200 &nbsp; &nbsp; &nbsp; &nbsp; 24 
 
I want to update CountyStatusFACT where CountyID is updated with the values of CountyID as in table DimCounty. 
So we get the result as shown above. 
 
Thanks
</div>
</div>

I have a table DimCounty(CountyID,CountyDescr).This has 3000 distinct rows
CountyID    CountyDescr
1           Abbeville
2           Acadia
3           Adair



Another Table CountyStatusFACT(CountyID,CountyDescr,StatusID,Projcount).
This is as follows:
CountyID    CountyDescr   StatusID    Projcount
1           Abbeville       100         2
1           Abbeville       200         10
2           Acadia          200         24

I want to update CountyStatusFACT where CountyID is updated with the values of CountyID as in table DimCounty.
So we get the result as shown above.

Thanks

Update table

Microsoft SQL Server 2005 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. It includes support for managing XML data and allows a database server to be exposed over web services using Tabular Data Stream (TDS) packets encapsulated within SOAP (protocol) requests.