I have a SQL Table that I want to update a column called "UpdateColumn" based on [Column 1], Rownumber = 1 and Usage = R and Elements = '12'
This is my query so far but I cannot get the right results:
SET UpdateColumn = [Column 1]
WHERE Rownumber = '1'
AND Usage = 'R'
AND Elements = '12'
AND FILENUMBER = FILENUMBER
I really appreciate all your help.