If you were running this package as a SQL Server Agent scheduled task, what account does the script task actually run under? I have a similar job set up to...

I was trying to solve the same problem this morning. Being very much a rookie, I searched for help and came across this thread. In my case, my...

Thanks, Steve, your second example helps some more. I agree, the switch would be helpful.

Since it is Friday, I'm probably not going to think about this project again until...

Thanks for the reply, stevefromOZ.

The "poor man's way", lol. That is probably the direction I'm headed in, but struggling through all the "if's" when there's no "else" operator.

You can...

Thanks, piotr. Once Jack showed me the errors of my ways it made perfect sense how my results were as they were, exactly as you outlined. That was...

Thanks for the advice; I'll look into that. As you can probably tell, I'm pretty new at this stuff, learning as I go. I'm sure that studying the...

Thanks, Jack. That worked beautifully. I get it now. I had seen examples of moving the select criteria to the "On" statement but is amazing how much...

Yep, that worked, Matt. I appreciate your patience helping me learn through this. 😉

Thanks, rjv. That was it.

No worries, and thanks for the additional input.

I'm still doing something wrong, and researching the resolution via BOL and other sources, but the error I'm getting now in messages when...

Thanks for the tip, Matt. Its almost there...just have to figure out the "incorrect syntax near 'sp_executesql'" message. The good news is that if I remove that line,...

Yeah, I don't think it will be...

drew.allen (9/2/2009)

---

Here is what I believe is happening. Your FROM statement is doing an implicit join on the two tables. It is then calculating the original value for...

Matt, thanks. That worked very well. My background is more on Access where the Crosstab Wizard simply does it for you, and I'm still learning the SQL Pivot...

Thank for your insight, too, Flo.