Solved

Need help with syntax error on SUBSTRING

Posted on 2008-10-17
5
482 Views
Last Modified: 2012-05-05
I'm getting a ton of error message when i run this query.  Can someone help take a look here.  Thank you.

Msg 536, Level 16, State 5, Line 124
Invalid length parameter passed to the SUBSTRING function.

(1 row(s) affected)
Msg 536, Level 16, State 5, Line 124
Invalid length parameter passed to the SUBSTRING function.

(1 row(s) affected)
Msg 536, Level 16, State 5, Line 124
Invalid length parameter passed to the SUBSTRING function.

(1 row(s) affected)
Msg 536, Level 16, State 5, Line 124
Invalid length parameter passed to the SUBSTRING function.

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)
Msg 536, Level 16, State 5, Line 124
Invalid length parameter passed to the SUBSTRING function.

(1 row(s) affected)
Msg 536, Level 16, State 5, Line 124
Invalid length parameter passed to the SUBSTRING function.

(1 row(s) affected)
Msg 536, Level 16, State 5, Line 124
Invalid length parameter passed to the SUBSTRING function.

(1 row(s) affected)
Msg 536, Level 16, State 5, Line 124
Invalid length parameter passed to the SUBSTRING function.

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)
Msg 536, Level 16, State 5, Line 124
Invalid length parameter passed to the SUBSTRING function.

(4 row(s) affected)
Msg 536, Level 16, State 5, Line 124
Invalid length parameter passed to the SUBSTRING function.

(4 row(s) affected)
Msg 536, Level 16, State 5, Line 124
Invalid length parameter passed to the SUBSTRING function.

(4 row(s) affected)
Msg 536, Level 16, State 5, Line 124
Invalid length parameter passed to the SUBSTRING function.

(4 row(s) affected)

(4 row(s) affected)

(4 row(s) affected)
Msg 536, Level 16, State 5, Line 124
Invalid length parameter passed to the SUBSTRING function.

(4 row(s) affected)
Msg 536, Level 16, State 5, Line 124
Invalid length parameter passed to the SUBSTRING function.

(4 row(s) affected)
Msg 536, Level 16, State 5, Line 124
Invalid length parameter passed to the SUBSTRING function.

(4 row(s) affected)
Msg 536, Level 16, State 5, Line 124
Invalid length parameter passed to the SUBSTRING function.

(4 row(s) affected)

(4 row(s) affected)

(4 row(s) affected)
Msg 536, Level 16, State 5, Line 124
Invalid length parameter passed to the SUBSTRING function.

(4 row(s) affected)
Msg 536, Level 16, State 5, Line 124
Invalid length parameter passed to the SUBSTRING function.

(4 row(s) affected)
Msg 536, Level 16, State 5, Line 124
Invalid length parameter passed to the SUBSTRING function.

(4 row(s) affected)
Msg 536, Level 16, State 5, Line 124
Invalid length parameter passed to the SUBSTRING function.

(4 row(s) affected)

(4 row(s) affected)

(4 row(s) affected)
Msg 536, Level 16, State 5, Line 124
Invalid length parameter passed to the SUBSTRING function.

(4 row(s) affected)
Msg 536, Level 16, State 5, Line 124
Invalid length parameter passed to the SUBSTRING function.

(4 row(s) affected)
Msg 536, Level 16, State 5, Line 124
Invalid length parameter passed to the SUBSTRING function.

(4 row(s) affected)
Msg 536, Level 16, State 5, Line 124
Invalid length parameter passed to the SUBSTRING function.

(4 row(s) affected)

(4 row(s) affected)

(4 row(s) affected)
Msg 536, Level 16, State 5, Line 124
Invalid length parameter passed to the SUBSTRING function.

(1 row(s) affected)
Msg 536, Level 16, State 5, Line 124
Invalid length parameter passed to the SUBSTRING function.

(1 row(s) affected)
Msg 536, Level 16, State 5, Line 124
Invalid length parameter passed to the SUBSTRING function.

(1 row(s) affected)
Msg 536, Level 16, State 5, Line 124
Invalid length parameter passed to the SUBSTRING function.

(1 row(s) affected)

(2 row(s) affected)

(2 row(s) affected)
Msg 536, Level 16, State 5, Line 124
Invalid length parameter passed to the SUBSTRING function.

(2 row(s) affected)
Msg 536, Level 16, State 5, Line 124
Invalid length parameter passed to the SUBSTRING function.

(2 row(s) affected)
Msg 536, Level 16, State 5, Line 124
Invalid length parameter passed to the SUBSTRING function.

(2 row(s) affected)
Msg 536, Level 16, State 5, Line 124
Invalid length parameter passed to the SUBSTRING function.

(2 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)
Msg 536, Level 16, State 5, Line 124
Invalid length parameter passed to the SUBSTRING function.

(3 row(s) affected)
Msg 536, Level 16, State 5, Line 124
Invalid length parameter passed to the SUBSTRING function.

(3 row(s) affected)
Msg 536, Level 16, State 5, Line 124
Invalid length parameter passed to the SUBSTRING function.

(3 row(s) affected)
Msg 536, Level 16, State 5, Line 124
Invalid length parameter passed to the SUBSTRING function.

(3 row(s) affected)

(3 row(s) affected)

(3 row(s) affected)
Msg 536, Level 16, State 5, Line 124
Invalid length parameter passed to the SUBSTRING function.

(3 row(s) affected)
Msg 536, Level 16, State 5, Line 124
Invalid length parameter passed to the SUBSTRING function.

(3 row(s) affected)
Msg 536, Level 16, State 5, Line 124
Invalid length parameter passed to the SUBSTRING function.

(3 row(s) affected)
Msg 536, Level 16, State 5, Line 124
Invalid length parameter passed to the SUBSTRING function.

(3 row(s) affected)

(4 row(s) affected)

