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;
SET Cost = new.Cost
FROM SSRevitCostings.dbo.SSParkHomeCostings AS new
WHERE SSRevitProject1.dbo.WindowTypes.Model = new.Model
THIS DONT WORK...