Sorry that it is not clear I will try to explian now!

Firstly there are 2 inserts into 2 seperate tables.

A user can make a request into a 3rd table to...

I want to use Stored Procedures but not really sure how to write them to do what I want!

Mick

The information is being return from the same table but is presently being returned as an int. The int is being submitted into the table from a dropdown list...

Got the Stored Procedure working thanks to all for your help.

Now I need convert one of the fields the SP returns to show the text data rather than the int...

I have now made the changes as follows:

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

ALTER PROCEDURE [dbo].[select_NewRequest] @UID int AS

if @UID IS NOT NULL

Begin

SELECT [UID]

,[StaffNumber]

...

Adi

Sorry if I seam very stupid as this is maybe straight forward for you but i have made the changes:

USE [MobilePhones]

GO

/****** Object: StoredProcedure [dbo].[select_NewRequest] Script Date:...

This didnt work any other ideas?

Mick

Thanks for everyones reply to this.

I got it working and it was a simple insert into the 2 tables which done it for me!

Thanks Again

Mick

Sorry

I need the following 2 inserts to happen once i select a submit button on the ASP page:

INSERT INTO [MobilePhones].[dbo].[tblPerson]

...