(4 row(s) affected)
Msg 536, Level 16, State 5, Line 124
Invalid length parameter passed to the SUBSTRING function.

(4 row(s) affected)
Msg 536, Level 16, State 5, Line 124
Invalid length parameter passed to the SUBSTRING function.

(4 row(s) affected)
Msg 536, Level 16, State 5, Line 124
Invalid length parameter passed to the SUBSTRING function.

(4 row(s) affected)
Msg 536, Level 16, State 5, Line 124
Invalid length parameter passed to the SUBSTRING function.

(4 row(s) affected)

(4 row(s) affected)

(4 row(s) affected)
Msg 536, Level 16, State 5, Line 124
Invalid length parameter passed to the SUBSTRING function.

(4 row(s) affected)
Msg 536, Level 16, State 5, Line 124
Invalid length parameter passed to the SUBSTRING function.

(4 row(s) affected)
Msg 536, Level 16, State 5, Line 124
Invalid length parameter passed to the SUBSTRING function.

(4 row(s) affected)
Msg 536, Level 16, State 5, Line 124
Invalid length parameter passed to the SUBSTRING function.

(4 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)
Msg 536, Level 16, State 5, Line 124
Invalid length parameter passed to the SUBSTRING function.

(4 row(s) affected)
Msg 536, Level 16, State 5, Line 124
Invalid length parameter passed to the SUBSTRING function.

(4 row(s) affected)
Msg 536, Level 16, State 5, Line 124
Invalid length parameter passed to the SUBSTRING function.

(4 row(s) affected)
Msg 536, Level 16, State 5, Line 124
Invalid length parameter passed to the SUBSTRING function.

(4 row(s) affected)

(4 row(s) affected)

(4 row(s) affected)
Msg 536, Level 16, State 5, Line 124
Invalid length parameter passed to the SUBSTRING function.

(4 row(s) affected)
Msg 536, Level 16, State 5, Line 124
Invalid length parameter passed to the SUBSTRING function.

(4 row(s) affected)
Msg 536, Level 16, State 5, Line 124
Invalid length parameter passed to the SUBSTRING function.

(4 row(s) affected)
Msg 536, Level 16, State 5, Line 124
Invalid length parameter passed to the SUBSTRING function.

(4 row(s) affected)

(4 row(s) affected)

(4 row(s) affected)
Msg 536, Level 16, State 5, Line 124
Invalid length parameter passed to the SUBSTRING function.

(3 row(s) affected)
Msg 536, Level 16, State 5, Line 124
Invalid length parameter passed to the SUBSTRING function.

(3 row(s) affected)
Msg 536, Level 16, State 5, Line 124
Invalid length parameter passed to the SUBSTRING function.

(3 row(s) affected)
Msg 536, Level 16, State 5, Line 124
Invalid length parameter passed to the SUBSTRING function.

(3 row(s) affected)

(3 row(s) affected)

(3 row(s) affected)
Msg 536, Level 16, State 5, Line 124
Invalid length parameter passed to the SUBSTRING function.

(3 row(s) affected)
Msg 536, Level 16, State 5, Line 124
Invalid length parameter passed to the SUBSTRING function.

(3 row(s) affected)
Msg 536, Level 16, State 5, Line 124
Invalid length parameter passed to the SUBSTRING function.

(3 row(s) affected)
Msg 536, Level 16, State 5, Line 124
Invalid length parameter passed to the SUBSTRING function.

(3 row(s) affected)

(4 row(s) affected)

(4 row(s) affected)
Msg 536, Level 16, State 5, Line 124
Invalid length parameter passed to the SUBSTRING function.

(4 row(s) affected)
Msg 536, Level 16, State 5, Line 124
Invalid length parameter passed to the SUBSTRING function.

(4 row(s) affected)
Msg 536, Level 16, State 5, Line 124
Invalid length parameter passed to the SUBSTRING function.

(4 row(s) affected)
Msg 536, Level 16, State 5, Line 124
Invalid length parameter passed to the SUBSTRING function.

(4 row(s) affected)

(4 row(s) affected)

(4 row(s) affected)
Msg 536, Level 16, State 5, Line 124
Invalid length parameter passed to the SUBSTRING function.

(4 row(s) affected)
Msg 536, Level 16, State 5, Line 124
Invalid length parameter passed to the SUBSTRING function.

(4 row(s) affected)
Msg 536, Level 16, State 5, Line 124
Invalid length parameter passed to the SUBSTRING function.

(4 row(s) affected)
Msg 536, Level 16, State 5, Line 124
Invalid length parameter passed to the SUBSTRING function.

(4 row(s) affected)

(4 row(s) affected)

(4 row(s) affected)
Msg 536, Level 16, State 5, Line 124
Invalid length parameter passed to the SUBSTRING function.

(4 row(s) affected)
Msg 536, Level 16, State 5, Line 124
Invalid length parameter passed to the SUBSTRING function.

(4 row(s) affected)
Msg 536, Level 16, State 5, Line 124
Invalid length parameter passed to the SUBSTRING function.

(4 row(s) affected)
Msg 536, Level 16, State 5, Line 124
Invalid length parameter passed to the SUBSTRING function.

(4 row(s) affected)

(4 row(s) affected)

(4 row(s) affected)
Msg 536, Level 16, State 5, Line 124
Invalid length parameter passed to the SUBSTRING function.

(4 row(s) affected)
Msg 536, Level 16, State 5, Line 124
Invalid length parameter passed to the SUBSTRING function.

(4 row(s) affected)
Msg 536, Level 16, State 5, Line 124
Invalid length parameter passed to the SUBSTRING function.

(4 row(s) affected)
Msg 536, Level 16, State 5, Line 124
Invalid length parameter passed to the SUBSTRING function.

(4 row(s) affected)

(4 row(s) affected)

(4 row(s) affected)
Msg 536, Level 16, State 5, Line 124
Invalid length parameter passed to the SUBSTRING function.

