?????????????????漲?Щ????????????.???????????????????????????Instead of ??????????????????????????????????????????????鷳?????????????????????????????????e???????????????????????????е?dummy table?????????

???????????????????????????????′?

????Region??

 

 

RegionId

RegionName

IsActive

EffectiveDate

ExpirationDate

1

East

1

1/1/2009

NULL

2

West

1

1/1/2009

NULL

3

North

1

1/1/2009

NULL

4

South

1

1/1/2009

NULL

5

Antarctica

1

1/1/2009

NULL

????Office??

 

 

RegionId

RegionId

OfficeName

IsActive

EffectiveDate

ExpirationDate

1

1

New York

1

1/1/2009

NULL

2

2

Los Angeles

1

1/1/2009

NULL

3

3

Minneapolis

1

1/1/2009

NULL

4

4

Atlanta

1

1/1/2009

NULL

5

5

Byrd Station

1

1/1/2009

NULL

????????α??????(IsActive=1)??Office????????Region??

????????????????????????????.RegionId??Office????????Check??????????ExpirationDate???Null??????￡??????????1.??????????η??IsActive???Office????IsActive=0??Region????????????????????????Instead of??????????????????????????????????????????????????????е????????????

????DuplicateRows table

????DuplicateRows????????У?????

 

 

DuplicateRowIndex

DuplicateRowValue

1

Duplicate Row

2

Duplicate Row

??????????????????????????????????У???????????????????????????????????????е???????е??????????????????????????????????“Duplicate Row”?????????????????????????????????????????????????????DBA?????????