Q&A for those committed to a vegan or vegetarian lifestyle and anyone interested in learning more
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;