(4 row(s) affected)
Msg 536, Level 16, State 5, Line 124
Invalid length parameter passed to the SUBSTRING function.

(4 row(s) affected)
Msg 536, Level 16, State 5, Line 124
Invalid length parameter passed to the SUBSTRING function.

(4 row(s) affected)
Msg 536, Level 16, State 5, Line 124
Invalid length parameter passed to the SUBSTRING function.

(4 row(s) affected)

(4 row(s) affected)

(4 row(s) affected)
Msg 536, Level 16, State 5, Line 124
Invalid length parameter passed to the SUBSTRING function.

(4 row(s) affected)
Msg 536, Level 16, State 5, Line 124
Invalid length parameter passed to the SUBSTRING function.

(4 row(s) affected)
Msg 536, Level 16, State 5, Line 124
Invalid length parameter passed to the SUBSTRING function.

(4 row(s) affected)
Msg 536, Level 16, State 5, Line 124
Invalid length parameter passed to the SUBSTRING function.

(4 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)
Msg 536, Level 16, State 5, Line 124
Invalid length parameter passed to the SUBSTRING function.

(4 row(s) affected)
Msg 536, Level 16, State 5, Line 124
Invalid length parameter passed to the SUBSTRING function.

(4 row(s) affected)
Msg 536, Level 16, State 5, Line 124
Invalid length parameter passed to the SUBSTRING function.

(4 row(s) affected)
Msg 536, Level 16, State 5, Line 124
Invalid length parameter passed to the SUBSTRING function.

(4 row(s) affected)

(4 row(s) affected)

(4 row(s) affected)
Msg 536, Level 16, State 5, Line 124
Invalid length parameter passed to the SUBSTRING function.

(4 row(s) affected)
Msg 536, Level 16, State 5, Line 124
Invalid length parameter passed to the SUBSTRING function.

(4 row(s) affected)
Msg 536, Level 16, State 5, Line 124
Invalid length parameter passed to the SUBSTRING function.

(4 row(s) affected)
Msg 536, Level 16, State 5, Line 124
Invalid length parameter passed to the SUBSTRING function.

(4 row(s) affected)

(4 row(s) affected)

(4 row(s) affected)
Msg 536, Level 16, State 5, Line 124
Invalid length parameter passed to the SUBSTRING function.

(1 row(s) affected)
Msg 536, Level 16, State 5, Line 124
Invalid length parameter passed to the SUBSTRING function.

(1 row(s) affected)
Msg 536, Level 16, State 5, Line 124
Invalid length parameter passed to the SUBSTRING function.

(1 row(s) affected)
Msg 536, Level 16, State 5, Line 124
Invalid length parameter passed to the SUBSTRING function.

(1 row(s) affected)

(3 row(s) affected)

(3 row(s) affected)
Msg 536, Level 16, State 5, Line 124
Invalid length parameter passed to the SUBSTRING function.

(3 row(s) affected)
Msg 536, Level 16, State 5, Line 124
Invalid length parameter passed to the SUBSTRING function.

(3 row(s) affected)
Msg 536, Level 16, State 5, Line 124
Invalid length parameter passed to the SUBSTRING function.

(3 row(s) affected)
Msg 536, Level 16, State 5, Line 124
Invalid length parameter passed to the SUBSTRING function.

(3 row(s) affected)

(3 row(s) affected)

(3 row(s) affected)
Msg 536, Level 16, State 5, Line 124
Invalid length parameter passed to the SUBSTRING function.

(3 row(s) affected)
Msg 536, Level 16, State 5, Line 124
Invalid length parameter passed to the SUBSTRING function.

(3 row(s) affected)
Msg 536, Level 16, State 5, Line 124
Invalid length parameter passed to the SUBSTRING function.

(3 row(s) affected)
Msg 536, Level 16, State 5, Line 124
Invalid length parameter passed to the SUBSTRING function.

(3 row(s) affected)

(3 row(s) affected)

(3 row(s) affected)
Msg 536, Level 16, State 5, Line 124
Invalid length parameter passed to the SUBSTRING function.

(3 row(s) affected)
Msg 536, Level 16, State 5, Line 124
Invalid length parameter passed to the SUBSTRING function.

(3 row(s) affected)
Msg 536, Level 16, State 5, Line 124
Invalid length parameter passed to the SUBSTRING function.

(3 row(s) affected)
Msg 536, Level 16, State 5, Line 124
Invalid length parameter passed to the SUBSTRING function.

(3 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)
Msg 536, Level 16, State 5, Line 124
Invalid length parameter passed to the SUBSTRING function.

(1 row(s) affected)
Msg 536, Level 16, State 5, Line 124
Invalid length parameter passed to the SUBSTRING function.

(1 row(s) affected)
Msg 536, Level 16, State 5, Line 124
Invalid length parameter passed to the SUBSTRING function.

(1 row(s) affected)
Msg 536, Level 16, State 5, Line 124
Invalid length parameter passed to the SUBSTRING function.

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)
Msg 536, Level 16, State 5, Line 124
Invalid length parameter passed to the SUBSTRING function.

(4 row(s) affected)
Msg 536, Level 16, State 5, Line 124
Invalid length parameter passed to the SUBSTRING function.

(4 row(s) affected)
Msg 536, Level 16, State 5, Line 124
Invalid length parameter passed to the SUBSTRING function.

(4 row(s) affected)
Msg 536, Level 16, State 5, Line 124
Invalid length parameter passed to the SUBSTRING function.

(4 row(s) affected)

(4 row(s) affected)

(4 row(s) affected)
Msg 536, Level 16, State 5, Line 124
Invalid length parameter passed to the SUBSTRING function.

(4 row(s) affected)
Msg 536, Level 16, State 5, Line 124
Invalid length parameter passed to the SUBSTRING function.

(4 row(s) affected)
Msg 536, Level 16, State 5, Line 124
Invalid length parameter passed to the SUBSTRING function.

