Getting errors when comparing two dbs.. but why?

fminnsfminns Posts: 3
edited May 13, 2009 11:34AM in SQL Compare Previous Versions
Hi all

I'm new to SQL and REDGATE so not the best start :-)

Why am I seeing the following errors when trying to do a compare?

Thanks

Farren






The following error message was returned from the SQL Server:

[4405] View or function 'dbo.vw_orders_journals' is not updatable because the modification affects multiple base tables.

The following SQL command caused the error:

DECLARE @pv binary(16)
DELETE FROM [dbo].[vw_xml_export] WHERE [county]='West MIdlands' AND [country]='United Kingdom' AND [add2]='' AND [town]='Birmingham' AND [Related_Mail]=1 AND [postcode]='B28 8PH' AND [email]='[email protected]' AND [lastname]='Summerscales' AND [firstname]='Ian' AND [sys_id]=47761 AND [title] IS NULL AND [establishment]='Solihull College' AND [add1]='19 Woodford Green Road' AND [jobposition]='Lecturer' AND [department]='Education'
DELETE FROM [dbo].[vw_xml_export] WHERE [county]='West Midlands' AND [country]='United Kingdom' AND [add2]='Saltley' AND [town]='Birmingham' AND [Related_Mail]=1 AND [postcode]='B8 3AG' AND [/email][email]='[email protected]' AND [lastname]='Packwood' AND [firstname]='David' AND [sys_id]=47694 AND [title] IS NULL AND [establishment]='University' AND [add1]='3 Woodlands Road' AND [jobposition]='Lecturer ' AND [department]='CLLL'
DELETE FROM [dbo].[vw_xml_export] WHERE [county]='West Midlands' AND [country]='United Kingdom' AND [add2]='' AND [town]='Birmingham' AND [Related_Mail]=1 AND [postcode]='B 90 4QH' AND [/email][email]='[email protected]' AND [lastname]='Baretto' AND [firstname]='Richard' AND [sys_id]=47276 AND [title] IS NULL AND [establishment]='Heartlands Hosptial' AND [add1]='Bordesley Green East' AND [jobposition]='Specialist Registrar' AND [department]='Immunology'
DELETE FROM [dbo].[vw_xml_export] WHERE [county]='West Midlands' AND [country]='United Kingdom' AND [add2]='University of Birmingham' AND [town]='Birmingham' AND [Related_Mail]=1 AND [postcode]='B15 2TT' AND [/email][email]='[email protected]' AND [lastname]='Coates' AND [firstname]='Juliet' AND [sys_id]=43459 AND [title]='Dr' AND [establishment]='' AND [add1]='School of Biosciences' AND [jobposition]='' AND [department]=''
DELETE FROM [dbo].[vw_xml_export] WHERE [county]='West Midlands' AND [country]='United Kingdom' AND [add2]='' AND [town]='Birmingham' AND [Related_Mail]=1 AND [postcode]='B4 7ET' AND [/email][email]='[email protected]' AND [lastname]='Leseure' AND [firstname]='Michel' AND [sys_id]=42589 AND [title]='Dr' AND [establishment]='Aston Business School' AND [add1]='Aston Triangle' AND [jobposition]='Lecturer' AND [department]='OIM'
DELETE FROM [dbo].[vw_xml_export] WHERE [county]='West Midlands' AND [country]='United Kingdom' AND [add2]='' AND [town]='Walmley' AND [Related_Mail]=1 AND [postcode]='B76 2BH' AND [/email][email]='[email protected]' AND [lastname]='Lowell' AND [firstname]='Brigit' AND [sys_id]=45936 AND [title] IS NULL AND [establishment]='University of Wolverhampton' AND [add1]='37 Swale Road' AND [jobposition]='Student' AND [department]=''
DELETE FROM [dbo].[vw_xml_export] WHERE [county]='West Midlands' AND [country]='United Kingdom' AND [add2]='' AND [town]='Birmingham' AND [Related_Mail]=1 AND [postcode]='B15 2TT' AND [/email][email]='[email protected]' AND [lastname]='Griffiths' AND [firstname]='Helen' AND [sys_id]=46978 AND [title] IS NULL AND [establishment]='University of Birmingham' AND [add1]='Edgbaston' AND [jobposition]='PhD student' AND [department]='Geography'
DELETE FROM [dbo].[vw_xml_export] WHERE [county]='West midlands' AND [country]='United Kingdom' AND [add2]='Vincent Drive' AND [town]='Birmingham' AND [Related_Mail]=1 AND [postcode]='B15 2TT' AND [/email][email]='[email protected]' AND [lastname]='Tomlinson' AND [firstname]='Claire' AND [sys_id]=47115 AND [title] IS NULL AND [establishment]='The University of Birmingham' AND [add1]='The Medical school' AND [jobposition]='PhD Student' AND [department]='Physiology'
DELETE FROM [dbo].[vw_xml_export] WHERE [county]='West midlands' AND [country]='United Kingdom' AND [add2]='Molinuex Street' AND [town]='Wolverhampton' AND [Related_Mail]=1 AND [postcode]='wv1 1sb' AND [/email][email]='[email protected]' AND [lastname]='Carvalho' AND [firstname]='Sally' AND [sys_id]=47088 AND [title] IS NULL AND [establishment]='University of Wolverhampton' AND [add1]='MH building, Mary Seacole Building' AND [jobposition]='Senior lecturer' AND [department]='School of health'
DELETE FROM [dbo].[vw_xml_export] WHERE [county]='West Midlands' AND [country]='United Kingdom' AND [add2]='' AND [town]='Coventry' AND [Related_Mail]=1 AND [postcode]='CV1 5FB' AND [/email][email]='[email protected]' AND [lastname]='Maye' AND [firstname]='Damian' AND [sys_id]=45043 AND [title]='Dr' AND [establishment]='Prioiry Street' AND [add1]='Prioiry Street' AND [jobposition]='Lecturer' AND [department]='Geography'
DELETE FROM [dbo].[vw_xml_export] WHERE [county]='West Midlands' AND [country]='United Kingdom' AND [add2]='' AND [town]='Sutton Coldfield' AND [Related_Mail]=1 AND [postcode]='B75 7DX' AND [/email][email]='[email protected]' AND [lastname]='Martin' AND [firstname]='Simone' AND [sys_id]=45281 AND [title]='Miss' AND [establishment]='' AND [add1]='61 Reddicap Heath Road' AND [jobposition]='' AND [department]=''
DELETE FROM [dbo].[vw_xml_export] WHERE [county]='West Midlands' AND [country]='United Kingdom' AND [add2]='' AND [town]='Wolverhampton' AND [Related_Mail]=1 AND [postcode]='WV1 1SB' AND [/email][email]='[email protected]' AND [lastname]='Williams' AND [firstname]='Sarah' AND [sys_id]=44534 AND [title]='Mrs' AND [establishment]='University of Wolverhampton' AND [add1]='Stafford Street' AND [jobposition]='Snr Lecturer Public Relations' AND [department]='HLSS'
DELETE FROM [dbo].[vw_xml_export] WHERE [county]='West Midlands' AND [country]='United Kingdom' AND [add2]='Station Square' AND [town]='Coventry' AND [Related_Mail]=1 AND [postcode]='CV1 2FL' AND [/email][email]='[email protected]' AND [lastname]='Goodchild' AND [firstname]='Lauren' AND [sys_id]=44713 AND [title]='' AND [establishment]='' AND [add1]='4 Copthall House' AND [jobposition]='Information Officer' AND [department]=''
DELETE FROM [dbo].[vw_xml_export] WHERE [county]='West MIdlands' AND [country]='United Kingdom' AND [add2]='Brierley Hill' AND [town]='Dudley' AND [Related_Mail]=1 AND [postcode]='DY5 1RE' AND [/email][email]='[email protected]' AND [lastname]='Shakles' AND [firstname]='Helen' AND [sys_id]=38368 AND [title]='Miss' AND [establishment]='The Warehouse' AND [add1]='cottage street' AND [jobposition]='Drug Practitioner' AND [department]='primary care/core service'
DELETE FROM [dbo].[vw_xml_export] WHERE [county]='West Midlands' AND [country]='United Kingdom' AND [add2]='Sheldon' AND [town]='Birmingham' AND [Related_Mail]=1 AND [postcode]='B26 3AY' AND [/email][email]='[email protected]' AND [lastname]='Kenny' AND [firstname]='Sarah' AND [sys_id]=37247 AND [title]='Mrs' AND [establishment]='Construction Industry Publications' AND [add1]='60 New Coventry Road' AND [jobposition]='Marketing Executive' AND [department]=''
DELETE FROM [dbo].[vw_xml_export] WHERE [county]='West Midlands' AND [country]='United Kingdom' AND [add2]='Bartley Green' AND [town]='Birmingham' AND [Related_Mail]=1 AND [postcode]='B32 3NT' AND [/email][email]='[email protected]' AND [lastname]='McGillivray' AND [firstname]='Gillian' AND [sys_id]=36465 AND [title]='Mrs' AND [establishment]='Newman College of HE' AND [add1]='Genners Lane' AND [jobposition]='senior lecturer' AND [department]='Early years'
DELETE FROM [dbo].[vw_xml_export] WHERE [county]='West Midlands' AND [country]='United Kingdom' AND [add2]='Priory St' AND [town]='Coventry' AND [Related_Mail]=1 AND [postcode]='CV1 5FB' AND [/email][email]='[email protected]' AND [lastname]='Canning' AND [firstname]='Barbara' AND [sys_id]=36668 AND [title]='Mrs' AND [establishment]='Coventry University' AND [add1]='Richard Crossman Building' AND [jobposition]='Senior Lecturer' AND [department]='SHSS'
DELETE FROM [dbo].[vw_xml_export] WHERE [county]='WEST MIDLANDS' AND [country]='United Kingdom' AND [add2]='EDGBASTON' AND [town]='BIRMINGHAM' AND [Related_Mail]=1 AND [postcode]='B15 2RT' AND [/email][email]='[email protected]' AND [lastname]='KOSTIKOU' AND [firstname]='THEODORA' AND [sys_id]=35672 AND [title]='Mrs' AND [establishment]='' AND [add1]='40 EDGBASTON PARK RD' AND [jobposition]='POSTGRADUATE' AND [department]='HEALTH SERVICES MANAGEMENT CENTRE'
DELETE FROM [dbo].[vw_xml_export] WHERE [county]='West Midlands' AND [country]='United Kingdom' AND [add2]='Perry Barr' AND [town]='Birmingham' AND [Related_Mail]=1 AND [postcode]='B67 5DS' AND [/email][email]='[email protected]' AND [lastname]='Tipping' AND [firstname]='Steve' AND [sys_id]=35754 AND [title]='Mr' AND [establishment]='University of Central England' AND [add1]='Wellhead Lane' AND [jobposition]='Senior Lecturer' AND [department]='Health & Policy Studies'
DELETE FROM [dbo].[vw_xml_export] WHERE [county]='West Midlands' AND [country]='United Kingdom' AND [add2]='' AND [town]='Birmingham' AND [Related_Mail]=1 AND [postcode]='' AND [/email][email]='[email protected]' AND [lastname]='McKenzie' AND [firstname]='Dulcie' AND [sys_id]=35468 AND [title]='Mrs ' AND [establishment]='JMC' AND [add1]='slade Road' AND [jobposition]='Lecturer' AND [department]='Care'
DELETE FROM [dbo].[vw_xml_export] WHERE [county]='West Midlands' AND [country]='United Kingdom' AND [add2]='Edgbaston' AND [town]='Birmingham' AND [Related_Mail]=1 AND [postcode]='B15 2TT ' AND [/email][email]='[email protected]' AND [lastname]='Walsh' AND [firstname]='Martin' AND [sys_id]=35254 AND [title]='Dr' AND [establishment]='BHAM UNIVERSITY' AND [add1]='52 Pritchards Road' AND [jobposition]='Lecturer' AND [department]='Health Science'
DELETE FROM [dbo].[vw_xml_export] WHERE [county]='West Midlands' AND [country]='United Kingdom' AND [add2]='Erdington' AND [town]='Birmingham' AND [Related_Mail]=1 AND [postcode]='B24 8RD' AND [/email][email]='[email protected]' AND [lastname]='Aldred' AND [firstname]='Joe' AND [sys_id]=33773 AND [title]='Revd' AND [establishment]='CTBI' AND [add1]='269 Kingsbury Rd' AND [jobposition]='Ecumeinist' AND [department]='MECA'
DELETE FROM [dbo].[vw_xml_export] WHERE [county]='West Midlands' AND [country]='United Kingdom' AND [add2]='University of Warwick' AND [town]='Coventry' AND [Related_Mail]=1 AND [postcode]='CV4 7AL' AND [/email][email]='[email protected]' AND [lastname]='Barnes' AND [firstname]='Tina' AND [sys_id]=34051 AND [title]='Dr' AND [establishment]='University of Warwick' AND [add1]='International Manufacturing Centre' AND [jobposition]='Senior Research Fellow' AND [department]='Engineering'
DELETE FROM [dbo].[vw_xml_export] WHERE [county]='west midlands' AND [country]='United Kingdom' AND [add2]='stoke' AND [town]='coventry' AND [Related_Mail]=1 AND [postcode]='cv31bh' AND [/email][email]='[email protected]' AND [lastname]='kaur' AND [firstname]='kalwant' AND [sys_id]=31900 AND [title]='ms' AND [establishment]='' AND [add1]='206 humber rd' AND [jobposition]='student nurse' AND [department]=''
DELETE FROM [dbo].[vw_xml_export] WHERE [county]='west midlands' AND [country]='England' AND [add2]='' AND [town]='birmingham' AND [Related_Mail]=1 AND [postcode]='b26 3ar' AND [/email][email]='[email protected]' AND [lastname]='phillips' AND [firstname]='mark' AND [sys_id]=32545 AND [title]='DR' AND [establishment]='' AND [add1]='49 beechmore road' AND [jobposition]='' AND [department]=''
DELETE FROM [dbo].[vw_xml_export] WHERE [county]='West Midlands' AND [country]='UNITED KINGDOM' AND [add2]='Selly Oak' AND [town]='Birmingham ' AND [Related_Mail]=1 AND [postcode]='B296LQ' AND [/email][email]='[email protected]' AND [lastname]='Goodacre' AND [firstname]='Mark' AND [sys_id]=28915 AND [title]='Dr' AND [establishment]='University of Birmingham' AND [add1]='Elmfield House' AND [jobposition]='Senior Lecturer' AND [department]='Theology'
DELETE FROM [dbo].[vw_xml_export] WHERE [county]='West Midlands' AND [country]='United Kingdom' AND [add2]='Wulfruna Street' AND [town]='Wolverhampton' AND [Related_Mail]=1 AND [postcode]='WV1 1SB' AND [/email][email]='[email protected]' AND [lastname]='Sembi' AND [firstname]='Pritpal' AND [sys_id]=10705 AND [title]='Mr' AND [establishment]='Room MC333 - HLSS' AND [add1]='Room MC333 - HLSS' AND [jobposition]='Lecturer' AND [department]='Film Studies'
DELETE FROM [dbo].[vw_xml_export] WHERE [county]='West Midlands' AND [country]='United Kingdom' AND [add2]='Blythe Valley Park' AND [town]='Solihull' AND [Related_Mail]=1 AND [postcode]='B90 8AE' AND [/email][email]='[email protected]' AND [lastname]='Relves' AND [firstname]='Verity' AND [sys_id]=15722 AND [title]='Miss' AND [establishment]='Arup' AND [add1]='Arup Campus, Blythe Gate' AND [jobposition]='Librarian' AND [department]='Library'
DELETE FROM [dbo].[vw_xml_export] WHERE [county]='West Midlands' AND [country]='United Kingdom' AND [add2]='' AND [town]='Walsall' AND [Related_Mail]=1 AND [postcode]='WS1 2BX' AND [/email][email]='[email protected]' AND [lastname]='Bowskill' AND [firstname]='Sarah' AND [sys_id]=30191 AND [title]='Ms' AND [establishment]='University of Manchester' AND [add1]='9, The Crescent' AND [jobposition]='PhD Student' AND [department]='Spanish'
DELETE FROM [dbo].[vw_xml_export] WHERE [county]='WEST MIDLANDS' AND [country]='United Kingdom' AND [add2]='SHIRLEY' AND [town]='SOLIHULL' AND [Related_Mail]=1 AND [postcode]='B90 4DQ' AND [/email][email]='[email protected]' AND [lastname]='SENGUPTA-GIRIDHARAN' AND [firstname]='RINKU' AND [sys_id]=30887 AND [title]='DR' AND [establishment]='WORDESLEY HOSPITAL' AND [add1]='65 TANWORTH LANE' AND [jobposition]='SPR' AND [department]='O AND G'
DELETE FROM [dbo].[vw_xml_export] WHERE [county]='Western Australia' AND [country]='Australia' AND [add2]='Crawley' AND [town]='Perth' AND [Related_Mail]=1 AND [postcode]='6009' AND [/email][email]='[email protected]' AND [lastname]='Atherley' AND [firstname]='Kim' AND [sys_id]=50863 AND [title]='Mrs' AND [establishment]='The University of Western Australia' AND [add1]='35 Stirling Highway' AND [jobposition]='PhD Candidate' AND [department]='Institute for Regional Development'
DELETE FROM [dbo].[vw_xml_export] WHERE [county]='Western Australia' AND [country]='Australia' AND [add2]='' AND [town]='Greenwood' AND [Related_Mail]=1 AND [postcode]='6024' AND [/email][email]='[email protected]' AND [lastname]='Kirkham' AND [firstname]='Shelley' AND [sys_id]=50929 AND [title]='Ms' AND [establishment]='ECU' AND [add1]='10 Sherington Road' AND [jobposition]='Social Work Student' AND [department]=''
DELETE FROM [dbo].[vw_xml_export] WHERE [county]='ZH' AND [country]='Switzerland' AND [add2]='' AND [town]='Zürich' AND [Related_Mail]=1 AND [postcode]='8057' AND [/email][email]='[email protected]' AND [lastname]='Wacker' AND [firstname]='Luca' AND [sys_id]=42565 AND [title]='Mr' AND [establishment]='' AND [add1]='Winterthurerstr. 190' AND [jobposition]='' AND [department]=''
SET ROWCOUNT 0

