Jump to content

GaryMans

Members
  • Posts

    2
  • Joined

  • Last visited

GaryMans's Achievements

Newbie

Newbie (1/7)

0

Reputation

  1. GaryMans

    BULK UPDATE

    Hi NIche, A little confused as to where i should add the INNER JOIN... THis is what i have... UPDATE SSRevitProject1.dbo.CaseworkTypes SET Cost = new.CostFROM SSRevitCostings.dbo.SSContainerCostings AS newWHERE SSRevitProject1.dbo.CaseworkTypes.Model = new.Model Sorry i am a bit of a newby so if you can point me in the right direction it would be appreciated.
  2. GaryMans

    BULK UPDATE

    Hi All, I am hoping someone can point me into the right direction with this one. So i have two databases, the one is used to update costings (dbs1) for different products using multiple tables. The other dbs (dbs2) is used to store costings of an existing project I then at the end of my design process use a query to update dbs1 with dbs2. here is the syntax; THIS WORKS... UPDATE SSRevitProject1.dbo.WindowTypes SET Cost = new.Cost FROM SSRevitCostings.dbo.SSParkHomeCostings AS new WHERE SSRevitProject1.dbo.WindowTypes.Model = new.Model THIS DONT WORK... UPDATE SSRevitProject1.dbo.CaseworkTypes SET Cost = new.Cost FROM SSRevitCostings.dbo.SSContainerCostings AS new WHERE SSRevitProject1.dbo.CaseworkTypes.Model = new.Model The problem i have is that SQL is for some reason not using one of my tables in dbs1 to update dbs2. I hope this is clear enough.
×
×
  • Create New...