troubleshooting Question

Query SQL Server table and shuffle results

Avatar of Christian Palacios
Christian PalaciosFlag for Canada asked on
Microsoft SQL ServerSQL
3 Comments1 Solution18 ViewsLast Modified:
Hi there,

We want to query a table based on a few "where" clauses and then after the records are collected, we'd like to shuffle them so that when they are exported, they are always ordered differently.  We don't want to just simply use an "order" clause, so is there a way to shuffle the records before we export them to a CSV file using Powershell?

Máté Farkas
SQL Server Consultant
Join our community to see this answer!
Unlock 1 Answer and 3 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 3 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros