Stored Procedure Help - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

.NET Inside SQL Server (2005)

Stored Procedure Help

Author

Topic

mandrews1234
Starting Member

9 Posts

Posted - 2009-07-01 : 10:45:33

I need to write a stored procedure to insert data from two related tables into another table.
My pseudo is something like this
select aspnet_users.userid, dealerships.dealerid from aspnet_users inner join dealerships on dealerhsips.adminid = aspnet_users.userdi

I need to insert the userid into dealers.dealerid and the dealershipid into dealers.dealershipid. I have never written a stored procedure before but I have seen a lot of syntax. Can anyone help me out with writing this. I'm on sql server 2000. Thanks,

Michael Andrews
Web Developer
www.intellicominc.com

khtan
In (Som, Ni, Yak)

17689 Posts

Posted - 2009-07-01 : 11:05:42

actually you are almost there . .


create procedure the_procedure_name
as
begin
    insert into dealers (dealerid, dealershipid)
    select aspnet_users.userid, dealerships.dealerid 
    from   aspnet_users 
           inner join dealerships on dealerhsips.adminid = aspnet_users.userid            
end

KH
[spoiler]Time is always against us[/spoiler]

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources