- SELECT MAX(...) ... GROUP BY ...
- ALTER VIEW [dbo].[ViewName]
- AS
- SELECT
- ISNULL(CAST(
- CASE ROW_NUMBER() OVER (ORDER BY columnNames)
- WHEN ROW_NUMBER() OVER (ORDER BY columnNames) THEN ROW_NUMBER() OVER (ORDER BY columnNames)
- ELSE 0
- END AS int), 0) AS ID