Don't like ads? PRO users don't see any ads ;-)
Public Pastes
Guest

Untitled

By: a guest on Jun 17th, 2012  |  syntax: None  |  size: 1.09 KB  |  hits: 12  |  expires: Never
download  |  raw  |  embed  |  report abuse  |  print
Text below is selected. Please press Ctrl+C to copy to your clipboard. (⌘+C on Mac)
  1. SQL Server: select without order
  2. select * from blabla where column in ('03.01.KO61.01410',
  3. '03.02.A081.15002',
  4. '03.02.A081.15016',
  5. '03.02.A081.15003',
  6. '02.03.A081.57105')
  7.        
  8. select * from blabla where column in ('03.01.KO61.01410',
  9. '03.02.A081.15002',
  10. '03.02.A081.15016',
  11. '03.02.A081.15003',
  12. '02.03.A081.57105')
  13. order by
  14. CASE column
  15. when '03.01.KO61.01410' then 1
  16. when '03.02.A081.15002' then 2
  17. when '03.02.A081.15016' then 3
  18. when '03.02.A081.15003' then 4
  19. when '02.03.A081.57105' then 5
  20. end
  21.        
  22. SELECT (list of columns)
  23.  FROM dbo.blabla
  24.  WHERE column IN ('03.01.KO61.01410', '03.02.A081.15002',
  25.                   '03.02.A081.15016', '03.02.A081.15003', '02.03.A081.57105')
  26.  ORDER BY NEWID()
  27.        
  28. CREATE TYPE varchar20_list_type AS TABLE (
  29.     id INT IDENTITY PRIMARY KEY,
  30.     val VARCHAR(20) NOT NULL UNIQUE
  31. )
  32.  
  33. DECLARE @mylist varchar20_list_type
  34. INSERT @mylist (val) VALUES
  35.     ('03.01.KO61.01410'),
  36.     ('03.02.A081.15002'),
  37.     ('03.02.A081.15016'),
  38.     ('03.02.A081.15003'),
  39.     ('02.03.A081.57105')
  40.  
  41. SELECT
  42.     *
  43. FROM
  44.     blabla
  45.     JOIN @mylist AS t
  46.     ON
  47.         blabla.col = t.val
  48. ORDER BY
  49.     t.id
create a new version of this paste RAW Paste Data