mercredi 10 mars 2021

Return random order with every shipment that is applicable to the order

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