I am attempting to only select the 1st row returned from the query. This is my syntax ->
insert into @Temp (id, salesID) select RN = ROW_NUMBER() OVER(order by t.psUserID) ,t.psUserID from ( select distinct psUserID = rstln.Bama From rusticlines rstln AND tnr.Active = '1') t WHERE RN = 1;
And I get the error:
Msg 207, Level 16, State 1, Line 51
Invalid column name 'RN'.
What do I need to change so that it only selects the 1st row number?