i am trying to update using the query attached.
SoNo is a field in itemSO
i get this error :
Msg 4108, Level 15, State 1, Line 1
Windowed functions can only appear in the SELECT or ORDER BY clauses.
Could someone please explain why this is wrong, and tell me what could be a solution?
set ficAssmb = SoNo + '-' + ROW_NUMBER() OVER(PARTITION BY SoNo ORDER BY SoNo, itemNo)