pwalter83 (8/18/2014)

---

sgmunson (8/18/2014)

---

Okay, so now the excuse for not explaining EVERYTHING is that some of the columns aren't in use??? Really? Sorry, but I'm done with...

The reason it includes NOCHECK is to ensure that the index would get created. It might not be of much use, but imagine the complaints if the script...

Okay, so now the excuse for not explaining EVERYTHING is that some of the columns aren't in use??? Really? Sorry, but I'm done with this. ...

You need to be a lot more detailed about exactly what steps you took. You said you added the query to a job, but failed to state exactly...

Okay, then... It's become obvious that we simply do not have the proper understanding of your data. We need to know the following:

1.) What a record in...

If only this were a question easily answered... The problem is that no one is likely to be interested in sharing any actual rate information, as doing...

I still don't have any indication as to the results of the GROUP BY query I submitted. If you didn't run it because it uses a CTE, then...

The OP re-posted in a separate thread.

Umm... incomplete post?

I'm not sure I understand how "separation of duties" has any bearing on the...

Alex R (8/15/2014)

---

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. ...

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 know...

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 nvarchar(4000)

declare...

Try this:

declare @table_name varchar(100) = 'GLOBAL'

declare @date varchar(100) = 'OBJECTIDLIST'

declare @reduce varchar(10)...

Chris,

That's the idea, but because I have to expect the OP to identify where those fields come from that don't have a table alias, I didn't want to presume that...