Jag vill flytta data från en tabell till en annan. Problemet är att jag inte kan komma på hur jag får ut mer än en rad i taget. Kan någon hjälpa mig med detta? userName är lika i båda tabellerna.Flytta data från en tabell till en annan
<code>
alter proc updateUserTemp
as
set nocount on
declare @user varchar(256)
declare @fName varchar(20)
declare @lName varchar(20)
declare @address varchar(30)
declare @zipCode varchar(6)
declare @city varchar(30)
declare @phone varchar(20)
declare @cellPhone varchar(20)
select @user = userName from members
select @fName = fName from members
select @lName = lName from members
select @address = address from members
select @zipCode = zipCode from members
select @city = city from members
select @phone = phone from members
select @cellPhone = cellPhone from members
update aspnet_users
set
fName = @fName,
lName = @lName,
address = @address,
zipCode = @zipCode,
city = @city,
phone = @phone,
cellPhone = @cellPhone
where username = @user AND applicationID = 'e6ed47a4-eca4-4dd7-ad87-9c7c090a3448'
</code>