Thank you!  Been bugging hunting that one for a while.

Thank you, that did the trick!

Hi sorry for the delay in updating on this issue, and thank you again for all your help.

I found my db had a string split function. So I modified...

Hi and thanks again for getting back to me so quickly.

Yes it's the latter, the string splitting and then passing the values to the transaction that I'm primarily interested in....

Thank you for getting back to me on this.

I made a slight change to the code below and added a while loop to split the comma separated list up, and...

Thank you everyone who responded.

It turns out it was a false alarm, I mis-read the record count. There weren't more records after adding the additional filter.

Hi Craig, thanks for getting back to me so quickly. Yes, you are correct the pra.id should match, that's a type-o.

Hey thanks very much for the advice. Sorry I didn't get back sooner, been tied up.

Hi, thanks for getting back to me on this. I tried your suggestion and I got the errors below:

Errors:

Msg 4866, Level 16, State 1, Line 1

The bulk load failed....

Hi thanks for getting back to me so quickly on that. When I ran the query before without the substring function it ran really slowly also. Is there...

Hi, thanks for getting back to me on that.

Do you know of any training or certifications related to data mining that employers like?

Hey, I gave your tip a little more thought, tried it and it did the trick!

Thanks

Thanks for getting back to me on this.

The report I'm creating is for a client, they have a specified format that doesn't include drill down.

What I can't figure out is...

Thanks for getting back to me on this, my source is a table in SQL Server.

Thanks, that worked perfect.

What I'd like to do is schedule this query to run at the beginning of each month and send me the results.

Would you happen to have any...