Good question, this behaviour could be a gotcha.

Excellent, thanks.

No problem!

dbo.DelimitedSplit8K is the user-defined function described in the article I linked to in my second reply. It's only valid in MS SQL though.

It's basically a bit of code that will...

cdub11532 (1/17/2013)

---

Thanks for the reply. I know what the error means. I'm trying to figure out why when performing the loop it keeps putting in the same records multiple times....

On that PK violation - As far as I can tell, each loop just inserts the same data, so you will get the PK violation on the second iteration?

Yep, good clarification on the log chain.

Ok, think you'll need to split the parameter out in the query like the one here[/url]

So M10.PARTNO in (:Alloy)) becomes M10.PARTNO in ((SELECT Item FROM dbo.DelimitedSplit8K(:Alloy, ',')))

Assuming you're using MS...

Ha, beat me to it 🙂

You can backup with the COPY_ONLY clause which won't break the backup chain.

Try changing =join(Parameters!Alloy.Value, ", ") to just =Parameters!Alloy.Value

I was thinking something like that. Didn't get as far as actually writing (or testing) it though 🙂

CHECKDB on master also runs CHECKDB on the resource database, not sure if the errors are coming from that rather than master.

I get errors from running CHECKDB on a restored...

Hugo Kornelis (1/16/2013)

---

Data conversions with possibly unclean data; computations that could generate...

Nice question, good to remember.

I'm struggling to think what you'd be doing in a function that would require a TRY... CATCH 🙂