Reorder the data out put of a stored procedure

Question

I have a stored procedure that produces data for call center solution. However, is there a way to modify the sp so that each time the data is executed it is delivered in a different order? For Example Today: 1,2,3 Tomorrow: 2,1,3 the next day 3,1,2 . Is there a manipulation I can execute that will scramble the order whenever it is executed?

score 2 · Answer 1 · answered Aug 27 '15 at 14:28

2

Yes simples. ORDER BY NewID()

answered Aug 27 '15 at 14:28

Mark

1,544
1
14
26

score 1 · Answer 2 · answered Aug 27 '15 at 14:29

1

SELECT column FROM table ORDER BY NewID()

answered Aug 27 '15 at 14:29

Lali

2,816
4
30
47

Reorder the data out put of a stored procedure

2 Answers2