sql server - ROW_Count in VIEW -
i able run query in sql server:
select "hiring pipe req number", row_number() on ( partition "hiring pipe req number" order "hiring pipe req number") rownumber dbo.talentdelivery_req_3facts
however, failed when put code below in view
.
select "hiring pipe req number", row_number() on ( partition "hiring pipe req number" order "hiring pipe req number")as rownumber (select * dbo.talentdelivery_req_3facts)
why fail in view?
how can write above in view?
try 1 -
create view dbo.vw_view1 select [hiring pipe req number] , row_number() on ( partition [hiring pipe req number] order 1/0 ) rownumber ( select * dbo.talentdelivery_req_3facts ) t
Comments
Post a Comment