(4 row(s) affected)
Msg 536, Level 16, State 5, Line 124
Invalid length parameter passed to the SUBSTRING function.

(4 row(s) affected)

(4 row(s) affected)

(4 row(s) affected)
Msg 536, Level 16, State 5, Line 124
Invalid length parameter passed to the SUBSTRING function.

(1 row(s) affected)
Msg 536, Level 16, State 5, Line 124
Invalid length parameter passed to the SUBSTRING function.

(1 row(s) affected)
Msg 536, Level 16, State 5, Line 124
Invalid length parameter passed to the SUBSTRING function.

(1 row(s) affected)
Msg 536, Level 16, State 5, Line 124
Invalid length parameter passed to the SUBSTRING function.

(1 row(s) affected)

(3 row(s) affected)

(3 row(s) affected)
Msg 536, Level 16, State 5, Line 124
Invalid length parameter passed to the SUBSTRING function.

(3 row(s) affected)
Msg 536, Level 16, State 5, Line 124
Invalid length parameter passed to the SUBSTRING function.

(3 row(s) affected)
Msg 536, Level 16, State 5, Line 124
Invalid length parameter passed to the SUBSTRING function.

(3 row(s) affected)
Msg 536, Level 16, State 5, Line 124
Invalid length parameter passed to the SUBSTRING function.

(3 row(s) affected)

(3 row(s) affected)

(3 row(s) affected)
Msg 536, Level 16, State 5, Line 124
Invalid length parameter passed to the SUBSTRING function.

(2 row(s) affected)
Msg 536, Level 16, State 5, Line 124
Invalid length parameter passed to the SUBSTRING function.

(2 row(s) affected)
Msg 536, Level 16, State 5, Line 124
Invalid length parameter passed to the SUBSTRING function.

(2 row(s) affected)
Msg 536, Level 16, State 5, Line 124
Invalid length parameter passed to the SUBSTRING function.

(2 row(s) affected)

(2 row(s) affected)

(2 row(s) affected)
Msg 536, Level 16, State 5, Line 124
Invalid length parameter passed to the SUBSTRING function.

(1 row(s) affected)
Msg 536, Level 16, State 5, Line 124
Invalid length parameter passed to the SUBSTRING function.

(1 row(s) affected)
Msg 536, Level 16, State 5, Line 124
Invalid length parameter passed to the SUBSTRING function.

(1 row(s) affected)
Msg 536, Level 16, State 5, Line 124
Invalid length parameter passed to the SUBSTRING function.

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)
Msg 536, Level 16, State 5, Line 124
Invalid length parameter passed to the SUBSTRING function.

(1 row(s) affected)
Msg 536, Level 16, State 5, Line 124
Invalid length parameter passed to the SUBSTRING function.

(1 row(s) affected)
Msg 536, Level 16, State 5, Line 124
Invalid length parameter passed to the SUBSTRING function.

(1 row(s) affected)
Msg 536, Level 16, State 5, Line 124
Invalid length parameter passed to the SUBSTRING function.
-- Some other code here before the problem area
DECLARE @interestChildId bigint, @parentId bigint, @srchId bigint, @curApplId bigint
DECLARE @interestName VARCHAR(100)
DECLARE @name as VARCHAR(1000)
SET @Name = ''
 
Declare curApplicationRow Cursor FOR
SELECT RchChildId, Id from CtsiApplication
 
Open curApplicationRow
FETCH NEXT FROM curApplicationRow
INTO @interestChildId, @curApplId
 
WHILE @@FETCH_STATUS =0  --GO THROUGH EACH RECORD
BEGIN
	--The following select will get us the 1st child id for Rsch interest
    SELECT @Name = dbo.ResearchInterests.Name + ', ' + @Name
    from dbo.ResearchInterests
    WHERE dbo.ResearchInterests.Id = @interestChildId
 
	SELECT @srchId = dbo.ResearchInterests.ParentResearchInterest_id
	from dbo.ResearchInterests
	WHERE dbo.ResearchInterests.Id = @interestChildId
 
 
--INSERT INTO [CtsiMembershipProduction].[dbo].[Interest]([Name])
--     VALUES
--           (interestName)
 
	WHILE(@srchId <> NULL)--USE THE PARENTID TO TRAVERSE TO ITS PARENT NODE UNTIL REACHES ROOT NODE
	BEGIN
 
		SELECT @Name = dbo.ResearchInterests.Name + ', ' + @Name
		from dbo.ResearchInterests
		WHERE dbo.ResearchInterests.Id = @interestChildId
 
		SELECT @srchId = dbo.ResearchInterests.ParentResearchInterest_id
		from dbo.ResearchInterests
		WHERE dbo.ResearchInterests.Id = @interestChildId
 
	END--We're done retrieving all the Research interest
 
	--Now, write the top 4 found Interest to the table
	DECLARE @FirstName as varchar(100), @counter int
	SET @counter = 0
	WHILE((len(@name) > 0) and (@counter <4))--Get the top 4 
	BEGIN
		if (CHARINDEX(',',@Name) > 0)
		BEGIN
			SET @FirstName = LEFT(@Name,CHARINDEX(',',@Name))
			SET @Name = SUBSTRING(@Name,CHARINDEX(',',@Name) + 2, LEN(@Name) - CHARINDEX(',',@Name) -2)   -- THERE is maybe some ajustement to do here with the +2 and minus 2 to remove the comma and the blank space, I didn't try this code
		END
		ELSE
		BEGIN
		   SET @FirstName = @Name
		   SET @Name = ''
	   END
		  --- @FirstName containing the first name of @Name and @Name now have left the first name until it is empty
		if(@counter = 0)
			UPDATE [CtsiMembershipProduction].[dbo].[CtsiApplication]
			   SET [Research Interest 1] = @Name
			 WHERE [CtsiMembershipProduction].[dbo].[CtsiApplication].Id = @curApplId
		else if(@counter = 1)
			UPDATE [CtsiMembershipProduction].[dbo].[CtsiApplication]
			   SET [Research Interest 2] = @Name
			 WHERE [CtsiMembershipProduction].[dbo].[CtsiApplication].Id = @curApplId	
		else if(@counter = 2)
			UPDATE [CtsiMembershipProduction].[dbo].[CtsiApplication]
			   SET [Research Interest 3] = @Name
			 WHERE [CtsiMembershipProduction].[dbo].[CtsiApplication].Id = @curApplId
		else if(@counter = 3)
			UPDATE [CtsiMembershipProduction].[dbo].[CtsiApplication]
			   SET [Research Interest 4] = @Name
			 WHERE [CtsiMembershipProduction].[dbo].[CtsiApplication].Id = @curApplId
 
		Set @counter = @counter+1
	END 
 
 
 
	FETCH NEXT FROM curApplicationRow
	INTO @interestChildId, @curApplId
