Receiving truncated error.... need sos help
-
i am debugging in sql analyzer and i get all the way to ''''' EXEC sp_executesql @sql, N'@MaxID INT OUT', @MaxID OUT '''''' then i get the error below
Server: Msg 8152, Level 16, State 10, Line 1
[Microsoft][ODBC SQL Server Driver][SQL Server]String or binary data would be truncated.
The statement has been terminated.
what can i look for to solve this issue?
thanks,
erik
================================================
create PROCEDURE Admin_SelectAll_w_Generic_111
@Admin_Email Varchar (200), /*Admin Check */
@Admin_FName Varchar (30), /*Admin Check */
@Admin_UserType Varchar (20), /*Admin Check */
@Identity Varchar (20),
@GenericColumn Varchar (200) ,
@GenericValue Varchar (200)
AS
DECLARE @sql NVARCHAR(4000)
DECLARE @user-id INT
DECLARE @MaxID INT
IF EXISTS (SELECT Email, FirstName, UserType FROM Users
WHERE Email = @Admin_Email AND
FirstName = @Admin_FName AND
UserType = @Admin_UserType)
BEGIN
IF (@Identity <> 'Consumer')
BEGIN
CREATE TABLE #UsersTempTable
(
ID int IDENTITY PRIMARY KEY,
UserID [int],
FirstName [varchar](30),
LastName [varchar](30),
CompanyName [varchar](200),
Address1 [varchar](75),
Address2 [varchar](75),
City [varchar](75),
ActiveInd [int],
Zip [varchar](10),
WkPhone [varchar](12),
HmPhone [varchar](12),
Fax [varchar](12),
Email [varchar](200),
Website [varchar](200),
UserType [varchar](20),
Title [varchar](100),
Note [text],
StateCD [char](2),
CountryCD [char](2),
CompanyPhoto [varchar](50),
CompanyDescr [varchar](2000)
)
--Fill the temp table with the Customers data
Set @sql= 'INSERT INTO #UsersTempTable
(
UserID,
FirstName,
LastName,
CompanyName,
Address1,
Address2,
City,
ActiveInd,
Zip,
WkPhone,
HmPhone,
Fax,
Email,
Website,
UserType,
Title,
Note,
StateCD,
CountryCD,
CompanyPhoto,
CompanyDescr)
Select Users.UserID,
Users.FirstName,
Users.LastName,
Users.CompanyName,
Users.CompanyPhoto,
Users.CompanyDescr,
Users.UserType,
Users.Website,
Users.ActiveInd,
Users.Address1,
Users.Address2,
Users.City,
Users.Zip,
Users.WkPhone,
Users.HmPhone,
Users.Fax,
Users.Title,
Users.Note,
Users.StateCD,
Users.CountryCD,
Users.Email
From Users
WHERE ' + @GenericColumn + ' = ''' + @GenericValue + '''ORDER BY UserID
SELECT @MaxID = MAX(Userid) FROM #UsersTempTable '
EXEC sp_executesql @sql, N'@MaxID INT OUT', @MaxID OUT
SELECT SpecialtyName
from Specialty s INNER JOIN UserSpecialty ON s.SpecialtyCD = UserSpecialty.SpecialtyCD
WHERE UserSpecialty.UserID = @MaxID
END
ELSE
IF (@Identity = 'Consumer')
BEGIN
SET @sql = '
Select Users.UserID,
Users.FirstName,
Users.LastName,
Users.UserType,
Users.ActiveInd,
Users.Address1,
Users.Address2,
Users.City,
Users.Zip,
Users.WkPhone,
Users.HmPhone,
Users.Fax,
Users.Title,
Users.Note,
Users.Email,
StateCD,
CountryCD
From Users
WHERE ' + @GenericColumn + ' = ''' + @GenericValue + ''''
EXEC (@SQL)
End
END
Dam again!
-
i got it ....my select statment did not match my insert into
Dam again!
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply