How can I restore a database from a UNC?

It appears that Management Studio will not allow you to perform a restore from a UNC path. Is this true or am I missing the option to open the magic UNC door? I am very new to SQL2005 and this was buried in SQL2000, but it was possible to do in Enterprise Manager.

Have you tried using the raw TSQL query to start the restore, and not use the GUI Interface.

|||

Not to be snotty, but you didn't answer the question. Your point is taken, there are other ways to do this. I can use a script to restore from a UNC path. I am still interested in getting an answer to the question I posted, not to the underlying assumption that I am looking for any way to accomplish a restore from UNC.

As a DBA, I do many operations by script; however, there are times that, for a number of reasons, the UI is a better option. Since this was something that could be done in SQL2000 through the UI, I thought that perhaps Microsoft would also provide a means to do it through the UI in 2005. We have non-technical folks who need to do restores from different sources for demos. It is more practical to teach them how to use the UI to grab the backup they need for their laptop rather than scripting the numerous possibilities or having them alter a script.

So, if anyone knows if Management Studio can be used to do a UNC restore, please share with me how it can be done.

|||Hi,

this is sure possible: Select Restore Files and Filegroup --> Fome Device --> Add --> Enter a Full qualified name in the filename textbox like \\m2-jenss\SomeShare\Somebakfile.bak

and you are done.

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de
|||You nailed it. I initially tried that, but permissions foiled me, but I misread it as a limitation of the UI because the Selected Path pointed to a local drive and the field was disabled. Apparently, anything you put in File name will override the Selected Path entry if using the UNC path. Thanks a ton!

How can I optimize this routine

