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.