Hi: I am using
Login,Userdetails
tables in which UserID is common for both tables.UserId is Primary key
for Login .UserId is not a Foreign Key for Userdetails table due to it
refers more than one table.
Now I have to take UserId from Login
table then insert into Userdetails table along with some other
parameters.I have writtern procedure but i got some error.Procedure and
the Error has Mentioned below.
Procedure:
ALTER PROCEDURE [dbo].[DAMS_SP_InsertUserDetails]
AS
BEGIN
DECLARE @sqlinsert varchar(100),
@UserId as bigint,
@UserName as varchar(25),
@FirstName as varchar(100),
@LastName as varchar(100),
@DateOfBirth as datetime,
@StreetAddress1 as varchar(1000),
@StreetAddress2 as varchar(1000),
@City as varchar(250),
@State as varchar(250),
@CountryId as int,
@Email as varchar(250),
@PhoneNo as varchar(25),
@MobileNo as varchar(25),
@FaxNo as varchar(25),
@EmailDigestFrequency as char(25),
@AreaOfInterest as int,
@InvoiceDeliveryMethod as varchar(25)
SET NOCOUNT ON;
SET @sqlinsert=''
SET @sqlinsert=@sqlinsert+'SELECT UserId FROM DAMS_Tbl_UsersLogin WHERE UserName='''+@UserName+''''
EXEC @sqlinsert
INSERT INTO DAMS_Tbl_RegisteredUsers(UserId,FirstName,LastName,DateOfBirth ,StreetAddress1 ,StreetAddress2 ,
City,State ,CountryId ,Email ,PhoneNo,MobileNo,FaxNo ,EmailDigestFrequency,AreaOfInterest ,InvoiceDeliveryMethod )VALUES
(@sqlinsert ,@FirstName,@LastName,@DateOfBirth ,@StreetAddress1 ,@StreetAddress2 ,@City,@State ,@CountryId ,@Email,
@PhoneNo,@MobileNo,@FaxNo ,@EmailDigestFrequency,@AreaOfInterest ,@InvoiceDeliveryMethod )
END
Error:
Generally I got the Error
" Parameter is not supplied"
Can any one send me query to solve this issue plz. its very urgent.
suresh
Loading
Blocked AccountPosted Sep 30, 2008, 3:26 AM
Hi,
Relace your these lines
SET @sqlinsert=''
SET @sqlinsert=@sqlinsert+'SELECT UserId FROM DAMS_Tbl_UsersLogin WHERE UserName='''+@UserName+''''
EXEC @sqlinsert
to this code
declare @sqlinsert varchar(25)
set @sqlinsert=SELECT UserId FROM DAMS_Tbl_UsersLogin WHERE UserName=@UserName