|
suresh_dotnet
Starting Member
6 Posts |
 Posted - 2008-09-29 : 20:02:05
|
| Hi: I have writtern a Stored procedure in which have taken a Bigint value and insert it into another table.while running the query i met an error.I have mentioned my Stored procedure and the error i have met below.Stored Procedure:ALTER PROCEDURE [dbo].[DAMS_SP_InsertUserDetails]@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)ASBEGIN SET NOCOUNT ON;DECLARE @sqlinsert nvarchar(100)SET @sqlinsert=''SET @sqlinsert=@sqlinsert+'SELECT UserId FROM DAMS_Tbl_UsersLogin WHERE UserName='''+@UserName+''''EXEC @sqlinsertINSERT INTO DAMS_Tbl_RegisteredUsers(UserId,FirstName,LastName,DateOfBirth ,StreetAddress1 ,StreetAddress2 , City,State ,CountryId ,Email ,PhoneNo,MobileNo,FaxNo ,EmailDigestFrequency,AreaOfInterest ,InvoiceDeliveryMethod )VALUES (cast (@sqlinsert as Bigint) ,@FirstName,@LastName,@DateOfBirth ,@StreetAddress1 ,@StreetAddress2 ,@City,@State ,@CountryId ,@Email, @PhoneNo,@MobileNo,@FaxNo ,@EmailDigestFrequency,@AreaOfInterest ,@InvoiceDeliveryMethod )ENDError:System.Data.SqlClient.SqlException: Could not find stored procedure 'SELECT UserId FROM DAMS_Tbl_UsersLogin WHERE UserName='jhon''.Error converting data type nvarchar to bigint.Since its very very urgentCan any one send me query or give me a suggestion to solve this issue.Thankssuresh |
|
Error on Stored Procedure