• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 489
  • Last Modified:

Need help with syntax error on SUBSTRING

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
lapucca
Asked:
lapucca
  • 2
  • 2
1 Solution
 
brad2575Commented:
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
 
openshacCommented:
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
 
brad2575Commented:
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
 
lapuccaAuthor Commented:
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
 
lapuccaAuthor Commented:
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: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now