I have two drop downs that users can select from and add them to list (Both Course and Module). The user then adds all other details about the video and uploads it.
I would like every course and module that is added to those lists to be added as an entry to the database table (VideoAssociation).
All of the other details would be wriiten to the video table.
The trouble is to write to the VideoAssociation table I would need a VideoNo as the identifier and that is not assigned until the video is added to the video table.
I need help how to write a query or multiple queries in a stored procedure to add all entries to the VideoAssociation Table after inserting the video details.
I think aloop would have to be used to get entries from the courses and modules lists, but I don't know where to start?
I have included an image of the interface and the stored procedure I have written so far.
ALTER PROCEDURE dbo.sprocUploadVideo
@UserNo INT ,
@VideoName VARCHAR(50) = NULL ,
@ModuleNo INT ,
@CourseNo INT = NULL ,
@DateUploaded DATETIME = NULL ,
@VideoUrl VARCHAR(50) = NULL ,
@ThumbUrl VARCHAR(50) ,
@Description VARCHAR(500) ,
@Keywords VARCHAR(50) ,
”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.
-Mike Kapnisakis, Warner Bros
With your subscription - you'll gain access to our exclusive IT community of thousands of IT pros. You'll also be able to connect with highly specified Experts to get personalized solutions to your troubleshooting & research questions. It’s like crowd-sourced consulting.
We can't always guarantee that the perfect solution to your specific problem will be waiting for you. If you ask your own question - our Certified Experts will team up with you to help you get the answers you need.
Our certified Experts are CTOs, CISOs, and Technical Architects who answer questions, write articles, and produce videos on Experts Exchange. 99% of them have full time tech jobs - they volunteer their time to help other people in the technology industry learn and succeed.
We can't guarantee quick solutions - Experts Exchange isn't a help desk. We're a community of IT professionals committed to sharing knowledge. Our experts volunteer their time to help other people in the technology industry learn and succeed.