Viewing 15 posts - 1 through 15 (of 17 total)
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...
January 17, 2020 at 11:44 am
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...
June 1, 2010 at 6:14 am
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...
May 21, 2010 at 7:34 am
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.
May 21, 2010 at 4:52 am
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...
September 29, 2009 at 5:07 pm
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...
September 29, 2009 at 12:08 pm
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...
September 29, 2009 at 11:59 am
Yep, that worked, Matt. I appreciate your patience helping me learn through this. 😉
September 22, 2009 at 9:33 am
Thanks, rjv. That was it.
September 22, 2009 at 9:30 am
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...
September 22, 2009 at 9:00 am
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,...
September 21, 2009 at 11:29 am
Matt Wilhoite (9/2/2009)
No problem, glad it worked. Have fun with the remaining logic in your process. Sounds like it should be fun.
Matt Wilhoite (9/2/2009)
Yeah, I don't think it will be...
September 2, 2009 at 12:18 pm
September 2, 2009 at 12:10 pm
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...
September 2, 2009 at 11:55 am
Thank for your insight, too, Flo.
August 27, 2009 at 8:07 am