How I Can Select From Many Tables Using Case Statement

See more:

T-SQL

I have 4 tables

StdntBtech,StdntPg,StdntUg,StdntDip

i have to insert values into StdntBtech if the course name is BE or Btech
similarly

i have to insert values into StdntPG if the course name is MCA or MSc
similarly
i have to insert values into StdntUg if the course name is BSc

similarly
i have to insert values into StdntDip if the course name is Diploma

i have given instruction to insert values in a single stored procedure using case statement


What is the solution for this?
what will be the syntax of this and the select statement?