Home Forums SQL Server 2017 SQL Server 2017 - Development Convert a query to a View RE: Convert a query to a View
pietlinden
SSC Guru
Points: 63428
More actions
February 18, 2018 at 2:24 pm
#1980200
Yeah, I figured that out after taking a break for a while... (That's my crummy code he was posting about.)Took me a minute to figure out I could use ROW_NUMBER() OVER () PARTITION... to do it. Turns out leaving myself hints worked pretty well.