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 2000 Forums  SQL Server Development (2000)  sproc:copying a username from one table to another

Author  Topic  huge Starting Member 31 Posts Posted - 2001-07-24 : 17:03:40 Hey guys, ok this is what I have to do. There are 3 stage of registration on my site. The first stage simply gives you acces to search the second and thrid build your profile so people can search for you. Basically I got a sproc that sees if the username is already taken if not then registers the user under that username. I need to build another sproc that takes the username from the table from registration step1 and copies it to the table of registration part 2. The sproc should go, and based on the UserID (not username), get the username from the registration table 1 and copy it to reg table 2. Keep in mind I am very new to SQL and this is basically my 2nd week ever using it. This is the current code I have for the sproc so far but its completely wrong: CREATE PROCEDURE sproc_UpdUsnReg ( @uid char(15) ) AS DECLARE @tempusername varchar(16) SET @Tempusername = "SELECT [Username] FROM [UserInfo] WHERE [UserID] = @uid" EXEC(@Tempusername) INSERT INTO Profile_build ([Username]) VALUES (@tempusername) GO Thanks for your help Mike M