Q&A about the site for Joomla! administrators, users, developers and designers
CREATE TABLE #yt ([Store] int) ; INSERT INTO #yt ([Store]) VALUES (102), (101) ; SELECT ROW_NUMBER() OVER(ORDER BY (SELECT NULL)) AS rownum, Store FROM #yt;