When I try to run this simple statement (below) I get an error -
Msg 102, Level 15, State 1, Line 4
Incorrect syntax near ')'.
If I run the second select by iytself it works - Any idea why this would occur -
if i can not use row number to number the items in each set within this larger set how can I accomplish this?
select id , evtdate, userGuid, Interval, FieldName, value,
point into #temp2 from (Select id , evtdate, userGuid, Interval, FieldName, value,
ROW_NUMBER() OVER(Partition By ID Order By FieldName) from #temp)