Skip to navigation
Find duplicated in mssql
28.10.17
SELECT [av0_style], COUNT(*) AS dupes FROM [SL].[dbo].[zz_free_displays] GROUP BY [av0_style] HAVING (COUNT(*) > 1)
Reply
Anonymous
drop table #dub SELECT [mh2_code_price_list] ,[mh2_style_code] ,[mh2_from_qty] ,ROW_NUMBER() OVER(PARTITION by [mh2_code_price_list] ,[mh2_style_code] ,[mh2_from_qty] ORDER BY [mh2_code_price_list]) AS counting INTO #dub FROM[mh2_price_list_ln2] select * from #dub
28.10.17
Reply
Anonymous
Information Epoch 1779162443
Fold knowledge into data so program logic can be stupid and robust.
Home
Notebook
Contact us
