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, Oct 19 '16 at 11:29

score 0 · Answer 1 · edited May 23 '17 at 12:00

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).

edited May 23 '17 at 12:00

Community

answered Oct 19 '16 at 11:20

Jens

1 Answers1