How can I retrieve and modify each NTILE grouping in SQL Server 2008?

Data and Databases
1

How can I assign values to Column D for each NTILE group, created by grouping Column B and Column C in SQL Server 2008, without employing a cursor?

2

hey, have you tried using a cte with row_num? i’m thinking joining on ntile window func(particles on col b and c) may work, without cursers. what approaches have you explored, and did this anylt help?