sgmunson (8/15/2014)

---

Are you sure that the @date parameter should have a character value of OBJECTIDLIST ? That's not a terribly well-named parameter if it should. I...

sgmunson (8/15/2014)

---

Okay... got it solved. Try the following:

declare @table_name AS varchar(100) = 'GLOBAL'

declare @date AS varchar(100) = 'OBJECTIDLIST'

declare @reduce AS varchar(10) = '0.0025'

declare @oid AS nvarchar(4000) = '3476,6673'

declare@cmd AS...

sgmunson (8/15/2014)

---

Try this:

declare @table_name varchar(100) = 'GLOBAL'

declare @date varchar(100) = 'OBJECTIDLIST'

declare @reduce...

thanks for the help so far. I have tried reducing nvarchar(max) to nvarchar(4000), quotes around parameter values except for @reduce with no quotes

declare @table_name...

here is a full example

declare @table_name varchar(100) = 'GLOBAL'

declare @date varchar(100) = 'OBJECTIDLIST'

declare ...