END
 
--Remove the unwanted child id columns
ALTER TABLE CtsiApplication DROP RchChildId
--DROP TABLE [dbo].[Interest]
CLOSE curApplicationRow
DEALLOCATE curApplicationRow

Open in new window

0
Comment
Question by:lapucca
  • 2
  • 2
5 Comments
 
LVL 16

Expert Comment

by:brad2575
ID: 22740442
If you are just trying to get the last name this may be easier since you already have the first name:

SET @FirstName = LEFT(@Name,CHARINDEX(',',@Name))
SET @Name = Replace(@Name, @FirstName + ',', '')

This will just remove the first name (and the comma) from the @name field to get the last name.





0
 
LVL 6

Expert Comment

by:openshac
ID: 22740462
The following line fails when @Name does not contain ','
SET @Name = SUBSTRING(@Name,CHARINDEX(',',@Name) + 2, LEN(@Name) - CHARINDEX(',',@Name) -2)   -- THERE is maybe some ajustement to do here with the +2 and minus 2 to remove the comma and the blank space, I didn't try this code
		

Open in new window

0
 
LVL 16

Accepted Solution

by:
brad2575 earned 500 total points
ID: 22740487
Also if the field is null when using charindex it returns NULL NOT a number so you can do this on your if check above:

if (CHARINDEX(',',@Name) > 0) AND CHARINDEX(',',@Name) IS NOT NULL
0
 

Author Comment

by:lapucca
ID: 22745249
I'm trying to get each token stored in @name that is separated by a comma ','.  This seems to to causing lot of error.  What's the best way to do this?  Thank you.
0
 

Author Comment

