I have three tables: tCheckout tUsers tTypes data
UID UID TypeID TypeName
UName UName 1 Regular
TypeID Regular (1 or 0) 2 Small
Checkout_Date Large (1 or 0) 3 Large
Checkin_Date Small (1 or 0)
I have to insert a, Userid, TypeID, and checkout date into the Checkout table based on different type fields in the Users table to determine if user can update records. I would like to write a query to include a CASE statement to insert TypeID into the Checkout table with the use of variables. I will be inserting this query into a stored procedure. Can you help me with this please.