I need to update a very large fact summary table with the detail data from
other fact tables - what suggestions are there for making this perform bette
r
on the server?
UPDATE STAGE_PHX_FACT_POLICY
set county = FACT_POLICY_HO.County,Sub_County = FACT_POLICY_HO.Sub_County,
Zipcode = FACT_POLICY_HO.Zipcode,Policy_Form = FACT_POLICY_HO.Policy_Form,
Med_Pay_Amt = FACT_POLICY_HO.Med_Pay_Amt,Protection_Class =
FACT_POLICY_HO.Protection_Class,
Construction_Type = FACT_POLICY_HO.Construction_Type,Construction_Year =
FACT_POLICY_HO.Construction_Year,
Occupancy = FACT_POLICY_HO.Occupancy,RC_ACV_Bldg = FACT_POLICY_HO.RC_ACV_Bld
g,
RC_ACV_Contents = FACT_POLICY_HO.RC_ACV_Contents,Covg_Amount =
FACT_POLICY_HO.Amt_Of_Ins,
Ded_Amount = FACT_POLICY_HO.Ded_Amt,Liab_Amount = FACT_POLICY_HO.Liab_Amt
from FACT_POLICY_HO
where stage_phx_fact_policy.policy_number = fact_policy_ho.policy_number
and stage_phx_fact_policy.policy_date_time = fact_policy_ho.policy_date_time
UPDATE STAGE_PHX_FACT_POLICY
set Prot_Device = 'Y'
from fact_policy_ho
where smoke_detector = 'Y'
and stage_phx_fact_policy.policy_number = fact_policy_ho.policy_number
and stage_phx_fact_policy.policy_date_time = fact_policy_ho.policy_date_time
UPDATE STAGE_PHX_FACT_POLICY
set county = FACT_POLICY_MH.County,Zipcode = FACT_POLICY_MH.Zipcode,
Policy_Form = FACT_POLICY_MH.Policy_Form,Med_Pay_Amt =
FACT_POLICY_MH.Med_Pay_Amt,
Protection_Class = FACT_POLICY_MH.Protection_Class,Construction_Year =
FACT_POLICY_MH.Construction_Year,
Occupancy = FACT_POLICY_MH.Occupancy, RC_ACV_Bldg =
FACT_POLICY_MH.RC_ACV_Bldg,
RC_ACV_Contents = FACT_POLICY_MH.RC_ACV_Contents,Covg_Amount =
FACT_POLICY_MH.Amt_Of_Ins,
Ded_Amount = FACT_POLICY_MH.Ded_Amt,Liab_Amount = FACT_POLICY_MH.Liab_Amt
from FACT_POLICY_MH
where stage_phx_fact_policy.policy_number = fact_policy_mh.policy_number
and stage_phx_fact_policy.policy_date_time = fact_policy_mh.policy_date_time
UPDATE STAGE_PHX_FACT_POLICY
set Prot_Device = 'Y'
from fact_policy_mh
where smoke_detector = 'Y'
and stage_phx_fact_policy.policy_number = fact_policy_mh.policy_number
and stage_phx_fact_policy.policy_date_time = fact_policy_mh.policy_date_time
UPDATE STAGE_PHX_FACT_POLICY
set county = FACT_POLICY_LL.County,Sub_County = FACT_POLICY_LL.Sub_County,
Zipcode = FACT_POLICY_LL.Zipcode,Policy_Form = FACT_POLICY_LL.Policy_Form,
Protection_Class = FACT_POLICY_LL.Protection_Class,Construction_Type =
FACT_POLICY_LL.Construction_Type,
Construction_Year = FACT_POLICY_LL.Construction_Year,Occupancy =
FACT_POLICY_LL.Occupancy,
RC_ACV_Bldg = FACT_POLICY_LL.RC_ACV_Bldg,Covg_Amount =
FACT_POLICY_LL.Amt_Of_Ins,
Ded_Amount = FACT_POLICY_LL.Ded_Amt,Liab_Amount = FACT_POLICY_LL.Liab_Amt
from FACT_POLICY_LL
where stage_phx_fact_policy.policy_number = fact_policy_ll.policy_number
and stage_phx_fact_policy.policy_date_time = fact_policy_ll.policy_date_time
UPDATE STAGE_PHX_FACT_POLICY
set Prot_Device = 'Y'
from fact_policy_ll
where smoke_detector = 'Y'
and stage_phx_fact_policy.policy_number = fact_policy_ll.policy_number
and stage_phx_fact_policy.policy_date_time = fact_policy_ll.policy_date_time
UPDATE STAGE_PHX_FACT_POLICY
set county = FACT_POLICY_RF.County,Sub_County = FACT_POLICY_RF.Sub_County,
Zipcode = FACT_POLICY_RF.Zipcode,Policy_Form = FACT_POLICY_RF.Policy_Form,
Protection_Class = FACT_POLICY_RF.Protection_Class,Construction_Type =
FACT_POLICY_RF.Construction_Type,
Construction_Year = FACT_POLICY_RF.Construction_Year,Occupancy =
FACT_POLICY_RF.Occupancy,
RC_ACV_Bldg = FACT_POLICY_RF.RC_ACV_Bldg,RC_ACV_Contents =
FACT_POLICY_RF.RC_ACV_Contents,
Primary_Loc = FACT_POLICY_RF.Primary_Loc,Covg_Amount =
FACT_POLICY_RF.Amt_Of_Ins,
Ded_Amount = FACT_POLICY_RF.Ded_Amt,Liab_Amount = FACT_POLICY_RF.Liab_Amt
from FACT_POLICY_RF
where stage_phx_fact_policy.policy_number = fact_policy_rf.policy_number
and stage_phx_fact_policy.policy_date_time = fact_policy_rf.policy_date_time
UPDATE STAGE_PHX_FACT_POLICY
set county = FACT_POLICY_CF.County,Sub_County = FACT_POLICY_CF.Sub_County,
Zipcode = FACT_POLICY_CF.Zipcode,Policy_Form = FACT_POLICY_CF.Policy_Form,
Protection_Class = FACT_POLICY_CF.Protection_Class,Construction_Type =
FACT_POLICY_CF.Construction_Type,
Occupancy = FACT_POLICY_CF.Owner_Occupied,RC_ACV_Bldg =
FACT_POLICY_CF.RC_ACV_Bldg,
RC_ACV_Contents = FACT_POLICY_CF.RC_ACV_Contents,Primary_Loc =
FACT_POLICY_CF.Primary_Loc,
Covg_Amount = FACT_POLICY_CF.Amt_Of_Ins,Ded_Amount = FACT_POLICY_CF.Ded_Amt,
Liab_Amount = FACT_POLICY_CF.Liab_Amt
from FACT_POLICY_CF
where stage_phx_fact_policy.policy_number = fact_policy_cf.policy_number
and stage_phx_fact_policy.policy_date_time = fact_policy_cf.policy_date_time
UPDATE STAGE_PHX_FACT_POLICY
set Prot_Device = 'Y'
from fact_policy_cf
where fire_burglary_system = 'Y'
and stage_phx_fact_policy.policy_number = fact_policy_cf.policy_number
and stage_phx_fact_policy.policy_date_time = fact_policy_cf.policy_date_time
UPDATE STAGE_PHX_FACT_POLICY
set county = FACT_POLICY_SMP.County,Sub_County = FACT_POLICY_SMP.Sub_County,
Zipcode = FACT_POLICY_SMP.Zipcode,Policy_Form = FACT_POLICY_SMP.Policy_Form,
Protection_Class = FACT_POLICY_SMP.Protection_Class,Construction_Type =
FACT_POLICY_SMP.Construction_Type,
Occupancy = FACT_POLICY_SMP.Owner_Occupied,RC_ACV_Bldg =
FACT_POLICY_SMP.RC_ACV_Bldg,
RC_ACV_Contents = FACT_POLICY_SMP.RC_ACV_Contents,Primary_Loc =
FACT_POLICY_SMP.Primary_Loc,
Covg_Amount = FACT_POLICY_SMP.Amt_Of_Ins,Ded_Amount = FACT_POLICY_SMP.Ded_Am
t,
Liab_Amount = FACT_POLICY_SMP.Liab_Amt
from FACT_POLICY_SMP
where stage_phx_fact_policy.policy_number = fact_policy_smp.policy_number
and stage_phx_fact_policy.policy_date_time = fact_policy_smp.policy_date_tim
e
UPDATE STAGE_PHX_FACT_POLICY
set Prot_Device = 'Y'
from fact_policy_smp
where fire_burglary_system = 'Y'
and stage_phx_fact_policy.policy_number = fact_policy_smp.policy_number
and stage_phx_fact_policy.policy_date_time = fact_policy_smp.policy_date_tim
e
UPDATE STAGE_PHX_FACT_POLICY
set county = FACT_POLICY_BOP.County,Sub_County = FACT_POLICY_BOP.Sub_County,
Zipcode = FACT_POLICY_BOP.Zipcode,Policy_Form = FACT_POLICY_BOP.Policy_Form,
Protection_Class = FACT_POLICY_BOP.Protection_Class,Construction_Type =
FACT_POLICY_BOP.Construction_Type,
Occupancy = FACT_POLICY_BOP.Occupancy,RC_ACV_Bldg =
FACT_POLICY_BOP.RC_ACV_Bldg,
RC_ACV_Contents = FACT_POLICY_BOP.RC_ACV_Contents,Primary_Loc =
FACT_POLICY_BOP.Primary_Loc,
Covg_Amount = FACT_POLICY_BOP.Amt_Of_Ins,Ded_Amount = FACT_POLICY_BOP.Ded_Am
t,
Liab_Amount = FACT_POLICY_BOP.Liab_Amt
from FACT_POLICY_BOP
where stage_phx_fact_policy.policy_number = fact_policy_bop.policy_number
and stage_phx_fact_policy.policy_date_time = fact_policy_bop.policy_date_tim
e
UPDATE STAGE_PHX_FACT_POLICY
set county = FACT_POLICY_FO.County,Sub_County = FACT_POLICY_FO.Sub_County,
Zipcode = FACT_POLICY_FO.Zipcode,Policy_Form = FACT_POLICY_FO.Policy_Form,
Med_Pay_Amt = FACT_POLICY_FO.Med_Pay_Amt,Protection_Class =
FACT_POLICY_FO.Protection_Class,
Construction_Type = FACT_POLICY_FO.Construction_Type,Occupancy =
FACT_POLICY_FO.Occupancy,
RC_ACV_Bldg = FACT_POLICY_FO.RC_ACV_Bldg,RC_ACV_Contents =
FACT_POLICY_FO.RC_ACV_Contents,
Primary_Loc = FACT_POLICY_FO.Primary_Loc,Covg_Amount =
FACT_POLICY_FO.Amt_Of_Ins,
Ded_Amount = FACT_POLICY_FO.Ded_Amt,Liab_Amount = FACT_POLICY_FO.Liab_Amt
from FACT_POLICY_FO
where stage_phx_fact_policy.policy_number = fact_policy_fo.policy_number
and stage_phx_fact_policy.policy_date_time = fact_policy_fo.policy_date_time
UPDATE STAGE_PHX_FACT_POLICY
set Prot_Device = 'Y'
from fact_policy_fo
where smoke_detector = 'Y'
and stage_phx_fact_policy.policy_number = fact_policy_fo.policy_number
and stage_phx_fact_policy.policy_date_time = fact_policy_fo.policy_date_time
UPDATE STAGE_PHX_FACT_POLICY
set county = FACT_POLICY_AP.County,Sub_County = FACT_POLICY_AP.Sub_County,
Zipcode = FACT_POLICY_AP.Zipcode,Policy_Form = FACT_POLICY_AP.Policy_Form,
Med_Pay_Amt = FACT_POLICY_AP.Med_Pay_Amt,Protection_Class =
FACT_POLICY_AP.Protection_Class,
Construction_Type = FACT_POLICY_AP.Construction_Type,Occupancy =
FACT_POLICY_AP.Occupancy,
RC_ACV_Bldg = FACT_POLICY_AP.RC_ACV_Bldg,RC_ACV_Contents =
FACT_POLICY_AP.RC_ACV_Contents,
Primary_Loc = FACT_POLICY_AP.Primary_Loc,Covg_Amount =
FACT_POLICY_AP.Amt_Of_Ins,
Ded_Amount = FACT_POLICY_AP.Ded_Amt,Liab_Amount = FACT_POLICY_AP.Liab_Amt
from FACT_POLICY_AP
where stage_phx_fact_policy.policy_number = fact_policy_ap.policy_number
and stage_phx_fact_policy.policy_date_time = fact_policy_ap.policy_date_time
Would a UNION work better?
Thanks!Hi Patrice
It is not clear if the information in FACT_POLICY_HO and FACT_POLICY_HM are
exclusive, if that is the case then they could be unioned in a subquery. If
not you might be able to use an outer join and check that they exist in
FACT_POLICY_HM before assigning the value in FACT_POLICY_HO.
For the first two statements they can be consolidated as:
UPDATE s
set county = f.County,
Sub_County = f.Sub_County,
Zipcode = f.Zipcode,
Policy_Form = f.Policy_Form,
Med_Pay_Amt = f.Med_Pay_Amt,
Protection_Class = f.Protection_Class,
Construction_Type = f.Construction_Type,
Construction_Year = f.Construction_Year,
Occupancy = f.Occupancy,
RC_ACV_Bldg = f.RC_ACV_Bldg,
RC_ACV_Contents = f.RC_ACV_Contents,
Covg_Amount = f.Amt_Of_Ins,
Ded_Amount = f.Ded_Amt,
Liab_Amount = f.Liab_Amt,
Prot_Device = CASE WHEN s.smoke_detector = 'Y' THEN 'Y' ELSE Prot_Device END
set county = m.County,
from STAGE_PHX_FACT_POLICY s
JOIN FACT_POLICY_HO f ON s.policy_number = f.policy_number and
s.policy_date_time = f.policy_date_time
You can then extend this to cater for the FACT_POLICY_HM table.
John
"Patrice" wrote:

> I need to update a very large fact summary table with the detail data from
> other fact tables - what suggestions are there for making this perform bet
ter
> on the server?
>
> UPDATE STAGE_PHX_FACT_POLICY
> set county = FACT_POLICY_HO.County,Sub_County = FACT_POLICY_HO.Sub_County,
> Zipcode = FACT_POLICY_HO.Zipcode,Policy_Form = FACT_POLICY_HO.Policy_Form,
> Med_Pay_Amt = FACT_POLICY_HO.Med_Pay_Amt,Protection_Class =
> FACT_POLICY_HO.Protection_Class,
> Construction_Type = FACT_POLICY_HO.Construction_Type,Construction_Year =
> FACT_POLICY_HO.Construction_Year,
> Occupancy = FACT_POLICY_HO.Occupancy,RC_ACV_Bldg = FACT_POLICY_HO.RC_ACV_B
ldg,
> RC_ACV_Contents = FACT_POLICY_HO.RC_ACV_Contents,Covg_Amount =
> FACT_POLICY_HO.Amt_Of_Ins,
> Ded_Amount = FACT_POLICY_HO.Ded_Amt,Liab_Amount = FACT_POLICY_HO.Liab_Amt
> from FACT_POLICY_HO
> where stage_phx_fact_policy.policy_number = fact_policy_ho.policy_number
> and stage_phx_fact_policy.policy_date_time = fact_policy_ho.policy_date_ti
me
> UPDATE STAGE_PHX_FACT_POLICY
> set Prot_Device = 'Y'
> from fact_policy_ho
> where smoke_detector = 'Y'
> and stage_phx_fact_policy.policy_number = fact_policy_ho.policy_number
> and stage_phx_fact_policy.policy_date_time = fact_policy_ho.policy_date_ti
me
>
> UPDATE STAGE_PHX_FACT_POLICY
> set county = FACT_POLICY_MH.County,Zipcode = FACT_POLICY_MH.Zipcode,
> Policy_Form = FACT_POLICY_MH.Policy_Form,Med_Pay_Amt =
> FACT_POLICY_MH.Med_Pay_Amt,
> Protection_Class = FACT_POLICY_MH.Protection_Class,Construction_Year =
> FACT_POLICY_MH.Construction_Year,
> Occupancy = FACT_POLICY_MH.Occupancy, RC_ACV_Bldg =
> FACT_POLICY_MH.RC_ACV_Bldg,
> RC_ACV_Contents = FACT_POLICY_MH.RC_ACV_Contents,Covg_Amount =
> FACT_POLICY_MH.Amt_Of_Ins,
> Ded_Amount = FACT_POLICY_MH.Ded_Amt,Liab_Amount = FACT_POLICY_MH.Liab_Amt
> from FACT_POLICY_MH
> where stage_phx_fact_policy.policy_number = fact_policy_mh.policy_number
> and stage_phx_fact_policy.policy_date_time = fact_policy_mh.policy_date_ti
me
>
> UPDATE STAGE_PHX_FACT_POLICY
> set Prot_Device = 'Y'
> from fact_policy_mh
> where smoke_detector = 'Y'
> and stage_phx_fact_policy.policy_number = fact_policy_mh.policy_number
> and stage_phx_fact_policy.policy_date_time = fact_policy_mh.policy_date_ti
me
>
>
> UPDATE STAGE_PHX_FACT_POLICY
> set county = FACT_POLICY_LL.County,Sub_County = FACT_POLICY_LL.Sub_County,
> Zipcode = FACT_POLICY_LL.Zipcode,Policy_Form = FACT_POLICY_LL.Policy_Form,
> Protection_Class = FACT_POLICY_LL.Protection_Class,Construction_Type =
> FACT_POLICY_LL.Construction_Type,
> Construction_Year = FACT_POLICY_LL.Construction_Year,Occupancy =
> FACT_POLICY_LL.Occupancy,
> RC_ACV_Bldg = FACT_POLICY_LL.RC_ACV_Bldg,Covg_Amount =
> FACT_POLICY_LL.Amt_Of_Ins,
> Ded_Amount = FACT_POLICY_LL.Ded_Amt,Liab_Amount = FACT_POLICY_LL.Liab_Amt
> from FACT_POLICY_LL
> where stage_phx_fact_policy.policy_number = fact_policy_ll.policy_number
> and stage_phx_fact_policy.policy_date_time = fact_policy_ll.policy_date_ti
me
> UPDATE STAGE_PHX_FACT_POLICY
> set Prot_Device = 'Y'
> from fact_policy_ll
> where smoke_detector = 'Y'
> and stage_phx_fact_policy.policy_number = fact_policy_ll.policy_number
> and stage_phx_fact_policy.policy_date_time = fact_policy_ll.policy_date_ti
me
>
>
> UPDATE STAGE_PHX_FACT_POLICY
> set county = FACT_POLICY_RF.County,Sub_County = FACT_POLICY_RF.Sub_County,
> Zipcode = FACT_POLICY_RF.Zipcode,Policy_Form = FACT_POLICY_RF.Policy_Form,
> Protection_Class = FACT_POLICY_RF.Protection_Class,Construction_Type =
> FACT_POLICY_RF.Construction_Type,
> Construction_Year = FACT_POLICY_RF.Construction_Year,Occupancy =
> FACT_POLICY_RF.Occupancy,
> RC_ACV_Bldg = FACT_POLICY_RF.RC_ACV_Bldg,RC_ACV_Contents =
> FACT_POLICY_RF.RC_ACV_Contents,
> Primary_Loc = FACT_POLICY_RF.Primary_Loc,Covg_Amount =
> FACT_POLICY_RF.Amt_Of_Ins,
> Ded_Amount = FACT_POLICY_RF.Ded_Amt,Liab_Amount = FACT_POLICY_RF.Liab_Amt
> from FACT_POLICY_RF
> where stage_phx_fact_policy.policy_number = fact_policy_rf.policy_number
> and stage_phx_fact_policy.policy_date_time = fact_policy_rf.policy_date_ti
me
>
>
> UPDATE STAGE_PHX_FACT_POLICY
> set county = FACT_POLICY_CF.County,Sub_County = FACT_POLICY_CF.Sub_County,
> Zipcode = FACT_POLICY_CF.Zipcode,Policy_Form = FACT_POLICY_CF.Policy_Form,
> Protection_Class = FACT_POLICY_CF.Protection_Class,Construction_Type =
> FACT_POLICY_CF.Construction_Type,
> Occupancy = FACT_POLICY_CF.Owner_Occupied,RC_ACV_Bldg =
> FACT_POLICY_CF.RC_ACV_Bldg,
> RC_ACV_Contents = FACT_POLICY_CF.RC_ACV_Contents,Primary_Loc =
> FACT_POLICY_CF.Primary_Loc,
> Covg_Amount = FACT_POLICY_CF.Amt_Of_Ins,Ded_Amount = FACT_POLICY_CF.Ded_Am
t,
> Liab_Amount = FACT_POLICY_CF.Liab_Amt
> from FACT_POLICY_CF
> where stage_phx_fact_policy.policy_number = fact_policy_cf.policy_number
> and stage_phx_fact_policy.policy_date_time = fact_policy_cf.policy_date_ti
me
>
> UPDATE STAGE_PHX_FACT_POLICY
> set Prot_Device = 'Y'
> from fact_policy_cf
> where fire_burglary_system = 'Y'
> and stage_phx_fact_policy.policy_number = fact_policy_cf.policy_number
> and stage_phx_fact_policy.policy_date_time = fact_policy_cf.policy_date_ti
me
>
>
> UPDATE STAGE_PHX_FACT_POLICY
> set county = FACT_POLICY_SMP.County,Sub_County = FACT_POLICY_SMP.Sub_Count
y,
> Zipcode = FACT_POLICY_SMP.Zipcode,Policy_Form = FACT_POLICY_SMP.Policy_For
m,
> Protection_Class = FACT_POLICY_SMP.Protection_Class,Construction_Type =
> FACT_POLICY_SMP.Construction_Type,
> Occupancy = FACT_POLICY_SMP.Owner_Occupied,RC_ACV_Bldg =
> FACT_POLICY_SMP.RC_ACV_Bldg,
> RC_ACV_Contents = FACT_POLICY_SMP.RC_ACV_Contents,Primary_Loc =
> FACT_POLICY_SMP.Primary_Loc,
> Covg_Amount = FACT_POLICY_SMP.Amt_Of_Ins,Ded_Amount = FACT_POLICY_SMP.Ded_
Amt,
> Liab_Amount = FACT_POLICY_SMP.Liab_Amt
> from FACT_POLICY_SMP
> where stage_phx_fact_policy.policy_number = fact_policy_smp.policy_number
> and stage_phx_fact_policy.policy_date_time = fact_policy_smp.policy_date_t
ime
> UPDATE STAGE_PHX_FACT_POLICY
> set Prot_Device = 'Y'
> from fact_policy_smp
> where fire_burglary_system = 'Y'
> and stage_phx_fact_policy.policy_number = fact_policy_smp.policy_number
> and stage_phx_fact_policy.policy_date_time = fact_policy_smp.policy_date_t
ime
>
> UPDATE STAGE_PHX_FACT_POLICY
> set county = FACT_POLICY_BOP.County,Sub_County = FACT_POLICY_BOP.Sub_Count
y,
> Zipcode = FACT_POLICY_BOP.Zipcode,Policy_Form = FACT_POLICY_BOP.Policy_For
m,
> Protection_Class = FACT_POLICY_BOP.Protection_Class,Construction_Type =
> FACT_POLICY_BOP.Construction_Type,
> Occupancy = FACT_POLICY_BOP.Occupancy,RC_ACV_Bldg =
> FACT_POLICY_BOP.RC_ACV_Bldg,
> RC_ACV_Contents = FACT_POLICY_BOP.RC_ACV_Contents,Primary_Loc =
> FACT_POLICY_BOP.Primary_Loc,
> Covg_Amount = FACT_POLICY_BOP.Amt_Of_Ins,Ded_Amount = FACT_POLICY_BOP.Ded_
Amt,
> Liab_Amount = FACT_POLICY_BOP.Liab_Amt
> from FACT_POLICY_BOP
> where stage_phx_fact_policy.policy_number = fact_policy_bop.policy_number
> and stage_phx_fact_policy.policy_date_time = fact_policy_bop.policy_date_t
ime
>
>
> UPDATE STAGE_PHX_FACT_POLICY
> set county = FACT_POLICY_FO.County,Sub_County = FACT_POLICY_FO.Sub_County,
> Zipcode = FACT_POLICY_FO.Zipcode,Policy_Form = FACT_POLICY_FO.Policy_Form,
> Med_Pay_Amt = FACT_POLICY_FO.Med_Pay_Amt,Protection_Class =
> FACT_POLICY_FO.Protection_Class,
> Construction_Type = FACT_POLICY_FO.Construction_Type,Occupancy =
> FACT_POLICY_FO.Occupancy,
> RC_ACV_Bldg = FACT_POLICY_FO.RC_ACV_Bldg,RC_ACV_Contents =
> FACT_POLICY_FO.RC_ACV_Contents,
> Primary_Loc = FACT_POLICY_FO.Primary_Loc,Covg_Amount =
> FACT_POLICY_FO.Amt_Of_Ins,
> Ded_Amount = FACT_POLICY_FO.Ded_Amt,Liab_Amount = FACT_POLICY_FO.Liab_Amt
> from FACT_POLICY_FO
> where stage_phx_fact_policy.policy_number = fact_policy_fo.policy_number
> and stage_phx_fact_policy.policy_date_time = fact_policy_fo.policy_date_ti
me
> UPDATE STAGE_PHX_FACT_POLICY
> set Prot_Device = 'Y'
> from fact_policy_fo
> where smoke_detector = 'Y'
> and stage_phx_fact_policy.policy_number = fact_policy_fo.policy_number
> and stage_phx_fact_policy.policy_date_time = fact_policy_fo.policy_date_ti
me
>
>
> UPDATE STAGE_PHX_FACT_POLICY
> set county = FACT_POLICY_AP.County,Sub_County = FACT_POLICY_AP.Sub_County,
> Zipcode = FACT_POLICY_AP.Zipcode,Policy_Form = FACT_POLICY_AP.Policy_Form,
> Med_Pay_Amt = FACT_POLICY_AP.Med_Pay_Amt,Protection_Class =
> FACT_POLICY_AP.Protection_Class,
> Construction_Type = FACT_POLICY_AP.Construction_Type,Occupancy =
> FACT_POLICY_AP.Occupancy,
> RC_ACV_Bldg = FACT_POLICY_AP.RC_ACV_Bldg,RC_ACV_Contents =
> FACT_POLICY_AP.RC_ACV_Contents,
> Primary_Loc = FACT_POLICY_AP.Primary_Loc,Covg_Amount =
> FACT_POLICY_AP.Amt_Of_Ins,
> Ded_Amount = FACT_POLICY_AP.Ded_Amt,Liab_Amount = FACT_POLICY_AP.Liab_Amt
> from FACT_POLICY_AP
> where stage_phx_fact_policy.policy_number = fact_policy_ap.policy_number
> and stage_phx_fact_policy.policy_date_time = fact_policy_ap.policy_date_ti
me
>
> Would a UNION work better?
> Thanks!
>sql