Getting errors when comparing two dbs.. but why?
fminns
Posts: 3
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]='i.summerscales@btinternet.com' 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]='david.packwood@tiscali.co.uk' 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]='richard.baretto@heartsol.wmids.nhs.uk' 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]='j.c.coates@bham.ac.uk' 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]='m.leseure@aston.ac.uk' 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]='brigitlowell98@hotmail.com' 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]='hgg875@bham.ac.uk' 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]='cxt115@bham.ac.uk' 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]='s.carvalho@wlv.ac.uk' 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]='dmaye@glos.ac.uk' 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]='simbo@tinmar61.freeserve.co.uk' 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]='s.williams9@wlv.ac.uk' 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]='lauren.goodchild@curee.co.uk' 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]='HelenS@dudleywarehouse.org' 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]='skenny@cip-books.com' 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]='g.m.mcgillivray@newman.ac.uk' 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]='B.Canning@coventry.ac.uk' 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]='txk995@bham.ac.uk' 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]='steve.tipping@uce.ac.uk' 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]='d.mckenzie@jmc.ac.uk' 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]='aspidistraslug@hotmail.com' 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]='joealdred@btinternet.com' 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]='t.a.barnes@warwick.ac.uk' 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]='kkaur9@excite.com' 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]='mphillips@freeola.com' 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]='M.S.Goodacre@bham.ac.uk' 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]='P.Sembi@wlv.ac.uk' 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]='verity.relves@arup.com' 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]='sbowskill@yahoo.co.uk' 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]='rinkusss@hotmail.com' 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]='kimather@iinet.net.au' 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]='sjmcdona@student.ecu.edu.au' 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]='lwacker@uwinst.unizh.ch' 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]=''CTR@oxon.blackwellpublishing.com'' 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''Rita@lifelinkfound.org'' 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]=''CTR@oxon.blackwellpublishing.com'' 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''jhvdh@home .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]=''CTR@oxon.blackwellpublishing.com'' 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''richard.j.migliori@uhc.com'' 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]=''CTR@oxon.blackwellpublishing.com'' 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''salazara@ucalgary.ca'' 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]
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]='i.summerscales@btinternet.com' 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]='david.packwood@tiscali.co.uk' 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]='richard.baretto@heartsol.wmids.nhs.uk' 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]='j.c.coates@bham.ac.uk' 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]='m.leseure@aston.ac.uk' 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]='brigitlowell98@hotmail.com' 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]='hgg875@bham.ac.uk' 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]='cxt115@bham.ac.uk' 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]='s.carvalho@wlv.ac.uk' 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]='dmaye@glos.ac.uk' 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]='simbo@tinmar61.freeserve.co.uk' 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]='s.williams9@wlv.ac.uk' 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]='lauren.goodchild@curee.co.uk' 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]='HelenS@dudleywarehouse.org' 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]='skenny@cip-books.com' 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]='g.m.mcgillivray@newman.ac.uk' 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]='B.Canning@coventry.ac.uk' 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]='txk995@bham.ac.uk' 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]='steve.tipping@uce.ac.uk' 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]='d.mckenzie@jmc.ac.uk' 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]='aspidistraslug@hotmail.com' 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]='joealdred@btinternet.com' 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]='t.a.barnes@warwick.ac.uk' 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]='kkaur9@excite.com' 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]='mphillips@freeola.com' 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]='M.S.Goodacre@bham.ac.uk' 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]='P.Sembi@wlv.ac.uk' 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]='verity.relves@arup.com' 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]='sbowskill@yahoo.co.uk' 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]='rinkusss@hotmail.com' 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]='kimather@iinet.net.au' 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]='sjmcdona@student.ecu.edu.au' 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]='lwacker@uwinst.unizh.ch' 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]=''CTR@oxon.blackwellpublishing.com'' 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''Rita@lifelinkfound.org'' 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]=''CTR@oxon.blackwellpublishing.com'' 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''jhvdh@home .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]=''CTR@oxon.blackwellpublishing.com'' 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''richard.j.migliori@uhc.com'' 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]=''CTR@oxon.blackwellpublishing.com'' 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''salazara@ucalgary.ca'' 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
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.
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