CREATE VIEW dbo.ARAC_MODELLERI
AS
SELECT ROW_NUMBER() OVER(ORDER BY SPECODE2) AS Ref, SPECODE2 AS Model  FROM
(
(SELECT DISTINCT SPECODE2 FROM LG_011_ITEMS WHERE SPECODE2 IS NOT NULL AND SPECODE2<>'')
)QQ