Hi I am super new to SSMS.
I need to create a random audit that will look at one order and all the activities that is attached to that order to return. It will return top 40 order # randomly but with multiple activities.
Example table Order# Activities 1 Jump 1 Jump 1 Run 3 Jump 3 Run 3 Duck 4 Kick 5 Run 6 Duck 6 Kick
So far this is what I have. Select * From Project Order by NEWID()
I found something similar but I did not understand it.
Aucun commentaire:
Enregistrer un commentaire