Invalid Column Using Row_Number()
With your example in the question, you could skip the whole ROW_NUMBER() thing and just use TOP (1):

INSERT INTO @Temp (id, salesID)
SELECT TOP (1) 1, Bama
FROM rusticlines AS rstln  
WHERE Active = '1'
ORDER BY Bama;


For more complex queries (where you need to get first row in a partition), you could probably make something useful with TOP (1) WITH TIES.