That makes sense, thanks for that post.

I'm trying to mostly just get a push in the right direction rather than get the answer. I don't learn well if I'm...

Okay, that's not fair. I tried that before I posted all of this and got a syntax error.

I think that solved it, thanks man!

I don't think I can post data from work, against policy, tho I know it'd help immesurably 🙂

When I change the pivot statement to

PIVOT

(

nra_tax_country FOR update_source in (' +...

Oh, cool. I didn't even realize I could do that 🙂

Wonder if I should do it since Thursday is my last day. Might hand over your suggestion to...

I guess that's my question, how do I return the failure in the stored proc? Maybe I should just look at return values in stored procs:)

It's an execute sql task step in the control flow. Sorry, probably should have included that 🙂

another good point 🙂

Thanks for finding that for me.

show off 🙂

Oh, don't get me wrong. I would never set it up like that. It was a question that someone came to me with to see if I could...

It would have been much easier if I did, but in the example I was given, it was just two tables of data I had to combine. Thanks tho,...

Damn it, I knew it was something like that. Thanks. I have to be honest, I've never used it before.

Where are you putting the code in the 3rd part?

So, if I understand correctly, you have two lists, one should be dependent on the other, so if you click...

The other thing I would add is that having the sql server do the 'heavy lifting' inside the stored procedure is going to be faster than doing it inside the...

I think you should be able to add the field as a column in your query, and then put a textbox on your report in the header and set...

Okay, I see your point, and I have to admit, it feels good to be able to know that you solved the problem, even if it was something silly.

To tell...