How to use Temporary table in stored procedure to reuse value for select or delete records of other tables using SQL Server

Hi ,

    I need one stored procedure like below.

Users Table:

UserID      Name

1               Mahesh

Company Table :

CompanyID       Name

1                       Mahesh&Co

Jobs:

JobID           CompanyID     JobTitle

1                    1                  Asp.net

2                    1                  Java

3                    1                  Oracle

Skills:

SkillID            Name

1                   Ado.net

2                   CoreJava

3                   MySQL

JobRequiredSkills:

JobRequiredSkillID      JobID     SkillID

1                                1               1

2                                 1              2

3                                2               2

4                                3                3

Scenario:

1. Only input we are going to pass is : UserID from users table

2. based on userid input we have to get companyID

3. we have to get all jobs posted with that companyid

4. after getting all jobs we have to delete all data from jobs table as well child table i.e jobrequiredskills.

Thanks in advance.