Reputation: 589
insert into #TempUserTable
query
;with cte as
(
select *,row_number() over(partition by (userid) order by login_time) as 'rowrank'
from #TempUserTable
)
getting error incorrect syntax near ')'
Upvotes: 0
Views: 8453
Reputation: 171599
The syntax looks fine, just add your select at the end.
;with cte as
(
select *,row_number() over(partition by (userid) order by login_time) as 'rowrank'
from #TempUserTable
)
select *
from cte
where rowrank = 1
Upvotes: 2
Reputation: 8324
;with cte as
(
select *,row_number() over(partition by (userid) order by login_time) as 'rowrank'
from TempUserTable
)
SELECT *
INTO #tempusertable
FROM cte
Upvotes: 1