by:lapucca
ID: 22745421
Hi I added the code check that Brad suggested but I'm still getting SUBSTRING erros.  Can't tell if the number is cut down or not.  I'm putting the error in the code snippet since there's quite a bit of it.
	if (CHARINDEX(',',@Name) > 0) AND CHARINDEX(',',@Name) IS NOT NULL
	BEGIN
		--Now, write the top 4 found Interest to the table
		DECLARE @FirstName as varchar(100), @counter int
		SET @counter = 0
		WHILE((len(@name) > 0) and (@counter <4))--Get the top 4 
		BEGIN
			if (CHARINDEX(',',@Name) > 0)
			BEGIN
				SET @FirstName = LEFT(@Name,CHARINDEX(',',@Name))
				SET @Name = SUBSTRING(@Name,CHARINDEX(',',@Name) + 2, LEN(@Name) - CHARINDEX(',',@Name) -2)   -- THERE is maybe some ajustement to do here with the +2 and minus 2 to remove the comma and the blank space, I didn't try this code
			END
			ELSE
			BEGIN
			   SET @FirstName = @Name
			   SET @Name = ''
		   END
			  --- @FirstName containing the first name of @Name and @Name now have left the first name until it is empty
			if(@counter = 0)
				UPDATE [CtsiMembershipProduction].[dbo].[CtsiApplication]
				   SET [Research Interest 1] = @Name
				 WHERE [CtsiMembershipProduction].[dbo].[CtsiApplication].Id = @curApplId
			else if(@counter = 1)
				UPDATE [CtsiMembershipProduction].[dbo].[CtsiApplication]
				   SET [Research Interest 2] = @Name
				 WHERE [CtsiMembershipProduction].[dbo].[CtsiApplication].Id = @curApplId	
			else if(@counter = 2)
				UPDATE [CtsiMembershipProduction].[dbo].[CtsiApplication]
				   SET [Research Interest 3] = @Name
				 WHERE [CtsiMembershipProduction].[dbo].[CtsiApplication].Id = @curApplId
			else if(@counter = 3)
				UPDATE [CtsiMembershipProduction].[dbo].[CtsiApplication]
				   SET [Research Interest 4] = @Name
				 WHERE [CtsiMembershipProduction].[dbo].[CtsiApplication].Id = @curApplId
 
			Set @counter = @counter+1
		END 
	END--end if more than 1 names collected
	ELSE if (CHARINDEX(',',@Name) > 0)
		UPDATE [CtsiMembershipProduction].[dbo].[CtsiApplication]
		   SET [Research Interest 1] = @Name
		 WHERE [CtsiMembershipProduction].[dbo].[CtsiApplication].Id = @curApplId
 
 
 
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(4 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(4 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(4 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(4 row(s) affected)
 
(4 row(s) affected)
 
(4 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(1 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(1 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(1 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(1 row(s) affected)
 
(3 row(s) affected)
 
(3 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(3 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(3 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(3 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(3 row(s) affected)
 
(3 row(s) affected)
 
(3 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(2 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(2 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(2 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(2 row(s) affected)
 
(2 row(s) affected)
 
(2 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(1 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(1 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(1 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(1 row(s) affected)
 
(3 row(s) affected)
 
(3 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(3 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(3 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(3 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(3 row(s) affected)
 
(3 row(s) affected)
 
(3 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(1 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(1 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(1 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(1 row(s) affected)
 
(4 row(s) affected)
 
(4 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(4 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(4 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(4 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(4 row(s) affected)
 
(4 row(s) affected)
 
(4 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(4 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(4 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(4 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(4 row(s) affected)
 
(4 row(s) affected)
 
(4 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(4 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(4 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(4 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(4 row(s) affected)
 
(4 row(s) affected)
 
(4 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(4 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(4 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(4 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(4 row(s) affected)
 
(1 row(s) affected)
 
(1 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(4 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(4 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(4 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(4 row(s) affected)
 
(4 row(s) affected)
 
(4 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(4 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(4 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(4 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(4 row(s) affected)
 
(4 row(s) affected)
 
(4 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(1 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(1 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(1 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(1 row(s) affected)
 
(1 row(s) affected)
 
(1 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(4 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(4 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(4 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(4 row(s) affected)
 
(4 row(s) affected)
 
(4 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(4 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(4 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(4 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(4 row(s) affected)
 
(4 row(s) affected)
 
(4 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(1 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(1 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(1 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(1 row(s) affected)
 
(1 row(s) affected)
 
(1 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(1 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(1 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(1 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(1 row(s) affected)
 
(4 row(s) affected)
 
(4 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(4 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(4 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(4 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(4 row(s) affected)
 
(4 row(s) affected)
 
(4 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(4 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(4 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(4 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(4 row(s) affected)
 
(1 row(s) affected)
 
(1 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(1 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(1 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(1 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(1 row(s) affected)
 
(1 row(s) affected)
 
(1 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(4 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(4 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(4 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(4 row(s) affected)
 
(4 row(s) affected)
 
(4 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(4 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(4 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(4 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(4 row(s) affected)
 
(4 row(s) affected)
 
(4 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(3 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(3 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(3 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(3 row(s) affected)
 
(3 row(s) affected)
 
(3 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(3 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(3 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(3 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(3 row(s) affected)
 
(3 row(s) affected)
 
(3 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(3 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(3 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(3 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(3 row(s) affected)
 
(3 row(s) affected)
 
(3 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(3 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(3 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(3 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(3 row(s) affected)
 
(3 row(s) affected)
 
(3 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(3 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(3 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(3 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(3 row(s) affected)
 
(4 row(s) affected)
 
(4 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(4 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(4 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(4 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(4 row(s) affected)
 
(4 row(s) affected)
 
(4 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(4 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(4 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(4 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(4 row(s) affected)
 
(1 row(s) affected)
 
(1 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(4 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(4 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(4 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(4 row(s) affected)
 
(4 row(s) affected)
 
(4 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(4 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(4 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(4 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(4 row(s) affected)
 
(4 row(s) affected)
 
(4 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(3 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(3 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(3 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(3 row(s) affected)
 
(3 row(s) affected)
 
(3 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(3 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(3 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(3 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(3 row(s) affected)
 
(3 row(s) affected)
 
(3 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(3 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(3 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(3 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(3 row(s) affected)
 
(3 row(s) affected)
 
(3 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(2 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(2 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(2 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(2 row(s) affected)
 
(2 row(s) affected)
 
(2 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(2 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(2 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(2 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(2 row(s) affected)
 
(2 row(s) affected)
 
(2 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(1 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(1 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(1 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(1 row(s) affected)
 
(1 row(s) affected)
 
(1 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(2 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(2 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(2 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(2 row(s) affected)
 
(2 row(s) affected)
 
(2 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(4 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(4 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(4 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(4 row(s) affected)
 
(4 row(s) affected)
 
(4 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(4 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(4 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(4 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(4 row(s) affected)
 
(4 row(s) affected)
 
(4 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(2 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(2 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(2 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(2 row(s) affected)
 
(2 row(s) affected)
 
(2 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(4 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(4 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(4 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(4 row(s) affected)
 
(4 row(s) affected)
 
(4 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(4 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(4 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(4 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(4 row(s) affected)
 
(4 row(s) affected)
 
(4 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(4 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(4 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(4 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(4 row(s) affected)
 
(4 row(s) affected)
 
(4 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(4 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(4 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(4 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(4 row(s) affected)
 
(4 row(s) affected)
 
(4 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(1 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(1 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(1 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(1 row(s) affected)
 
(1 row(s) affected)
 
(1 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(3 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(3 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(3 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(3 row(s) affected)
 
(3 row(s) affected)
 
(3 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(3 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(3 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(3 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(3 row(s) affected)
 
(1 row(s) affected)
 
(1 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(1 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(1 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(1 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(1 row(s) affected)
 
(1 row(s) affected)
 
(1 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(1 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(1 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(1 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(1 row(s) affected)
 
(1 row(s) affected)
 
(1 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(1 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(1 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(1 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(1 row(s) affected)
 
(1 row(s) affected)
 
(1 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(3 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(3 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(3 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(3 row(s) affected)
 
(3 row(s) affected)
 
(3 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(3 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(3 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(3 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(3 row(s) affected)
 
(4 row(s) affected)
 
(4 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(4 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(4 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(4 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(4 row(s) affected)
 
(4 row(s) affected)
 
(4 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(4 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(4 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(4 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(4 row(s) affected)
 
(2 row(s) affected)
 
(2 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(2 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(2 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(2 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(2 row(s) affected)
 
(2 row(s) affected)
 
(2 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(2 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(2 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(2 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(2 row(s) affected)
 
(4 row(s) affected)
 
(4 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(4 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(4 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(4 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(4 row(s) affected)
 
(4 row(s) affected)
 
(4 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(4 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(4 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(4 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(4 row(s) affected)
 
(3 row(s) affected)
 
(3 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(3 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(3 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(3 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(3 row(s) affected)
 
(3 row(s) affected)
 
(3 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(1 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(1 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(1 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(1 row(s) affected)
 
(3 row(s) affected)
 
(3 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(3 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(3 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(3 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(3 row(s) affected)
 
(3 row(s) affected)
 
(3 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(4 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(4 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(4 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(4 row(s) affected)
 
(4 row(s) affected)
 
(4 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(4 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(4 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(4 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(4 row(s) affected)
 
(4 row(s) affected)
 
(4 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(4 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(4 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(4 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(4 row(s) affected)
 
(4 row(s) affected)
 
(4 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(4 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(4 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(4 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(4 row(s) affected)
 
(4 row(s) affected)
 
(4 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(1 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(1 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(1 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(1 row(s) affected)
 
(1 row(s) affected)
 
(1 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(4 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(4 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(4 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(4 row(s) affected)
 
(4 row(s) affected)
 
(4 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(4 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(4 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(4 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(4 row(s) affected)
 
(4 row(s) affected)
 
(4 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(1 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(1 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(1 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(1 row(s) affected)
 
(2 row(s) affected)
 
(2 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(2 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(2 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(2 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(2 row(s) affected)
 
(3 row(s) affected)
 
(3 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(3 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(3 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(3 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(3 row(s) affected)
 
(3 row(s) affected)
 
(3 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(2 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(2 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(2 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(2 row(s) affected)
 
(2 row(s) affected)
 
(2 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(4 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(4 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(4 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(4 row(s) affected)
 
(4 row(s) affected)
 
(4 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(4 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(4 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(4 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(4 row(s) affected)
 
(4 row(s) affected)
 
(4 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(2 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(2 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(2 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(2 row(s) affected)
 
(2 row(s) affected)
 
(2 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(2 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(2 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(2 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(2 row(s) affected)
 
(2 row(s) affected)
 
(2 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(2 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(2 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(2 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(2 row(s) affected)
 
(2 row(s) affected)
 
(2 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(4 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(4 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(4 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(4 row(s) affected)
 
(4 row(s) affected)
 
(4 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(4 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(4 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(4 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(4 row(s) affected)
 
(4 row(s) affected)
 
(4 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(4 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(4 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(4 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(4 row(s) affected)
 
(4 row(s) affected)
 
(4 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(4 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(4 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(4 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(4 row(s) affected)
 
(4 row(s) affected)
 
(4 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(1 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(1 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(1 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(1 row(s) affected)
 
(1 row(s) affected)
 
(1 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(2 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(2 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(2 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(2 row(s) affected)
 
(2 row(s) affected)
 
(2 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(3 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(3 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(3 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(3 row(s) affected)
 
(3 row(s) affected)
 
(3 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(3 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(3 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(3 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(3 row(s) affected)
 
(1 row(s) affected)
 
(1 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(4 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(4 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(4 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(4 row(s) affected)
 
(4 row(s) affected)
 
(4 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(4 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(4 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(4 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(4 row(s) affected)
 
(4 row(s) affected)
 
(4 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(4 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(4 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(4 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(4 row(s) affected)
 
(4 row(s) affected)
 
(4 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(4 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(4 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(4 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(4 row(s) affected)
 
(4 row(s) affected)
 
(4 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(1 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(1 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(1 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(1 row(s) affected)
 
(4 row(s) affected)
 
(4 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(4 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(4 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(4 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(4 row(s) affected)
 
(4 row(s) affected)
 
(4 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(4 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(4 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(4 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(4 row(s) affected)
 
(2 row(s) affected)
 
(2 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(2 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(2 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(2 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(2 row(s) affected)
 
(4 row(s) affected)
 
(4 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(4 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(4 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(4 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(4 row(s) affected)
 
(4 row(s) affected)
 
(4 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(4 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(4 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(4 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(4 row(s) affected)
 
(4 row(s) affected)
 
(4 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(4 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(4 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(4 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(4 row(s) affected)
 
(4 row(s) affected)
 
(4 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(4 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(4 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(4 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(4 row(s) affected)
 
(1 row(s) affected)
 
(1 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(4 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(4 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(4 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(4 row(s) affected)
 
(4 row(s) affected)
 
(4 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(4 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(4 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(4 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(4 row(s) affected)
 
(4 row(s) affected)
 
(4 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(4 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(4 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(4 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(4 row(s) affected)
 
(4 row(s) affected)
 
(4 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(4 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(4 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(4 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(4 row(s) affected)
 
(4 row(s) affected)
 
(4 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(2 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(2 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(2 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(2 row(s) affected)
 
(2 row(s) affected)
 
(2 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(4 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(4 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(4 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(4 row(s) affected)
 
(4 row(s) affected)
 
(4 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(4 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(4 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(4 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(4 row(s) affected)
 
(4 row(s) affected)
 
(4 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(3 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(3 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(3 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(3 row(s) affected)
 
(3 row(s) affected)
 
(3 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(3 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(3 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(3 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(3 row(s) affected)
 
(4 row(s) affected)
 
(4 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(4 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(4 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(4 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(4 row(s) affected)
 
(4 row(s) affected)
 
(4 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(4 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(4 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(4 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(4 row(s) affected)
 
(4 row(s) affected)
 
(4 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(4 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(4 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(4 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(4 row(s) affected)
 
(4 row(s) affected)
 
(4 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(4 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(4 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(4 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(4 row(s) affected)
 
(4 row(s) affected)
 
(4 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(4 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(4 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(4 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(4 row(s) affected)
 
(4 row(s) affected)
 
(4 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(4 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(4 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(4 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(4 row(s) affected)
 
(4 row(s) affected)
 
(4 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(4 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(4 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(4 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(4 row(s) affected)
 
(4 row(s) affected)
 
(4 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(4 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(4 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(4 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(4 row(s) affected)
 
(3 row(s) affected)
 
(3 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(3 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(3 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(3 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(3 row(s) affected)
 
(3 row(s) affected)
 
(3 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(1 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(1 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(1 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(1 row(s) affected)
 
(4 row(s) affected)
 
(4 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(4 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(4 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(4 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(4 row(s) affected)
 
(4 row(s) affected)
 
(4 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(4 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(4 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(4 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(4 row(s) affected)
 
(4 row(s) affected)
 
(4 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(4 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(4 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(4 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(4 row(s) affected)
 
(4 row(s) affected)
 
(4 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(4 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(4 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(4 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(4 row(s) affected)
 
(1 row(s) affected)
 
(1 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(1 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(1 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(1 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(1 row(s) affected)
 
(2 row(s) affected)
 
(2 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(2 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(2 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(2 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(2 row(s) affected)
 
(4 row(s) affected)
 
(4 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(4 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(4 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(4 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(4 row(s) affected)
 
(4 row(s) affected)
 
(4 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(4 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(4 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(4 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(4 row(s) affected)
 
(2 row(s) affected)
 
(2 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(2 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(2 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(2 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(2 row(s) affected)
 
(1 row(s) affected)
 
(1 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(1 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(1 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(1 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(1 row(s) affected)
 
(4 row(s) affected)
 
(4 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(4 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(4 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(4 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(4 row(s) affected)
 
(4 row(s) affected)
 
(4 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(4 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(4 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(4 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(4 row(s) affected)
 
(1 row(s) affected)
 
(1 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(4 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(4 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(4 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(4 row(s) affected)
 
(4 row(s) affected)
 
(4 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(4 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(4 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(4 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(4 row(s) affected)
 
(4 row(s) affected)
 
(4 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(3 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(3 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(3 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(3 row(s) affected)
 
(3 row(s) affected)
 
(3 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(3 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(3 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(3 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(3 row(s) affected)
 
(1 row(s) affected)
 
(1 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(1 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(1 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(1 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(1 row(s) affected)
 
(2 row(s) affected)
 
(2 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(2 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(2 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(2 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(2 row(s) affected)
 
(4 row(s) affected)
 
(4 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(4 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(4 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(4 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(4 row(s) affected)
 
(4 row(s) affected)
 
(4 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(4 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(4 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(4 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(4 row(s) affected)
 
(1 row(s) affected)
 
(1 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(4 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(4 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(4 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(4 row(s) affected)
 
(4 row(s) affected)
 
(4 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(4 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(4 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(4 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(4 row(s) affected)
 
(4 row(s) affected)
 
(4 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(1 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(1 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(1 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(1 row(s) affected)
 
(1 row(s) affected)
 
(1 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(3 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(3 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(3 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(3 row(s) affected)
 
(3 row(s) affected)
 
(3 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(3 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(3 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(3 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(3 row(s) affected)
 
(1 row(s) affected)
 
(1 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(4 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(4 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(4 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(4 row(s) affected)
 
(4 row(s) affected)
 
(4 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(4 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(4 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(4 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(4 row(s) affected)
 
(4 row(s) affected)
 
(4 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(1 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(1 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(1 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(1 row(s) affected)
 
(2 row(s) affected)
 
(2 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(2 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(2 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(2 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(2 row(s) affected)
 
(2 row(s) affected)
 
(2 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(2 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(2 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(2 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(2 row(s) affected)
 
(4 row(s) affected)
 
(4 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(4 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(4 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(4 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(4 row(s) affected)
 
(4 row(s) affected)
 
(4 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(4 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(4 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(4 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(4 row(s) affected)
 
(4 row(s) affected)
 
(4 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(4 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(4 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(4 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(4 row(s) affected)
 
(4 row(s) affected)
 
(4 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(4 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(4 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(4 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(4 row(s) affected)
 
(4 row(s) affected)
 
(4 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(4 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(4 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(4 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(4 row(s) affected)
 
(4 row(s) affected)
 
(4 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(4 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(4 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(4 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(4 row(s) affected)
 
(4 row(s) affected)
 
(4 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(4 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(4 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(4 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(4 row(s) affected)
 
(4 row(s) affected)
 
(4 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(4 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(4 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(4 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(4 row(s) affected)
 
(1 row(s) affected)
 
(1 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(4 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(4 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(4 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(4 row(s) affected)
 
(4 row(s) affected)
 
(4 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(4 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(4 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(4 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(4 row(s) affected)
 
(4 row(s) affected)
 
(4 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(1 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(1 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(1 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(1 row(s) affected)
 
(4 row(s) affected)
 
(4 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(4 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(4 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(4 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(4 row(s) affected)
 
(4 row(s) affected)
 
(4 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(4 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(4 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(4 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(4 row(s) affected)
 
(2 row(s) affected)
 
(2 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(2 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(2 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(2 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(2 row(s) affected)
 
(4 row(s) affected)
 
(4 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(4 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(4 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(4 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(4 row(s) affected)
 
(4 row(s) affected)
 
(4 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(4 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(4 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(4 row(s) affected)
Msg 536, Level 16, State 5, Line 126
Invalid length parameter passed to the SUBSTRING function.
 
(4 row(s) affected)
Msg 3728, Level 16, State 1, Line 166
'RchChildId' is not a constraint.
Msg 3727, Level 16, State 0, Line 166
Could not drop constraint. See previous errors.

Open in new window

0

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Introduction Hopefully the following mnemonic and, ultimately, the acronym it represents is common place to all those reading: Please Excuse My Dear Aunt Sally (PEMDAS). Briefly, though, PEMDAS is used to signify the order of operations (http://en.…
If you find yourself in this situation “I have used SELECT DISTINCT but I’m getting duplicates” then I'm sorry to say you are using the wrong SQL technique as it only does one thing which is: produces whole rows that are unique. If the results you a…
In an interesting question (https://www.experts-exchange.com/questions/29008360/) here at Experts Exchange, a member asked how to split a single image into multiple images. The primary usage for this is to place many photographs on a flatbed scanner…
I've attached the XLSM Excel spreadsheet I used in the video and also text files containing the macros used below. https://filedb.experts-exchange.com/incoming/2017/03_w12/1151775/Permutations.txt https://filedb.experts-exchange.com/incoming/201…

820 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question