This is because one of the CHARINDEX is returning 0 (string not found) and being subtracted from resulting in a negative number for length to a substring, hence the error.

What...

Deleted answer, thought I had it but

Unless I missed something here

The column has a bit data type

Therefore can only be null,0 ro 1

Dang... missed that one, David... nice catch.

Thanks Jeff

But it is...

STUFF(STUFF(comment,CHARINDEX('Seam:',comment)+5,0,REPLICATE('0',8-(CHARINDEX('Roll:',comment)-CHARINDEX('Seam:',comment)))),8,0,REPLICATE('0',13-CHARINDEX('Seam:',comment)))

What values do you want from your example, eg to get the Bar Codes

STUFF(comment,1,CHARINDEX('Bar Code:',comment)+8,'')

Requirement is to show missing months as well 

DECLARE @from datetime, @diff int

SELECT @from = DATEADD(month,DATEDIFF(month,0,MIN([Date])),0),

@diff = DATEDIFF(month,MIN([Date]),MAX([Date]))

FROM @Table

SELECT STUFF(CAST(d.[Date] as...

Yes it can have any number of input and output paramters

EXECUTE sp_executesql @strSQL, N'@x int OUTPUT,@y int OUTPUT', @x OUTPUT, @y OUTPUT

You can use an undocumented procedure

sp_msforeachtable 'SELECT ''?'',COUNT(*) FROM ?'

also you could create a temp table and insert the results to it

use sp_executesql instead

DECLARE @x INT

DECLARE @strSQL VARCHAR (2000)

DECLARE @dbname VARCHAR (50)

SET @dbname = 'A40001_1'

SET @strSQL = 'SELECT @x = MAX(Key_ID) FROM ' + @dbname + '.dbo.TableABC'...

Agree with Vladan

But if you must do this using a cursor then

DECLARE @sql nvarchar(4000)

SET @sql = 'DECLARE c CURSOR FOR SELECT...

SET @strSQL1 = 'SELECT t1.col1, t1.col2, t2.col3 FROM mytable t2 INNER JOIN  ('

SET @strSQL2 = 'SELECT col1 AS col1, col2 AS col2'

SET @strSQL3 = ''

...code here to add...

You can EXEC more than 8000 chars by supplying more than one variable, eg

EXEC(sql1 + sql2 + sql3)

Why SLECT INTO ?

And why inside the EXEC ?

I just converted your...

DECLARE @start datetime, @end datetime

SET @start = DATEADD(month,DATEDIFF(month,0,GETDATE()),0)

SET @end = DATEADD(month,1,@start)

SELECT creative,COUNT(DISTINCT sessionid)

FROM [pagehits]

WHERE adate >= @start and adate < @end

GROUP BY creative