Preserving ORDER BY in SELECT INTO

by

I know this is a bit old, but I needed to do something similar. I wanted to insert the contents of one table into another, but in a random order. I found that I could do this by using select top n and order by newid(). Without the ‘top n’, order was not preserved and the second table had rows in the same order as the first. However, with ‘top n’, the order (random in my case) was preserved. I used a value of ‘n’ that was greater than the number of rows. So my query was along the lines of:

insert Table2 (T2Col1, T2Col2)
  select top 10000 T1Col1, T1Col2
  from Table1
  order by newid()

More Related Contents:

  1. How can I remove duplicate rows?
  2. SQL Server: Examples of PIVOTing String data
  3. Check if table exists in SQL Server
  4. Using T-SQL, return nth delimited element from a string
  5. What is the use of GO in SQL Server Management Studio & Transact SQL?
  6. SELECT DISTINCT on one column
  7. Using a if condition in an insert SQL Server
  8. Altering a column: null to not null
  9. When no ‘Order by’ is specified, what order does a query choose for your record set?
  10. Confused about UPDLOCK, HOLDLOCK
  11. Is there a way to simplify a NULL compare of 2 values
  12. TSQL Try / Catch within Transaction or vice versa?
  13. What is the maximum number of characters that nvarchar(MAX) will hold?
  14. How do I find a stored procedure containing ?
  15. TSQL: Create a view that accesses multiple databases
  16. Sequence as default value for a column
  17. Aggregate bitwise-OR in a subquery
  18. How do I flush the PRINT buffer in TSQL?
  19. OR Operator Short-circuit in SQL Server
  20. SQL Error with Order By in Subquery
  21. How to change default language for SQL Server?
  22. T-SQL incrementing counter based on change in a column value
  23. T-SQL XOR Operator
  24. Cannot bulk load. Operating system error code 5 (Access is denied.)
  25. ADO.NET calling T-SQL Stored Procedure causes a SqlTimeoutException
  26. “If not exists” fails on SQL CE
  27. Does the `nodes()` method keep the document order?
  28. Incorrect syntax near ‘)’ calling stored procedure with GETDATE
  29. Generate MD5 hash string with T-SQL
  30. Why can’t Entity Framework see my Stored Procedure’s column information?

Leave a Comment