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

Popular posts from this blog

Detect support for Shoutcast ICY MP3 without navigator.userAgent in Firefox? -

web - SVG not rendering properly in Firefox -

java - JavaFX 2 slider labelFormatter not being used -