Hi everyone... Here is a problem i've been working over today to no avail... I have 2 tables - the first table "A" contains 1 field which I will call 'item' the second table "B" contains 2 fields 'item' and 'OnOrder'.
I need a sql statement that will update the OnOrder Field from a user defined function for every item that matches an item in table "A". I thought about using
UPDATE B Set B.OnOrder = dbo.functionname(a.item) from B, A where b.item = a.item but this doens't work.. hehe
any suggestions?
I need a sql statement that will update the OnOrder Field from a user defined function for every item that matches an item in table "A". I thought about using
UPDATE B Set B.OnOrder = dbo.functionname(a.item) from B, A where b.item = a.item but this doens't work.. hehe
any suggestions?
