Partitioned View - Msg 4439 - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

Transact-SQL (2005)

Partitioned View - Msg 4439

Author

Topic

tcandido
Starting Member

1 Post

Posted - 2008-08-21 : 11:08:03

Receiving Msg 4439 for the following code

Server: Msg 4439, Level 16, State 6, Line 1
Partitioned view 'vw_FACT_ESCALATION' is not updatable because the source query contains references to partition table '[FACT_ESCALATION_200801]'.

WHERE vw_FACT_ESCALATION is a partitioned view.

INSERT INTO CDBI_ODS.DBO.vw_FACT_ESCALATION ([fiscal_period_id],...(rest of the columns))

SELECT s.[fiscal_period_id],...(rest of the columns)
FROM VW_ETL_FACT_ESCALATION_AHS s

LEFT OUTER JOIN CDBI_ODS.DBO.vw_FACT_ESCALATION d
ON d.escalation_id=s.escalation_id

WHERE d.etl_batch_id IS NULL
AND s.process_record <> 3 OPTION (MAXDOP 1)

Please confirm.
vw_FACT_ESCALATION is in both the INSERT and LEFT JOIN
INSERT INTO CDBI_ODS.DBO.vw_FACT_ESCALATION ([fiscal_period_id],...
LEFT OUTER JOIN CDBI_ODS.DBO.vw_FACT_ESCALATION d

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2008-08-29 : 10:00:05

You want to insert into a partitioned view?
"Soft" partitioned or "hard" partitioned?

E 12°55'05.63"
N 56°04'39.26"

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources