SQL - Insert a random; already made record into a new table. Using stored procedures

Question

I am creating a make booking stored procedure.

In a Tutor table I have already added tutor records.

The TutorId is referenced in the Booking table by a foreign key constraint.

After manual input from visual studio for generic booking questions, I would like a random TutorId to be assigned with this BookingId.

Your question is not very clear. Please add the SQL code (DDL) for the tables and the procedure you have at the moment. Also show some sample data for before and after your procedure runs (expected output). — Tony
– Tony, Commented Oct 19, 2016 at 11:29

Community · Accepted Answer · 2017-05-23 12:00:42Z

0

SELECT TOP 1 TutorId FROM Tutor ORDER BY NEWID()

This will return you a random record from your Tutor table.

A NEWID() is generated for each row and the table is then sorted by it. The first record is returned (i.e. the record with the "lowest" GUID).

CommunityBot

11 silver badge

answered Oct 19, 2016 at 11:20

Jens

3,3092 gold badges28 silver badges43 bronze badges

Sign up to request clarification or add additional context in comments.

1 Answer 1