I am developing a Booking System and for my database i am using Sql Server. I have three tables created and i need to join them. My user will need to input details of their booking which then gets saved to the BookingDetails table. The rate they get charged depends on a number of parameters they enter when booking.
My Question is how do i return the TestId from TestNew table when user enters in the specified parameters(i.e Section and Member). Below is my ERD and what i have tried so far.
Any advice or help is much appreciated. Thanks
--Input Parameters variables
Declare @UserId int = 1 Declare @Member nvarchar(50) = 'Student' Declare @Section nvarchar(50) = 'FullPitch' Declare @Date date = '03/23/18' Declare @StartTime time(7) = '18:00:00' Declare @EndTime time(7) = '19:00:00' Declare @Description nvarchar(max) = 'Blah Blah'
You would need to insert into
answered Feb 09 at 08:18 AM
Kev Riley ♦♦