-- Delete 85217 rows from [dbo].[vw_orders_journals] with non-unique comparison key
SET ROWCOUNT 1
EXEC(N'DELETE FROM [dbo].[vw_orders_journals] WHERE [isn_Advert_Contact]=''ANDERSON , ALF'' AND [isn_Active_Flag]=1 AND [isn_Media]=''UNKNOWN'' AND [isn_Author_Offprints_Contact]=''TBC'' AND [isn_jnl_Status]=''Transferring to Boston for 2006 '' AND [isn_Division_Code]=''M '' AND [isn_Disable_Default_Sample_Issue]=0 AND [isn_Commodity_Code]=''JL'' AND [isn_Discipline_Code]=-9999 AND [isn_Managing_Ed_ID]=1179 AND [isn_Volumes_Per_Year]=0 AND [isn_Marketing_Mgr_ID]=1118 AND [isn_Title_Support_ID]=1458 AND [isn_Import]=0 AND [isn_Customer_Services_Location]=''Oxford'' AND [isn_Prod_Office]=''E'' AND [isn_InSynergy]=1 AND [isn_Previous_Imprint]=''MKS'' AND [isn_Title_Support]=''FONTAINE , ALICIA'' AND [isn_Managing_Ed]=''BIXBY , HILLARY'' AND [isn_Production_Ed]=''JOHNSTON , CAROLYN'' AND [isn_Marketing_Mgr]=''MATHELUS , SHARON'' AND [isn_Fellowship]=0 AND [isn_Society]=0 AND [isn_Activate_Online_ISSN]=0 AND [isn_handle_membership]=0 AND [isn_Indiv_Access]=0 AND [isn_AmendedDate]=''20090122 18:12:47.350'' AND [isn_CreatedBy]=''TWilson'' AND [isn_Sample_Copy_In_Print]=0 AND [isn_AmendedBy]=''afontaine'' AND [isn_CreatedDate]=''20011005 08:22:12.000'' AND [isn_Society_Name]='''' AND [isn_On_Web]=1 AND [isn_Market_Check]=1 AND [isn_ECQC_Contact_ID]=1344 AND [isn_ECQC_Contact]=''TEMP , PSD'' AND [isn_EEO]=''Mscript Central 3.x'' AND [isn_Journal_Email]=''[email protected]'' AND [isn_Commercial_Offprints_Contact_ID]=1343 AND [isn_Commercial_Offprints_Contact]=''HURWITCH , KAREN'' AND [isn_In_Ovid]=1 AND [isn_Back_Issue_Agent]=''<a href="http://www.periodicals.com/blackwell.html">Periodicals Service Co</a>'' AND [isn_Author_Offprints_Contact_ID]=-9999 AND [isn_Advert_Contact_ID]=662 AND [isn_Production_Ed_ID]=557 AND [isn_Supplement_Online_ISSN]=''1600-5538'' AND [isn_Offprints_Contact_ID]=784 AND [isn_Offprints_Available]=1 AND [isn_Membership_Contact_ID]=-9999 AND [isn_SocURL]='''' AND [isn_Membership_Contact]=''TBC'' AND [isn_JSTOR_Notes]='''' AND [isn_In_JSTOR]=0 AND [isn_In_Medicus]=1 AND [isn_JSTOR_Moving_Wall]='''' AND [isn_US_Postal_Permit]=1 AND [isn_Electronic_Version]=1 AND [Related_Email]=N''0'' AND [Related_Phone]=N''0'' AND [FirstName]=N''William'' AND [Related_Transfer]=N''0'' AND [Related_Mail]=N''0'' AND [Active]=1 AND [Related]=N''0'' AND [DateLastEdited]=''20051212 08:49:10.260'' AND [DateCreated]=''20021126 16:05:04.340'' AND [Title]=N''Clinical Transplantation'' AND [ref]=''0902-0063'' AND [PriceRef]=N''$290.00'' AND [PriceDef]=N''Annual Subscription:2003'' AND [EmailDoNotWish] IS NULL AND [AddressLine2]=N'''' AND [LastName]=N''LeFor, Ph.D.'' AND [EmailSubscription] IS NULL AND [Profession]=N''None'' AND [Establishment]=N''LifeLink Foundation,Inc.'' AND [Department]=N''Transplantation Immunology Lab '' AND [Street]=N''409 Bayshore Blvd.'' AND [Position]=N'''' AND [CourtesyTitle]=N''Director'' AND [Typeof]=1 AND [Sys_Id]=15150 AND [Name]=N''William/LeFor, Ph.D.'' AND [OrderRef]=''BJ024541 '' AND [/email][EMail]=N''[email protected]'' AND [FaxNo]=N'''' AND [NoMail]=N''0'' AND [Processed]=1 AND [TelNo]=N'''' AND [State]=N''Florida'' AND [Town]=N''Tampa'' AND [Country]=N''USA'' AND [PostCode]=N''33606'' AND [isn_Online_ISSN]=''1399-0012'' AND [isn_Print_ISSN]=''0902-0063'' AND [isn_Supplement_ISBN]='''' AND [isn_Supplement_ISSN]=''1399-6738'' AND [isn_ISSN_ID]=394 AND [extra_data3] IS NULL AND [extra_data2] IS NULL AND [ORIG]=''BB'' AND [discount] IS NULL AND [isn_SubTitle]='''' AND [isn_Title_Lead_Word]='''' AND [isn_OnLineEarly]=1 AND [isn_Book_Reviews]=0 AND [isn_Title]=''Clinical Transplantation'' AND [isn_Jnl_Ranking]=''M2'' AND [isn_Subject_Team]=N''TRA'' AND [isn_BPL_BPI]=''BB'' AND [isn_External_Acronym]=''CTR'' AND [CardType]=N''Amex'' AND [OrderType]=2 AND [CardVerification] IS NULL AND [CardNumber]=N'' '' AND [PaymentType]=3 AND [PriceRegion]=N''The Americas*, The Americas* '' AND [PriceType]=N''Reduced Rate: Print + Online***'' AND [Price]=N''$290.00 '' AND [PriceVolumn] IS NULL AND [CustomerNo]=N''21579270'' AND [VatNumber]=N'' '' AND [extra_data1] IS NULL AND [CustomerName]=N'''' AND [VatReg]=0 AND [IssueNumber] IS NULL AND [ExpiryDate]=N''2/2003 '' AND [CardHolderAdd]=N'''' AND [CardHolderName]=N''''')
EXEC(N'DELETE FROM [dbo].[vw_orders_journals] WHERE [isn_Advert_Contact]=''ANDERSON , ALF'' AND [isn_Active_Flag]=1 AND [isn_Media]=''UNKNOWN'' AND [isn_Author_Offprints_Contact]=''TBC'' AND [isn_jnl_Status]=''Transferring to Boston for 2006 '' AND [isn_Division_Code]=''M '' AND [isn_Disable_Default_Sample_Issue]=0 AND [isn_Commodity_Code]=''JL'' AND [isn_Discipline_Code]=-9999 AND [isn_Managing_Ed_ID]=1179 AND [isn_Volumes_Per_Year]=0 AND [isn_Marketing_Mgr_ID]=1118 AND [isn_Title_Support_ID]=1458 AND [isn_Import]=0 AND [isn_Customer_Services_Location]=''Oxford'' AND [isn_Prod_Office]=''E'' AND [isn_InSynergy]=1 AND [isn_Previous_Imprint]=''MKS'' AND [isn_Title_Support]=''FONTAINE , ALICIA'' AND [isn_Managing_Ed]=''BIXBY , HILLARY'' AND [isn_Production_Ed]=''JOHNSTON , CAROLYN'' AND [isn_Marketing_Mgr]=''MATHELUS , SHARON'' AND [isn_Fellowship]=0 AND [isn_Society]=0 AND [isn_Activate_Online_ISSN]=0 AND [isn_handle_membership]=0 AND [isn_Indiv_Access]=0 AND [isn_AmendedDate]=''20090122 18:12:47.350'' AND [isn_CreatedBy]=''TWilson'' AND [isn_Sample_Copy_In_Print]=0 AND [isn_AmendedBy]=''afontaine'' AND [isn_CreatedDate]=''20011005 08:22:12.000'' AND [isn_Society_Name]='''' AND [isn_On_Web]=1 AND [isn_Market_Check]=1 AND [isn_ECQC_Contact_ID]=1344 AND [isn_ECQC_Contact]=''TEMP , PSD'' AND [isn_EEO]=''Mscript Central 3.x'' AND [isn_Journal_Email]=''[email protected]'' AND [isn_Commercial_Offprints_Contact_ID]=1343 AND [isn_Commercial_Offprints_Contact]=''HURWITCH , KAREN'' AND [isn_In_Ovid]=1 AND [isn_Back_Issue_Agent]=''<a href="http://www.periodicals.com/blackwell.html">Periodicals Service Co</a>'' AND [isn_Author_Offprints_Contact_ID]=-9999 AND [isn_Advert_Contact_ID]=662 AND [isn_Production_Ed_ID]=557 AND [isn_Supplement_Online_ISSN]=''1600-5538'' AND [isn_Offprints_Contact_ID]=784 AND [isn_Offprints_Available]=1 AND [isn_Membership_Contact_ID]=-9999 AND [isn_SocURL]='''' AND [isn_Membership_Contact]=''TBC'' AND [isn_JSTOR_Notes]='''' AND [isn_In_JSTOR]=0 AND [isn_In_Medicus]=1 AND [isn_JSTOR_Moving_Wall]='''' AND [isn_US_Postal_Permit]=1 AND [isn_Electronic_Version]=1 AND [Related_Email]=N''0'' AND [Related_Phone]=N''0'' AND [FirstName]=N''jacob'' AND [Related_Transfer]=N''0'' AND [Related_Mail]=N''0'' AND [Active]=1 AND [Related]=N''0'' AND [DateLastEdited]=''20051212 08:47:04.353'' AND [DateCreated]=''20030108 21:08:18.793'' AND [Title]=N''Clinical Transplantation'' AND [ref]=''0902-0063'' AND [PriceRef]=N''£191.00'' AND [PriceDef]=N''Annual Subscription:2003'' AND [EmailDoNotWish] IS NULL AND [AddressLine2]=N'''' AND [LastName]=N''Homan van der Heide'' AND [EmailSubscription] IS NULL AND [Profession]=N''Unwaged/volunteer'' AND [Establishment]=N'''' AND [Department]=N'''' AND [Street]=N''Jachtlaan 36'' AND [Position]=N'''' AND [CourtesyTitle]=N''MD'' AND [Typeof]=1 AND [Sys_Id]=19422 AND [Name]=N''jacob/Homan van der Heide'' AND [OrderRef]=''BJ028813 '' AND [/email][EMail]=N''[email protected] .nl'' AND [FaxNo]=N'''' AND [NoMail]=N''0'' AND [Processed]=1 AND [TelNo]=N'''' AND [State]=N''GN'' AND [Town]=N''Haren'' AND [Country]=N''NETHERLANDS'' AND [PostCode]=N''9751 BV'' AND [isn_Online_ISSN]=''1399-0012'' AND [isn_Print_ISSN]=''0902-0063'' AND [isn_Supplement_ISBN]='''' AND [isn_Supplement_ISSN]=''1399-6738'' AND [isn_ISSN_ID]=394 AND [extra_data3] IS NULL AND [extra_data2] IS NULL AND [ORIG]=''BB'' AND [discount] IS NULL AND [isn_SubTitle]='''' AND [isn_Title_Lead_Word]='''' AND [isn_OnLineEarly]=1 AND [isn_Book_Reviews]=0 AND [isn_Title]=''Clinical Transplantation'' AND [isn_Jnl_Ranking]=''M2'' AND [isn_Subject_Team]=N''TRA'' AND [isn_BPL_BPI]=''BB'' AND [isn_External_Acronym]=''CTR'' AND [CardType]=N''Amex'' AND [OrderType]=1 AND [CardVerification] IS NULL AND [CardNumber]=N'' '' AND [PaymentType]=3 AND [PriceRegion]=N''Europe**, Europe** '' AND [PriceType]=N''Reduced Rate: Print + Online***'' AND [Price]=N''£191.00 '' AND [PriceVolumn] IS NULL AND [CustomerNo]=N'''' AND [VatNumber]=N'' '' AND [extra_data1] IS NULL AND [CustomerName]=N'''' AND [VatReg]=0 AND [IssueNumber] IS NULL AND [ExpiryDate]=N''4/2008 '' AND [CardHolderAdd]=N'''' AND [CardHolderName]=N''''')
EXEC(N'DELETE FROM [dbo].[vw_orders_journals] WHERE [isn_Advert_Contact]=''ANDERSON , ALF'' AND [isn_Active_Flag]=1 AND [isn_Media]=''UNKNOWN'' AND [isn_Author_Offprints_Contact]=''TBC'' AND [isn_jnl_Status]=''Transferring to Boston for 2006 '' AND [isn_Division_Code]=''M '' AND [isn_Disable_Default_Sample_Issue]=0 AND [isn_Commodity_Code]=''JL'' AND [isn_Discipline_Code]=-9999 AND [isn_Managing_Ed_ID]=1179 AND [isn_Volumes_Per_Year]=0 AND [isn_Marketing_Mgr_ID]=1118 AND [isn_Title_Support_ID]=1458 AND [isn_Import]=0 AND [isn_Customer_Services_Location]=''Oxford'' AND [isn_Prod_Office]=''E'' AND [isn_InSynergy]=1 AND [isn_Previous_Imprint]=''MKS'' AND [isn_Title_Support]=''FONTAINE , ALICIA'' AND [isn_Managing_Ed]=''BIXBY , HILLARY'' AND [isn_Production_Ed]=''JOHNSTON , CAROLYN'' AND [isn_Marketing_Mgr]=''MATHELUS , SHARON'' AND [isn_Fellowship]=0 AND [isn_Society]=0 AND [isn_Activate_Online_ISSN]=0 AND [isn_handle_membership]=0 AND [isn_Indiv_Access]=0 AND [isn_AmendedDate]=''20090122 18:12:47.350'' AND [isn_CreatedBy]=''TWilson'' AND [isn_Sample_Copy_In_Print]=0 AND [isn_AmendedBy]=''afontaine'' AND [isn_CreatedDate]=''20011005 08:22:12.000'' AND [isn_Society_Name]='''' AND [isn_On_Web]=1 AND [isn_Market_Check]=1 AND [isn_ECQC_Contact_ID]=1344 AND [isn_ECQC_Contact]=''TEMP , PSD'' AND [isn_EEO]=''Mscript Central 3.x'' AND [isn_Journal_Email]=''[email protected]'' AND [isn_Commercial_Offprints_Contact_ID]=1343 AND [isn_Commercial_Offprints_Contact]=''HURWITCH , KAREN'' AND [isn_In_Ovid]=1 AND [isn_Back_Issue_Agent]=''<a href="http://www.periodicals.com/blackwell.html">Periodicals Service Co</a>'' AND [isn_Author_Offprints_Contact_ID]=-9999 AND [isn_Advert_Contact_ID]=662 AND [isn_Production_Ed_ID]=557 AND [isn_Supplement_Online_ISSN]=''1600-5538'' AND [isn_Offprints_Contact_ID]=784 AND [isn_Offprints_Available]=1 AND [isn_Membership_Contact_ID]=-9999 AND [isn_SocURL]='''' AND [isn_Membership_Contact]=''TBC'' AND [isn_JSTOR_Notes]='''' AND [isn_In_JSTOR]=0 AND [isn_In_Medicus]=1 AND [isn_JSTOR_Moving_Wall]='''' AND [isn_US_Postal_Permit]=1 AND [isn_Electronic_Version]=1 AND [Related_Email]=N''1'' AND [Related_Phone]=N''0'' AND [FirstName]=N''Richard'' AND [Related_Transfer]=N''0'' AND [Related_Mail]=N''1'' AND [Active]=1 AND [Related]=N''0'' AND [DateLastEdited]=''20051212 08:47:04.353'' AND [DateCreated]=''20030127 20:54:03.653'' AND [Title]=N''Clinical Transplantation'' AND [ref]=''0902-0063'' AND [PriceRef]=N''$290.00'' AND [PriceDef]=N''Annual Subscription:2003'' AND [EmailDoNotWish] IS NULL AND [AddressLine2]=N''MN010-E169'' AND [LastName]=N''Migliori, M.D.'' AND [EmailSubscription]=N''1'' AND [Profession]=N''Practitioner/professional/clinician'' AND [Establishment]=N''Transplantation'' AND [Department]=N''United Resource Networks'' AND [Street]=N''PO Box 1459'' AND [Position]=N'''' AND [CourtesyTitle]=N''Chief Executive Officer'' AND [Typeof]=1 AND [Sys_Id]=21130 AND [Name]=N''Richard/Migliori, M.D.'' AND [OrderRef]=''BJ030521 '' AND [/email][EMail]=N''[email protected]'' AND [FaxNo]=N''763-797-2600'' AND [NoMail]=N''0'' AND [Processed]=1 AND [TelNo]=N''763-797-4998'' AND [State]=N''MN'' AND [Town]=N''Minneapolis'' AND [Country]=N''USA'' AND [PostCode]=N''55440-1459'' AND [isn_Online_ISSN]=''1399-0012'' AND [isn_Print_ISSN]=''0902-0063'' AND [isn_Supplement_ISBN]='''' AND [isn_Supplement_ISSN]=''1399-6738'' AND [isn_ISSN_ID]=394 AND [extra_data3] IS NULL AND [extra_data2] IS NULL AND [ORIG]=''BB'' AND [discount] IS NULL AND [isn_SubTitle]='''' AND [isn_Title_Lead_Word]='''' AND [isn_OnLineEarly]=1 AND [isn_Book_Reviews]=0 AND [isn_Title]=''Clinical Transplantation'' AND [isn_Jnl_Ranking]=''M2'' AND [isn_Subject_Team]=N''TRA'' AND [isn_BPL_BPI]=''BB'' AND [isn_External_Acronym]=''CTR'' AND [CardType]=N''MasterCard'' AND [OrderType]=1 AND [CardVerification] IS NULL AND [CardNumber]=N'' '' AND [PaymentType]=3 AND [PriceRegion]=N''The Americas*, The Americas* '' AND [PriceType]=N''Reduced Rate: Print + Online***'' AND [Price]=N''$290.00 '' AND [PriceVolumn] IS NULL AND [CustomerNo]=N'''' AND [VatNumber]=N'' '' AND [extra_data1] IS NULL AND [CustomerName]=N'''' AND [VatReg]=0 AND [IssueNumber] IS NULL AND [ExpiryDate]=N''10/2003 '' AND [CardHolderAdd]=N'''' AND [CardHolderName]=N''Vicky J Barragan''')
EXEC(N'DELETE FROM [dbo].[vw_orders_journals] WHERE [isn_Advert_Contact]=''ANDERSON , ALF'' AND [isn_Active_Flag]=1 AND [isn_Media]=''UNKNOWN'' AND [isn_Author_Offprints_Contact]=''TBC'' AND [isn_jnl_Status]=''Transferring to Boston for 2006 '' AND [isn_Division_Code]=''M '' AND [isn_Disable_Default_Sample_Issue]=0 AND [isn_Commodity_Code]=''JL'' AND [isn_Discipline_Code]=-9999 AND [isn_Managing_Ed_ID]=1179 AND [isn_Volumes_Per_Year]=0 AND [isn_Marketing_Mgr_ID]=1118 AND [isn_Title_Support_ID]=1458 AND [isn_Import]=0 AND [isn_Customer_Services_Location]=''Oxford'' AND [isn_Prod_Office]=''E'' AND [isn_InSynergy]=1 AND [isn_Previous_Imprint]=''MKS'' AND [isn_Title_Support]=''FONTAINE , ALICIA'' AND [isn_Managing_Ed]=''BIXBY , HILLARY'' AND [isn_Production_Ed]=''JOHNSTON , CAROLYN'' AND [isn_Marketing_Mgr]=''MATHELUS , SHARON'' AND [isn_Fellowship]=0 AND [isn_Society]=0 AND [isn_Activate_Online_ISSN]=0 AND [isn_handle_membership]=0 AND [isn_Indiv_Access]=0 AND [isn_AmendedDate]=''20090122 18:12:47.350'' AND [isn_CreatedBy]=''TWilson'' AND [isn_Sample_Copy_In_Print]=0 AND [isn_AmendedBy]=''afontaine'' AND [isn_CreatedDate]=''20011005 08:22:12.000'' AND [isn_Society_Name]='''' AND [isn_On_Web]=1 AND [isn_Market_Check]=1 AND [isn_ECQC_Contact_ID]=1344 AND [isn_ECQC_Contact]=''TEMP , PSD'' AND [isn_EEO]=''Mscript Central 3.x'' AND [isn_Journal_Email]=''[email protected]'' AND [isn_Commercial_Offprints_Contact_ID]=1343 AND [isn_Commercial_Offprints_Contact]=''HURWITCH , KAREN'' AND [isn_In_Ovid]=1 AND [isn_Back_Issue_Agent]=''<a href="http://www.periodicals.com/blackwell.html">Periodicals Service Co</a>'' AND [isn_Author_Offprints_Contact_ID]=-9999 AND [isn_Advert_Contact_ID]=662 AND [isn_Production_Ed_ID]=557 AND [isn_Supplement_Online_ISSN]=''1600-5538'' AND [isn_Offprints_Contact_ID]=784 AND [isn_Offprints_Available]=1 AND [isn_Membership_Contact_ID]=-9999 AND [isn_SocURL]='''' AND [isn_Membership_Contact]=''TBC'' AND [isn_JSTOR_Notes]='''' AND [isn_In_JSTOR]=0 AND [isn_In_Medicus]=1 AND [isn_JSTOR_Moving_Wall]='''' AND [isn_US_Postal_Permit]=1 AND [isn_Electronic_Version]=1 AND [Related_Email]=N''0'' AND [Related_Phone]=N''0'' AND [FirstName]=N''anastasio'' AND [Related_Transfer]=N''0'' AND [Related_Mail]=N''0'' AND [Active]=1 AND [Related]=N''0'' AND [DateLastEdited]=''20051212 08:47:04.353'' AND [DateCreated]=''20030206 18:34:08.353'' AND [Title]=N''Clinical Transplantation'' AND [ref]=''0902-0063'' AND [PriceRef]=N''$290.00'' AND [PriceDef]=N''Annual Subscription:2003'' AND [EmailDoNotWish] IS NULL AND [AddressLine2]=N'''' AND [LastName]=N''salazar'' AND [EmailSubscription]=N''1'' AND [Profession]=N''Academic/Professor'' AND [Establishment]=N''University of Calgary'' AND [Department]=N''surgery'' AND [Street]=N''428 coach light bay sw'' AND [Position]=N''assistant professor'' AND [CourtesyTitle]=N''MD'' AND [Typeof]=1 AND [Sys_Id]=21959 AND [Name]=N''anastasio/salazar'' AND [OrderRef]=''BJ031350 '' AND [/email][EMail]=N''[email protected]'' AND [FaxNo]=N''403 9441277'' AND [NoMail]=N''0'' AND [Processed]=1 AND [TelNo]=N''2467809'' AND [State]=N''alberta'' AND [Town]=N''calgary'' AND [Country]=N''CANADA'' AND [PostCode]=N''T3H 2Z1'' AND [isn_Online_ISSN]=''1399-0012'' AND [isn_Print_ISSN]=''0902-0063'' AND [isn_Supplement_ISBN]='''' AND [isn_Supplement_ISSN]=''1399-6738'' AND [isn_ISSN_ID]=394 AND [extra_data3] IS NULL AND [extra_data2] IS NULL AND [ORIG]=''BB'' AND [discount] IS NULL AND [isn_SubTitle]='''' AND [isn_Title_Lead_Word]='''' AND [isn_OnLineEarly]=1 AND [isn_Book_Reviews]=0 AND [isn_Title]=''Clinical Transplantation'' AND [isn_Jnl_Ranking]=''M2'' AND [isn_Subject_Team]=N''TRA'' AND [isn_BPL_BPI]=''BB'' AND [isn_External_Acronym]=''CTR'' AND [CardType]=N''Amex'' AND [OrderType]=1 AND [CardVerification] IS NULL AND [CardNumber]=N'' '' AND [PaymentType]=3 AND [PriceRegion]=N''The Americas*, The Americas* '' AND [PriceType]=N''Reduced Rate: Print + Online***'' AND [Price]=N''$310.3 '' AND [PriceVolumn] IS NULL AND [CustomerNo]=N'''' AND [VatNumber]=N'' '' AND [extra_data1] IS NULL AND [CustomerName]=N'''' AND [VatReg]=0 AND [IssueNumber] IS NULL AND [ExpiryDate]=N''8/2005 '' AND [CardHolderAdd]=N'''' AND [CardHolderName]=N''''')


The following messages were returned from the SQL Server:

[5701] Changed database context to 'dbContentsIN'.
[5703] Changed language setting to British.[/email]

Comments

  • Brian DonahueBrian Donahue Posts: 6,590 New member
    Hi,

    SQL Server (sometimes?) does not allow updates through views that are derived from multiple tables. You could simply update the tables and exclude this view. As an alternative, I believe you can use INSTEAD OF triggers as a go-between to update the base tables through the view, but that can be a bit of a complicated solution, I think.
  • Ah, ok thanks.

    I think I'm going to just explude the views and see if the developers are happy with a refresh of the tables.

    Thanks again

    Farren
Sign In or Register to comment.