I don't think you can transfer them automatically. I guess you'll have to 
write the SP from scratch, based on the original query.

Go to http://www.sqlteam.com/Default.asp to find out all about SQL, SP etc 
etc etc.

Imar


At 05:35 PM 1/10/2001 +0000, you wrote:
>I have a simple Update query that updates one table from another.  I would
>like to know how can I transfer this to an SQL view, procedure, or
>trigger.
>I'm new to sql, so any help would be appreciated.
>
>Thanks
>
>Cesar
>